🎫 Auto-assign support tickets with JIRA, Supabase and AI
⚡ 1,920 views · 🎫 Ticket Management & Triage
Description
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 amount of manual work in managing the issue backlog for busy teams with little effort.
How it works
- This template contains 2 separate flows which run continuously via schedule triggers.
- The first populates our Supabase vector store with resolved issues within the last day. This helps keep our vector store up-to-date and relevant for the purpose of finding similar issues.
- It does this by pulling the latest resolved issues from JIRA and populating the Supabase vectorstore with carefully chosen metadata. This will come in handy later.
- The second flow watches for stale, unassigned issues for the purpose of aut-assigning to a relevant team member.
- It does this by comparing the stale issue against our vector store of resolved issues with the goal of identifying which team member would have best context regarding the issue.
- In a busy team, this may net a few team members as possible candidates to assign. Therefore, we can introduce additional logic to count each team member’s assigned, in-progress issues. This is intended to not overload our busiest members.
- The team member with the least assigned issues is pressumed to have the most capacity and therefore is assigned. A comennt is left in the issue to notify the team member that they’ve been auto-assigned due to age of issue.
How to use
- Modify the project and interval parameters to match those of your use-case and team members.
- Add additional criteria before assigning to a team member eg. department, as required.
Requirements
- OpenAI for LLM
- JIRA for Issue Management
- Supabase for Vector Store
Customising this workflow
- Not using JIRA or Supabase? The beauty of these AI templates are these components are entirely interchangeable with competing services. Try Linear and Qdrant instead!
- Auto-assigning logic is simplified in this template. Expand criteria as required for your team and organisation. eg. Might be a good idea to pull in annual leave information from HR system to prevent assigning to someone who is on currently on holiday!
🔗 Nodes Used
Jira Software, Schedule Trigger, AI Agent, Embeddings OpenAI, OpenAI Chat Model, Recursive Character Text Splitter
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File