Auto-assign support tickets with Jira and Supabase: n8n workflow

Auto-assign support tickets with Jira and Supabase

Started by a clock, and works across Jira and Supabase vectors. It puts OpenAI behind a retrieval step, so answers are drawn from documents you supply rather than from the model alone. 28 steps, 1 branch, 2 loops or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAIRetrieval

The flow

Starts it 2Model 10Logic 10Service 6

The steps in the order they run, from what starts it.

1Schedule TriggerSchedule triggerStarts it
2Embeddings OpenAIEmbeddings Open AiModel
3Recursive Character Text SplitterText Splitter Recursive Character Text SplitterModel
4Embeddings OpenAI1Embeddings Open AiModel
5OpenAI Chat ModelLm Chat Open AiModel
6Schedule Trigger1Schedule triggerStarts it
7OpenAI Chat Model1Lm Chat Open AiModel
8Last 50 ResolvedJiraService
9Issues Similarity DatabaseVector Store SupabaseModel
10Default Data LoaderDocument Default Data LoaderModel
11Supabase Vector StoreVector Store SupabaseModel
12Find Similar Issues + AssigneesAgentModel
13Get Unassigned Tickets more than 5 daysJiraService
14To Structured OutputInformation ExtractorModel
15Remove DuplicatesRemove DuplicatesLogic
16For Each IssueSplit In BatchesLogic
17Issues to ItemsSplit OutLogic
18Collect FieldsSetLogic
19Issue RefNo OpLogic
20If has Items?IfLogic
21For Each UserSplit In BatchesLogic
22SkipNo OpLogic
23Count Assigned Open Issues per UserSummarizeService
24Check User WorkflowJiraService
25Sort By Most CapacitySortLogic
26Tally In-Progress Issues per UserSetLogic
27Assign User to TicketJiraService
28Add Comment to IssueJiraService

How it's built

Starts on: A clock
Steps: 28, with 1 branch, 2 loops or waits
Size: Large: read it before trusting it with anything live
Connects to: Jira, Supabase vectors
Model: OpenAI
Retrieval: Answers are drawn from documents you supply, not from the model alone

Questions

What does it need to run?

An n8n account, plus your own Jira and Supabase vectors accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

Yes. It calls OpenAI. Its answers draw on documents you give it, not on the model alone. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 28 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 28 steps before you point it at anything that matters.