Automate Jira backlog hygiene and reporting with Slack, Gmail and GPT-4

by Rahul Joshi ✓ · 213 views · created 2025-10-17 · Project Management, AI Summarization

What this workflow does

This AI workflow has 15 nodes and runs on a schedule (cron 0 9 * * 1-5). Along the way it connects Jira Software, Google Sheets, Slack and Azure OpenAI Chat Model and 1 more.

How it runs

Trigger: On a schedule (cron 0 9 * * 1-5).

1. Fetch Jira Backlog (Jira Software): get many
2. Extract Jira Fields (Edit Fields (Set)): sets 10 fields: id, Status, Last Updated…
3. Aggregate: combines items into one
4. Check Overdue Tasks (If): checks a condition and branches into true / false
5. Log to Google Sheets (Google Sheets): append or update
6. Generate AI Digest (AI Agent): runs an AI agent, with model: Azure OpenAI Model; output parser: Structured Output Parser
7. Notify Issue Owner (Jira Software): notify (issue)
8. Slack: uses Slack
9. Check Missing Priority (If): checks a condition and branches into true / false
10. Email Weekly Digest (Gmail): uses Gmail

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

Services it uses

Jira SoftwareGoogle SheetsSlackAzure OpenAI Chat ModelGmail

Before you upgrade to n8n 3.0

Nodes used (11)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Jira Softwaren8n-nodes-base.jira
• Edit Fields (Set)n8n-nodes-base.set
• Google Sheetsn8n-nodes-base.googleSheets
• Ifn8n-nodes-base.if
• Slackn8n-nodes-base.slack
• Aggregaten8n-nodes-base.aggregate
• AI Agent@n8n/n8n-nodes-langchain.agent
• Azure OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatAzureOpenAi
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Gmailn8n-nodes-base.gmail

From the author

Description Automate Jira backlog management with intelligent cleanup, prioritization, and AI-powered reporting. This workflow scans daily to identify stale issues, missing priorities, and overdue tasks — auto-updates Jira with corrective labels, logs…

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