{ "edges": [ { "to": "289d850d-aeb2-475e-a810-822204ac98a6", "from": "53379a85-d8d5-4be5-bf67-e8df4e4098d7", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "79cc28a5-7047-40ee-816e-ea61635ad230", "from": "c5ac2613-c23e-40c3-b0ff-0bb805b876e1", "toPort": "0", "fromPort": "0" }, { "to": "32153f43-2620-40d6-98d9-7793d756d206", "from": "289d850d-aeb2-475e-a810-822204ac98a6", "toPort": "0", "fromPort": "0" }, { "to": "289d850d-aeb2-475e-a810-822204ac98a6", "from": "be03f5d0-6e99-44a8-8d3c-3c293fe58602", "toPort": "0", "fromPort": "0" }, { "to": "11751464-7ff3-40fa-8dd1-c78b008a0dd2", "from": "ef72046f-dd55-429d-be00-c9324dbccaf1", "toPort": "0", "fromPort": "0" }, { "to": "ef9c4252-1781-4ee0-b0c7-583765206a89", "from": "ef72046f-dd55-429d-be00-c9324dbccaf1", "toPort": "0", "fromPort": "0" }, { "to": "1e90d54a-7e05-4cce-859c-ddd62cb498d6", "from": "ef72046f-dd55-429d-be00-c9324dbccaf1", "toPort": "0", "fromPort": "1" }, { "to": "be03f5d0-6e99-44a8-8d3c-3c293fe58602", "from": "79cc28a5-7047-40ee-816e-ea61635ad230", "toPort": "0", "fromPort": "0" }, { "to": "ef72046f-dd55-429d-be00-c9324dbccaf1", "from": "79cc28a5-7047-40ee-816e-ea61635ad230", "toPort": "0", "fromPort": "0" }, { "to": "4c294ed5-4ae4-4d24-97f9-575cca486366", "from": "79cc28a5-7047-40ee-816e-ea61635ad230", "toPort": "0", "fromPort": "0" }, { "to": "cfca36aa-3f46-4027-8d29-5ef5137e338c", "from": "1e90d54a-7e05-4cce-859c-ddd62cb498d6", "toPort": "0", "fromPort": "0" }, { "to": "11cc0368-975c-4bc0-a2ef-c467df83569d", "from": "1e90d54a-7e05-4cce-859c-ddd62cb498d6", "toPort": "0", "fromPort": "0" }, { "to": "c5ac2613-c23e-40c3-b0ff-0bb805b876e1", "from": "ef8e559f-6e94-42c5-a70e-6cfd6ddea13f", "toPort": "0", "fromPort": "0" }, { "to": "289d850d-aeb2-475e-a810-822204ac98a6", "from": "6364596e-43e2-402a-a285-1740094c475f", "toPort": "0", "fromPort": "ai_outputParser" } ], "nodes": [ { "id": "ef8e559f-6e94-42c5-a70e-6cfd6ddea13f", "name": "Daily Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "cronExpression", "expression": "0 9 * * 1-5" } ] } }, "position": [ -1680, -416 ] }, { "id": "c5ac2613-c23e-40c3-b0ff-0bb805b876e1", "name": "Fetch Jira Backlog", "type": "integration", "params": { "options": { "jql": "project = YOUR_PROJECT_KEY AND status in (\"Backlog\") ORDER BY created DESC" }, "service": "jira", "operation": "getAll", "returnAll": true }, "position": [ -1456, -416 ] }, { "id": "79cc28a5-7047-40ee-816e-ea61635ad230", "name": "Extract Jira Fields", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "65a9ad90-fc3a-4b15-a5db-57040972f1eb", "name": "id", "type": "string", "value": "={{ $json.id }}" }, { "id": "a6e676d7-d345-4805-8947-c89246e250cb", "name": "Status", "type": "string", "value": "={{ $json.fields.status.name }}" }, { "id": "329be7f5-f4b6-4c2d-8633-f4cc5c600f5a", "name": "Last Updated", "type": "string", "value": "={{ $json.fields.updated }}" }, { "id": "6074d876-e5d4-4292-bdcc-dacce44367e9", "name": "Created", "type": "string", "value": "={{ $json.fields.created }}" }, { "id": "f45794be-a5a2-4267-8959-6b3a628bdf33", "name": "Assignee", "type": "string", "value": "={{ $json.fields.reporter?.displayName || 'Unassigned' }}" }, { "id": "d45594fe-3f25-4deb-9a33-1ae5da08a62a", "name": "Due Date", "type": "string", "value": "={{ $json.fields.duedate || '' }}" }, { "id": "255fac2f-a504-4937-bfbb-4ab6d11ab85c", "name": "Priority", "type": "string", "value": "={{ $json.fields.priority?.name || '' }}" }, { "id": "d1b9ba34-6836-470d-a4f8-06b50426f570", "name": "key", "type": "string", "value": "={{ $json.key }}" }, { "id": "6df7df50-6844-498f-acad-125d0aac25e7", "name": "email", "type": "string", "value": "={{ $json.fields.creator?.emailAddress || '' }}" }, { "id": "a4ffc18e-cc88-408d-bd22-fd915092b8c3", "name": "Summary", "type": "string", "value": "={{ $json.fields.summary || $json.fields.issuetype.description }}" } ] } }, "position": [ -1232, -416 ] }, { "id": "4c294ed5-4ae4-4d24-97f9-575cca486366", "name": "Log to Google Sheets", "type": "integration", "params": { "columns": { "value": {}, "schema": [ { "id": "id", "type": "string", "display": true, "required": false, "displayName": "id", "defaultMatch": true, "canBeUsedToMatch": true }, { "id": "Status", "type": "string", "display": true, "required": false, "displayName": "Status", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Last Updated", "type": "string", "display": true, "required": false, "displayName": "Last Updated", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Created", "type": "string", "display": true, "required": false, "displayName": "Created", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Assignee", "type": "string", "display": true, "required": false, "displayName": "Assignee", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Due Date", "type": "string", "display": true, "required": false, "displayName": "Due Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Priority", "type": "string", "display": true, "required": false, "displayName": "Priority", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "key", "type": "string", "display": true, "required": false, "displayName": "key", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "email", "type": "string", "display": true, "required": false, "displayName": "email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Summary", "type": "string", "display": true, "required": false, "displayName": "Summary", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "autoMapInputData", "matchingColumns": [ "id" ] }, "options": {}, "service": "googleSheets", "operation": "appendOrUpdate", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultName": "Backlogs" }, "documentId": { "__rl": true, "mode": "list", "value": "YOUR_SHEET_ID", "cachedResultName": "Backlog Audit Log" } }, "position": [ -1008, -368 ] }, { "id": "ef72046f-dd55-429d-be00-c9324dbccaf1", "name": "Check Overdue Tasks", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "c92605e8-e7aa-494b-86ba-ca0d20244af8", "operator": { "type": "dateTime", "operation": "before" }, "leftValue": "={{ $json[\"Due Date\"] }}", "rightValue": "={{ new Date(Date.now())}}" } ] } }, "position": [ -1008, -704 ] }, { "id": "11751464-7ff3-40fa-8dd1-c78b008a0dd2", "name": "Notify Issue Owner", "type": "integration", "params": { "service": "jira", "issueKey": "={{ $json.key }}", "resource": "issue", "operation": "notify", "jiraVersion": "cloud", "jsonParameters": false, "additionalFields": { "subject": "Overdue Task: {{ $json.Summary }}", "textBody": "This issue is overdue and requires immediate attention. Please review and update the status or due date." }, "notificationRecipientsUi": { "notificationRecipientsValues": { "users": [], "groups": [], "voters": false, "assignee": true, "reporter": true, "watchers": false } }, "notificationRecipientsRestrictionsUi": {} }, "position": [ -720, -896 ] }, { "id": "ef9c4252-1781-4ee0-b0c7-583765206a89", "name": "Slack Alert - Overdue", "type": "integration", "params": { "text": "=🔴 *Overdue Backlog Item*\n\n*Summary:* {{ $json.Summary }}\n*Issue:* {{ $json.key }}\n*Due Date:* {{ $json['Due Date'] }}\n*Assignee:* {{ $json.Assignee }}\n*Status:* {{ $json.Status }}\n\nThis item is overdue and needs immediate attention.", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "list", "value": "YOUR_CHANNEL_ID", "cachedResultName": "backlog-alerts" }, "operation": "read", "otherOptions": {} }, "position": [ -720, -704 ] }, { "id": "1e90d54a-7e05-4cce-859c-ddd62cb498d6", "name": "Check Missing Priority", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "630bf2fe-1811-4058-846e-04563f4d8530", "operator": { "type": "string", "operation": "empty", "singleValue": true }, "leftValue": "={{ $json.Priority }}", "rightValue": "" } ] } }, "position": [ -720, -512 ] }, { "id": "cfca36aa-3f46-4027-8d29-5ef5137e338c", "name": "Tag with 'Needs-Priority'", "type": "integration", "params": { "service": "jira", "issueKey": "={{ $json.key }}", "operation": "update", "updateFields": { "labels": "={{ [\"Needs-Priority\"] }}" } }, "position": [ -432, -608 ] }, { "id": "11cc0368-975c-4bc0-a2ef-c467df83569d", "name": "Slack Alert - Missing Priority", "type": "integration", "params": { "text": "=⚠️ *Missing Priority*\n\n*Summary:* {{ $json.Summary }}\n*Issue:* {{ $json.key }}\n*Assignee:* {{ $json.Assignee }}\n*Status:* {{ $json.Status }}\n*Due Date:* {{ $json['Due Date'] }}\n\nThis issue has been tagged with \"Needs-Priority\" label. Please assign a priority.", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "list", "value": "YOUR_CHANNEL_ID", "cachedResultName": "backlog-alerts" }, "operation": "read", "otherOptions": {} }, "position": [ -432, -416 ] }, { "id": "be03f5d0-6e99-44a8-8d3c-3c293fe58602", "name": "Aggregate All Items", "type": "passthrough", "params": { "mode": "aggregate", "options": {}, "aggregate": "aggregateAllItemData" }, "position": [ -1008, -176 ] }, { "id": "289d850d-aeb2-475e-a810-822204ac98a6", "name": "Generate AI Digest", "type": "llm", "params": { "text": "=Analyze the following Jira backlog items and generate an email for the project manager.\n\nEach item includes: issue ID, key, assignee, status, due date, priority, and summary.\n\nYour goal:\n- Identify overdue tasks (due date before today).\n- Highlight items with missing priority.\n- Summarize the overall backlog health.\n- Suggest 2-3 actionable steps to improve backlog hygiene.\n- Mention how many issues fall into each category.\n\nBacklog data:\n{{ JSON.stringify($json) }}", "prompt": "=Analyze the following Jira backlog items and generate an email for the project manager.\n\nEach item includes: issue ID, key, assignee, status, due date, priority, and summary.\n\nYour goal:\n- Identify overdue tasks (due date before today).\n- Highlight items with missing priority.\n- Summarize the overall backlog health.\n- Suggest 2-3 actionable steps to improve backlog hygiene.\n- Mention how many issues fall into each category.\n\nBacklog data:\n{{ JSON.stringify($json) }}", "options": { "systemMessage": "You are an automation assistant for project management and engineering teams.\nYour role is to analyze Jira backlog data and generate a professional HTML email for a project or engineering manager that summarizes the backlog health and highlights key actions.\n\nOutput Requirements:\n- The output must be a valid JSON object with two keys:\n {\n \"Subject\": \"\",\n \"Body\": \"\"\n }\n\nFormatting & Tone Guidelines:\n- Maintain a clear, concise, and professional business tone.\n- Use semantic HTML tags such as

, , , and for readability.\n- Do not include any Markdown or code formatting.\n- The HTML should be visually structured and ready to send directly via email.\n- Always start with a short greeting (e.g., \"Dear Project Manager,\").\n- Follow with a summary paragraph that states the purpose of the email (e.g., \"Here's the latest Jira backlog summary for this week.\").\n- Include clearly formatted sections for:\n 1. Overdue Tasks\n 2. Missing Priorities\n 3. General Backlog Health\n- Add an HTML table if helpful for listing issue details (Key, Summary, Assignee, Due Date, Priority).\n- End the email with an \"Actionable Recommendations\" section listing 2-3 clear next steps.\n- Close politely (e.g., \"Regards, Backlog Hygiene Assistant\").\n- Keep the email content under 300 words.\n\nBehavior:\n- Analyze patterns and highlight areas needing attention.\n- Summarize counts of overdue, missing priority, or stale issues.\n- Suggest actionable next steps to improve backlog hygiene.\n- The output must be clean, valid JSON and contain no Markdown or triple backticks." }, "provider": "openai", "promptType": "define", "approximated": true, "systemMessage": "You are an automation assistant for project management and engineering teams.\nYour role is to analyze Jira backlog data and generate a professional HTML email for a project or engineering manager that summarizes the backlog health and highlights key actions.\n\nOutput Requirements:\n- The output must be a valid JSON object with two keys:\n {\n \"Subject\": \"\",\n \"Body\": \"\"\n }\n\nFormatting & Tone Guidelines:\n- Maintain a clear, concise, and professional business tone.\n- Use semantic HTML tags such as
,
,
, , , and
for readability.\n- Do not include any Markdown or code formatting.\n- The HTML should be visually structured and ready to send directly via email.\n- Always start with a short greeting (e.g., \"Dear Project Manager,\").\n- Follow with a summary paragraph that states the purpose of the email (e.g., \"Here's the latest Jira backlog summary for this week.\").\n- Include clearly formatted sections for:\n 1. Overdue Tasks\n 2. Missing Priorities\n 3. General Backlog Health\n- Add an HTML table if helpful for listing issue details (Key, Summary, Assignee, Due Date, Priority).\n- End the email with an \"Actionable Recommendations\" section listing 2-3 clear next steps.\n- Close politely (e.g., \"Regards, Backlog Hygiene Assistant\").\n- Keep the email content under 300 words.\n\nBehavior:\n- Analyze patterns and highlight areas needing attention.\n- Summarize counts of overdue, missing priority, or stale issues.\n- Suggest actionable next steps to improve backlog hygiene.\n- The output must be clean, valid JSON and contain no Markdown or triple backticks.", "hasOutputParser": true }, "position": [ -784, -176 ] }, { "id": "53379a85-d8d5-4be5-bf67-e8df4e4098d7", "name": "Azure OpenAI Model", "type": "llm", "params": { "model": "gpt-4o-mini", "options": {}, "provider": "openai" }, "position": [ -768, 64 ] }, { "id": "6364596e-43e2-402a-a285-1740094c475f", "name": "Structured Output Parser", "type": "passthrough", "params": { "mode": "noOp", "jsonSchemaExample": "{\n\t\"Subject\": \"\",\n\t\"Body\": \"\"\n}" }, "position": [ -640, 64 ] }, { "id": "32153f43-2620-40d6-98d9-7793d756d206", "name": "Email Weekly Digest", "type": "integration", "params": { "sendTo": "user@example.com", "message": "={{ $json.output.Body }}", "options": {}, "service": "gmail", "subject": "={{ $json.output.Subject }}", "operation": "read" }, "position": [ -432, -176 ] } ] }

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