This n8n template builds a simple automation to ensure no JIRA issues go unassigned for more than a week to prevent them from 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 vector store with carefully chosen metadata. This will come in handy later.

The second flow watches for stale, unassigned issues for the purpose of auto-assigning them 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 the 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 presumed to have the most capacity and therefore is assigned. A comment is left in the issue to notify the team member that they’ve been auto-assigned due to the age of the 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, e.g., department, as required.

Customizing this workflow

Not using JIRA or Supabase? The beauty of these AI templates is that 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 organization. E.g., it might be a good idea to pull in annual leave information from the HR system to prevent assigning to someone who is currently on holiday!