What This Automation Does
This workflow checks Jira every day for unresolved issues older than 7 days.
It collects all comments and details for each issue.
Then it uses GPT-4 to decide if the issue is solved, needs more info, or still waiting.
If unsolved, AI looks for answers in Jira and Notion then tries to solve or remind.
It also rates customer feelings and sends messages to Slack or Jira.
This saves time by closing or alerting about stale tickets.
Tools and Services Used
- Jira Software Cloud API: Fetches and updates issues and comments.
- OpenAI GPT-4 Model: Classifies issue status and analyzes comments.
- Notion API: Searches knowledge base for solutions.
- Slack API: Sends notifications for negative feedback or unresolved issues.
- n8n Automation Platform: Runs and manages the workflow.
Inputs, Processing Steps, and Outputs
Inputs
- Daily trigger from n8n.
- Jira issues older than 7 days with status “To Do” or “In Progress”.
- Issue metadata and comments.
- Knowledge base content from Notion.
- Configured API Keys and credentials.
Processing Steps
- Schedule triggers daily run.
- Fetch list of unresolved long-lived Jira issues using JQL.
- Process each issue separately using an execution loop.
- Extract issue details and gather all comments.
- Format comments and issue summary for GPT input.
- Use GPT-4 to classify the issue state: resolved, pending info, or still waiting.
- For resolved issues, analyze customer sentiment.
- If sentiment positive, send feedback request; if negative, alert Slack and close with comments.
- For pending more info, query Jira and Notion knowledge bases using AI agent.
- Post solution or notify reporter and close the issue.
- For still waiting issues, send reminders if last comment not from bot.
- Notify Slack about unresolved or problematic tickets.
Outputs
- Auto-comments added to Jira issues.
- Issues closed if resolved or automated.
- Feedback requests sent to customers.
- Reminders posted on pending tickets.
- Slack notifications for support teams.
Beginner Step-by-Step: How to Use This Workflow in n8n
Step 1: Download and Import
- Find the Download button on this page and save the workflow file.
- Open your n8n editor where you want to add this automation.
- Use Import from File option and select the saved workflow.
Step 2: Add Credentials and API Keys
- Go to the credentials section in n8n.
- Add or update API Keys for Jira, OpenAI (GPT-4), Slack, and Notion.
- Make sure you have permission to read and write in Jira and Slack.
Step 3: Update Identifiers and Settings
- Check inside Jira nodes for correct project ID or board IDs.
- Update Slack channel ID and email addresses if needed.
- Make sure Notion database IDs or URLs are correct.
- If there are prompt templates or URLs in text input nodes, review and edit as needed.
Step 4: Test the Workflow
- Run the workflow manually inside n8n with sample Jira issues.
- Watch the progress and check for errors.
- Verify comments added to Jira and Slack notifications.
Step 5: Activate for Production
- Once testing goes well, toggle the workflow active.
- The daily schedule will trigger the workflow automatically.
- Monitor run logs to catch problems early.
For users hosting n8n themselves, check out self-host n8n to maintain full control.
Why This Workflow Exists
Many Jira tickets stay open too long without updates.
Teams waste lot of time chasing these old issues.
This workflow finds and handles these tickets fast.
It helps support teams close or flag problems on time.
No need for manual checks every day.
It improves customer experience by quickly requesting feedback or solutions.
Customization Ideas
- Change Jira issue age in JQL to less than 7 days for stricter checks.
- Replace GPT-4o-mini with other GPT-3.5 or full GPT-4 to balance cost vs performance.
- Add more knowledge sources like Confluence or Google Docs for wider solution search.
- Edit Slack messages to include issue priority or severity.
- Add language detection to handle tickets in multiple languages.
Troubleshooting
No issues returned by Jira node
Check the JQL query syntax.
Ensure API user has rights to read projects queried.
Errors parsing AI output in KnowledgeBase Agent
Confirm output parser schema matches GPT response format.
Make prompts clear to follow expected JSON structure.
Reminders missing or repeating
Review condition node filtering last message author.
Prevents sending reminders when last comment is bot-generated.
Pre-Production Checklist
- Confirm Schedule Trigger fires daily.
- Verify Jira JQL outputs expected issues.
- Test all API credentials in Jira, Slack, OpenAI, and Notion.
- Run test issues through full workflow to check AI classification.
- Check Slack notifications arrive correctly.
- Review AI comments on Jira for formatting.
Deployment Guide
After testing, activate the workflow in n8n editor.
Daily runs will process and update tickets automatically.
Watch logs for errors and adjust schedule or queries as needed.
This keeps team informed with Slack alerts and Jira comments.
Summary of Benefits and Outcomes
✓ Save over 10 hours weekly by automating ticket follow-ups.
✓ Reduce backlog by automatically closing or reminding about old Jira issues.
✓ Improve customer support with timely feedback and escalation.
✓ Keep team notified on Slack about issues needing attention.
✓ Focus team’s energy on new and urgent tickets.
