Triage and resolve stale Jira tickets with OpenAI, Notion, and Slack
Needs changesWhat this workflow does
This AI workflow has 29 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects OpenAI Chat Model, Jira Software, Slack and Notion.
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Get List of Unresolved Long Lived Issues (Jira Software): get many
- Get Issue Metadata (Edit Fields (Set)): sets 8 fields: key, title, url…
- Execute Workflow (Execute Sub-workflow): calls another n8n workflow
- Get Issue Comments (Jira Software): get many (issue comment)
- Join Comments (Aggregate): combines items into one
- Simplify Thread For AI (Edit Fields (Set)): sets 2 fields: thread, topic
- Classify Current Issue State (Text Classifier): classifies text into categories with AI, with model: OpenAI Chat Model
- Customer Satisfaction Agent (Sentiment Analysis): scores sentiment with AI, with model: OpenAI Chat Model
- Last Message is Not Bot (If): checks a condition and branches into true / false
- KnowledgeBase Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 2 tools (Find Simlar Issues, Query KnowledgeBase); output parser: Structured Output Parser
…plus 10 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in KnowledgeBase Agent (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) KnowledgeBase Agent (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (16)
- OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Jira Software
n8n-nodes-base.jira - Aggregate
n8n-nodes-base.aggregate - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Slack
n8n-nodes-base.slack - Execute Sub-workflow
n8n-nodes-base.executeWorkflow - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - Sentiment Analysis
@n8n/n8n-nodes-langchain.sentimentAnalysis - AI Agent
@n8n/n8n-nodes-langchain.agent - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Jira Tool
n8n-nodes-base.jiraTool - Notion Tool
n8n-nodes-base.notionTool - Text Classifier
@n8n/n8n-nodes-langchain.textClassifier
From the author
Quick overview This scheduled workflow scans Jira for long-lived unresolved issues, uses OpenAI to classify their status and sentiment, searches Notion and similar Jira issues for answers, then posts reminders or resolutions, closes tickets, and alerts a…