Templates / Auto-assign support tickets with JIRA, Supabase and AI

Auto-assign support tickets with JIRA, Supabase and AI

Needs changes

by Jimleuk ✓ · 2,039 views · created 2025-04-01 · Ticket Management, AI RAG

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 28 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Embeddings OpenAI, Supabase Vector Store, OpenAI Chat Model and Jira Software.

How it runs

Trigger: On a schedule (every day) (plus 1 other trigger).

  1. Last 50 Resolved (Jira Software): get many
  2. Get Unassigned Tickets more than 5 days (Jira Software): get many
  3. Remove Duplicates: removes duplicate items
  4. For Each Issue (Loop Over Items (Split in Batches)): loops over the items in batches
  5. Collect Fields (Edit Fields (Set)): sets 9 fields: project_key, issue_key, issue_type…
  6. Issues Similarity Database (Supabase Vector Store): stores documents in the Supabase vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader
  7. Find Similar Issues + Assignees (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (Supabase Vector Store)
  8. To Structured Output (Information Extractor): extracts structured fields from text with AI, with model: OpenAI Chat Model
  9. Issues to Items (Split Out): splits a list into separate items
  10. If: checks a condition and branches into true / false

…plus 7 more steps. See the full node list below.

Services it uses

Embeddings OpenAISupabase Vector StoreOpenAI Chat ModelJira Software

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 Find Similar Issues + Assignees (v1.7): 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.0Replace with
AI Agent v1 (old agent modes)
Find Similar Issues + Assignees (v1.7)
Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Nodes used (17)

From the author

This n8n template builds a simple automation to ensure no JIRA issues go unassigned for more than a week to prevent them falling through the cracks. It uses AI to perform searching tasks against a Supabase Vector Store. This can be one way to help reduce the…

Excerpt from Jimleuk's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.