Turn support tickets into developer insights with OpenAI, Postgres, Slack and Jira
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 16 nodes and runs on a schedule (every day at 02:00). Along the way it connects Postgres, OpenAI Chat Model, Slack and Jira Software.
How it runs
Trigger: On a schedule (every day at 02:00).
- Workflow Configuration (Edit Fields (Set)): sets 9 fields: timeWindowDays, similarityThreshold, frequencyWeight…
- Fetch Feedback Data (Postgres): run a query
- Preprocess & Deduplicate (Code): runs custom JavaScript code
- Generate Embeddings & Cluster (Code): runs custom JavaScript code
- Aggregate: combines items into one
- Root Cause Analysis Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model; output parser: Root Cause Schema Parser
- Calculate Severity Scores (Code): runs custom JavaScript code
- Developer Report Generator (AI Agent): runs an AI agent, with model: Report Generator Model
- Check Delivery Options (If): checks a condition and branches into true / false
- Send to Slack (Slack): uses Slack
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Postgres
n8n-nodes-base.postgres - Code
n8n-nodes-base.code - Aggregate
n8n-nodes-base.aggregate - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - AI Agent
@n8n/n8n-nodes-langchain.agent - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Send Email
n8n-nodes-base.emailSend - Jira Software
n8n-nodes-base.jira
From the author
Overview This workflow transforms raw support tickets into actionable developer insights using AI and data processing. It automatically detects recurring issues, identifies root causes, ranks severity, and generates a structured engineering report. By…