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 everything into Google Sheets for tracking, and notifies teams via Slack. Every Friday, it sends an AI-generated backlog summary email to project leads for visibility and planning. 🚀📅
What This Template Does
Step 1: Triggers automatically every we
使用的节点
Google SheetsSlackJira SoftwareGmailAI AgentStructured Output ParserAzure OpenAI Chat Model
工作流预览
🎯 Backlog Hygiene & Auto-Grooming
Automated Jira backlog management that identifies issue
What it does:
- Runs weekdays at 9 AM t
⏰ Weekday Mornings
Runs Mon-Fri at 9:00 AM to groom backlog.
Schedule: `0 9 * * 1-5`
Timing: Daily at 09:00 on weekdays
📋 Fetch Backlog Items
Setup Required:
1. Replace `YOUR_PROJECT_KEY` with your Jira project ke
2. Connect Jira credentials
Fetches: All issues in "Backlog" status, ordered by cre
🔄 Field Extraction
Maps Jira fields to clean, usable data.
Extracted Fields:
- ID, Key, Status, Summary
- Created & Last Updated dates
- Assignee & Creator email
📊 Audit Trail
Setup Required:
1. Replace `YOUR_SHEET_ID` with Google Sheets document
2. Connect Google OAuth2 credentials
Logs: All backlog items with timestamps for historical
⏰ Overdue Filter
Logic: Checks if Due Date is before today
True Branch: Overdue tasks
- Sends Jira notification
- Posts Slack alert
False Branch: Not overdue
📧 Jira Notification
Setup Required:
1. Uses same Jira credentials
2. Removed hardcoded user/group IDs
Sends: In-app Jira notification to reporter and assigne
💬 Slack - Overdue
Setup Required:
1. Replace `YOUR_CHANNEL_ID` with Slack channel ID
2. Connect Slack API credentials
Posts: Real-time alert for overdue items with full cont
🏷️ Priority Check
Logic: Checks if Priority field is empty
True Branch: Missing priority
- Tags issue with "Needs-Priority" label
- Posts Slack alert
False Branch: Priority exists
🏷️ Auto-Tag Issue
Setup Required:
1. Uses same Jira credentials
Action: Automatically adds "Needs-Priority" label to is
💬 Slack - Priority
Setup Required:
1. Use same Slack channel ID and credentials
Posts: Alert for issues missing priority with action ta
📦 Combine Data
Aggregates all backlog items into single payload for AI
Purpose: Prepares comprehensive dataset for AI to analy
🤖 AI Analysis Engine
What it does:
- Analyzes all backlog items using AI
- Identifies patterns and trends
- Generates structured JSON output with Subject and HTM
Requires: Azure Ope
🔗 AI Model Config
Setup Required:
1. Replace credential ID with your Azure OpenAI credent
2. Model: gpt-4o-mini (cost-effective)
Connects: To AI agent for language processing
📋 Output Parser
Ensures AI returns valid JSON with:
- Subject: Email subject line
- Body: HTML formatted email
No setup required - connects to AI agent automatically
