{ "edges": [ { "to": "e3f85e5e-2552-4ffc-a05b-e204e65955d1", "from": "0914ca57-8aeb-474b-bb51-473854353e4f", "toPort": "0", "fromPort": "0" }, { "to": "1ad0a222-37d2-4529-baf7-46fdcf31a704", "from": "6d07db03-aa56-43ec-bad8-ba089d2b973a", "toPort": "0", "fromPort": "0" }, { "to": "cd553b4f-2e1b-42c8-9db2-13ccc0c5b2ed", "from": "03f0b995-e4d5-45d4-90ec-fd987ae34833", "toPort": "0", "fromPort": "0" }, { "to": "0914ca57-8aeb-474b-bb51-473854353e4f", "from": "03f0b995-e4d5-45d4-90ec-fd987ae34833", "toPort": "0", "fromPort": "0" }, { "to": "27003e76-5b0b-4ff5-928a-9d3d9a062c1f", "from": "03f0b995-e4d5-45d4-90ec-fd987ae34833", "toPort": "0", "fromPort": "0" }, { "to": "27dcf4a8-02ad-4ee5-b599-0675c696e34e", "from": "185308d0-69ba-44f1-bdbe-a93ce06a5209", "toPort": "0", "fromPort": "0" }, { "to": "6d07db03-aa56-43ec-bad8-ba089d2b973a", "from": "27dcf4a8-02ad-4ee5-b599-0675c696e34e", "toPort": "0", "fromPort": "0" }, { "to": "03f0b995-e4d5-45d4-90ec-fd987ae34833", "from": "1ad0a222-37d2-4529-baf7-46fdcf31a704", "toPort": "0", "fromPort": "0" }, { "to": "11f3c704-bca8-4273-9a2d-bb6cf551f47d", "from": "1ad0a222-37d2-4529-baf7-46fdcf31a704", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "185308d0-69ba-44f1-bdbe-a93ce06a5209", "name": "Trigger (Nightly Run)", "type": "trigger", "params": { "kind": "n8n-nodes-base.cron", "triggerTimes": { "item": [ {} ] } }, "position": [ -736, -144 ] }, { "id": "6d07db03-aa56-43ec-bad8-ba089d2b973a", "name": "Filter Dependencies", "type": "if", "params": { "conditions": { "string": [ { "value1": "={{ $json.fields.issuelinks }}", "operation": "isNotEmpty" } ] } }, "position": [ -304, -144 ] }, { "id": "1ad0a222-37d2-4529-baf7-46fdcf31a704", "name": "Extract Dependency Details", "type": "code", "params": { "functionCode": "const items = [];\n\nfor (const item of $input.all()) {\n const issue = item.json;\n const issueKey = issue.key;\n const summary = issue.fields.summary;\n const dueDate = issue.fields.duedate || 'No due date';\n const assignee = issue.fields.assignee?.displayName || 'Unassigned';\n const assigneeEmail = issue.fields.assignee?.emailAddress || '';\n const issueLinks = issue.fields.issuelinks || [];\n \n // Process each issue link\n for (const link of issueLinks) {\n const linkTypeName = link.type.name;\n let dependencyType = '';\n let linkedIssueKey = '';\n let linkedIssueSummary = '';\n let linkedIssueStatus = '';\n let linkedIssuePriority = '';\n \n // Check if this issue is blocked by another issue (inwardIssue)\n if (link.inwardIssue) {\n dependencyType = link.type.inward; // \"is blocked by\"\n linkedIssueKey = link.inwardIssue.key;\n linkedIssueSummary = link.inwardIssue.fields?.summary || '';\n linkedIssueStatus = link.inwardIssue.fields?.status?.name || '';\n linkedIssuePriority = link.inwardIssue.fields?.priority?.name || '';\n }\n // Check if this issue blocks another issue (outwardIssue)\n else if (link.outwardIssue) {\n dependencyType = link.type.outward; // \"blocks\"\n linkedIssueKey = link.outwardIssue.key;\n linkedIssueSummary = link.outwardIssue.fields?.summary || '';\n linkedIssueStatus = link.outwardIssue.fields?.status?.name || '';\n linkedIssuePriority = link.outwardIssue.fields?.priority?.name || '';\n }\n \n // Only add items where we found a linked issue\n if (linkedIssueKey) {\n items.push({\n json: {\n issueKey,\n summary,\n dueDate,\n assignee,\n assigneeEmail,\n linkType: linkTypeName,\n dependencyType,\n linkedIssueKey,\n linkedIssueSummary,\n linkedIssueStatus,\n linkedIssuePriority\n }\n });\n }\n }\n}\n\nreturn items;" }, "position": [ -80, -144 ] }, { "id": "03f0b995-e4d5-45d4-90ec-fd987ae34833", "name": "Compute Impact Score", "type": "code", "params": { "functionCode": "const items = [];\n\nfor (const item of $input.all()) {\n const jiraData = item.json;\n const issueKey = jiraData.issueKey;\n const dueDate = jiraData.dueDate;\n const linkedIssueKey = jiraData.linkedIssueKey;\n \n let daysTillDue = 999;\n let riskFlag = 'Low';\n \n if (dueDate && dueDate !== 'No due date') {\n const today = new Date();\n const due = new Date(dueDate);\n daysTillDue = Math.ceil((due - today) / (1000 * 60 * 60 * 24));\n \n if (daysTillDue < 7) {\n riskFlag = 'High';\n } else if (daysTillDue < 14) {\n riskFlag = 'Medium';\n }\n }\n \n const blockerCount = jiraData.dependencyType === 'is blocked by' ? 1 : 0.5;\n const impactScore = Math.round(blockerCount * Math.max(1, 30 - daysTillDue));\n \n items.push({\n json: {\n ...jiraData,\n daysTillDue,\n riskFlag,\n impactScore\n }\n });\n}\n\nreturn items;" }, "position": [ 144, -48 ] }, { "id": "11f3c704-bca8-4273-9a2d-bb6cf551f47d", "name": "Create Monday.com Item", "type": "integration", "params": { "name": "={{ $json.summary }}", "boardId": "YOUR_BOARD_ID", "groupId": "topics", "service": "monday", "resource": "boardItem", "operation": "read", "additionalFields": {} }, "position": [ 144, -240 ] }, { "id": "e3f85e5e-2552-4ffc-a05b-e204e65955d1", "name": "Send Email Report", "type": "integration", "params": { "sendTo": "user@example.com", "message": "={{ $json.html }}", "options": {}, "service": "gmail", "subject": "={{ $json.subject }}", "operation": "read" }, "position": [ 592, -240 ] }, { "id": "cd553b4f-2e1b-42c8-9db2-13ccc0c5b2ed", "name": "Create Coordination Task", "type": "integration", "params": { "project": { "__rl": true, "mode": "list", "value": "YOUR_PROJECT_ID", "cachedResultName": "Coordination Project" }, "service": "jira", "summary": "=Dependency Coordination: {{ $json.issueKey }} → {{ $json.linkedIssueKey }}", "issueType": { "__rl": true, "mode": "list", "value": "10006", "cachedResultName": "Task" }, "operation": "read", "additionalFields": { "description": "=Impact Score: {{ $json.impactScore }}\\nRisk Level: {{ $json.riskFlag }}\\nDays Till Due: {{ $json.daysTillDue }}\\n\\nSource Issue: {{ $json.issueKey }} - {{ $json.summary }}\\nBlocked By: {{ $json.linkedIssueKey }} - {{ $json.linkedIssueSummary }}\\n\\nAction Required: Coordinate with dependency owner to resolve blocker." } }, "position": [ 368, -48 ] }, { "id": "27003e76-5b0b-4ff5-928a-9d3d9a062c1f", "name": "Post to Slack", "type": "integration", "params": { "text": "=*Dependency Radar Alert*\n\n{{ $json.riskFlag === 'High' ? '🔴' : ($json.riskFlag === 'Medium' ? '🟠' : '🟢') }} *{{ $json.issueKey }}* is {{ $json.dependencyType }} *{{ $json.linkedIssueKey }}*\n\n*Impact Score:* {{ $json.impactScore }}\n*Days Till Due:* {{ $json.daysTillDue }}\n*Risk Level:* {{ $json.riskFlag }}\n\nCoordination task created in Jira.", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "list", "value": "YOUR_CHANNEL_ID", "cachedResultName": "project-alerts" }, "operation": "read", "otherOptions": {} }, "position": [ 368, 160 ] }, { "id": "27dcf4a8-02ad-4ee5-b599-0675c696e34e", "name": "Fetch Open Jira Issues", "type": "integration", "params": { "options": { "jql": "project = YOUR_PROJECT_KEY AND statusCategory != Done" }, "service": "jira", "operation": "getAll", "returnAll": true }, "position": [ -528, -144 ] }, { "id": "0914ca57-8aeb-474b-bb51-473854353e4f", "name": "Email Formatter", "type": "code", "params": { "jsCode": "// HTML Email Formatter for Dependency Risk Report\nlet data;\n\nif ($input.all().length > 0 && Array.isArray($input.all()[0].json)) {\n data = $input.all()[0].json;\n} else if ($input.all().length > 0 && $input.all()[0].json.data) {\n data = $input.all()[0].json.data;\n} else if (Array.isArray($input.all())) {\n data = $input.all().map(item => item.json);\n} else {\n data = $input.all();\n}\n\nif (!Array.isArray(data)) {\n data = [data];\n}\n\nfunction generateHTMLEmail(data) {\n const today = new Date().toLocaleDateString('en-US', { \n year: 'numeric', \n month: 'long', \n day: 'numeric' \n });\n \n const blockingIssues = data.filter(item => item.dependencyType === 'blocks');\n const blockedIssues = data.filter(item => item.dependencyType === 'is blocked by');\n \n const blockingRows = blockingIssues.map(item => `\n \n \n ${item.issueKey}\n \n ${item.summary}\n ${item.assignee}\n \n ${item.dueDate !== 'No due date' ? item.dueDate : '-'}\n \n \n ${item.daysTillDue !== 999 ? `${item.daysTillDue} days` : '-'}\n \n \n ${item.linkedIssueKey}
\n ${item.linkedIssueSummary}\n \n \n \n ${item.riskFlag}\n \n \n \n = 20 ? '#dc2626' : '#f59e0b'};\">${item.impactScore}\n \n \n `).join('');\n \n const blockedRows = blockedIssues.map(item => `\n \n \n ${item.issueKey}\n \n ${item.summary}\n ${item.assignee}\n \n ${item.dueDate !== 'No due date' ? item.dueDate : '-'}\n \n \n ${item.daysTillDue !== 999 ? `${item.daysTillDue} days` : '-'}\n \n \n ${item.linkedIssueKey}
\n ${item.linkedIssueSummary}\n \n \n \n ${item.riskFlag}\n \n \n \n = 20 ? '#dc2626' : '#f59e0b'};\">${item.impactScore}\n \n \n `).join('');\n \n const htmlEmail = `\n\n\n\n \n \n Issue Dependency Risk Report\n\n\n \n \n \n \n

\n \n \n \n \n \n \n \n \n \n \n

🚨 Issue Dependency Risk Report

Generated on ${today}

⚠️ Attention Required: This report identifies critical dependencies that may impact project timelines.

${blockingIssues.length}

Blocking Issues

${blockedIssues.length}

Blocked Issues

${data.filter(i => i.riskFlag === 'High').length}

High Risk Items

🔴 Issues Blocking Others

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n ${blockingRows || ''}\n \n

Issue Key	Summary	Assignee	Due Date	Days Left	Blocking	Risk	Impact
No blocking issues found

🔒 Issues Being Blocked

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n ${blockedRows || ''}\n \n

Issue Key	Summary	Assignee	Due Date	Days Left	Blocked By	Risk	Impact
No blocked issues found

This is an automated report generated by n8n workflow.

\n\n\n `;\n \n return htmlEmail;\n}\n\nconst htmlContent = generateHTMLEmail(data);\n\nreturn [{\n json: {\n html: htmlContent,\n subject: `🚨 Issue Dependency Risk Report - ${new Date().toLocaleDateString()}`,\n text: `Issue Dependency Risk Report generated on ${new Date().toLocaleDateString()}`\n }\n}];" }, "position": [ 368, -240 ] } ] }

Automate cross-project dependency tracking between Jira and Monday