{ "edges": [ { "to": "3ef99004-e0bd-4346-8ac0-6e83a88260f0", "from": "76eca7bd-8b7d-4119-a18f-81ae5c142653", "toPort": "0", "fromPort": "0" }, { "to": "db74c4fe-3bf1-45f9-a971-64ffc74695df", "from": "76eca7bd-8b7d-4119-a18f-81ae5c142653", "toPort": "0", "fromPort": "0" }, { "to": "94b59a38-4e45-47dc-8c3d-d133ddd07455", "from": "d3aec18e-05de-4ca9-8b19-263695b105b7", "toPort": "0", "fromPort": "0" }, { "to": "0da5f2fa-32f6-4c7e-85a0-474bf3550f4e", "from": "e62e8f45-3b5b-4a1d-a120-b0c07ebcc178", "toPort": "0", "fromPort": "0" }, { "to": "064ef92a-f13c-4926-8526-a1eb398fa3db", "from": "3ef99004-e0bd-4346-8ac0-6e83a88260f0", "toPort": "0", "fromPort": "0" }, { "to": "d3aec18e-05de-4ca9-8b19-263695b105b7", "from": "064ef92a-f13c-4926-8526-a1eb398fa3db", "toPort": "0", "fromPort": "0" }, { "to": "76eca7bd-8b7d-4119-a18f-81ae5c142653", "from": "0da5f2fa-32f6-4c7e-85a0-474bf3550f4e", "toPort": "0", "fromPort": "0" }, { "to": "064ef92a-f13c-4926-8526-a1eb398fa3db", "from": "db74c4fe-3bf1-45f9-a971-64ffc74695df", "toPort": "1", "fromPort": "0" } ], "nodes": [ { "id": "e62e8f45-3b5b-4a1d-a120-b0c07ebcc178", "name": "When clicking ‘Execute workflow’", "type": "manualTrigger", "params": {}, "position": [ -128, 0 ] }, { "id": "0da5f2fa-32f6-4c7e-85a0-474bf3550f4e", "name": " Fetch All Project Issues with Time Data", "type": "integration", "params": { "options": {}, "service": "jira", "operation": "getAll", "returnAll": true }, "position": [ 176, 0 ] }, { "id": "76eca7bd-8b7d-4119-a18f-81ae5c142653", "name": "Aggregate Hours by Team Member", "type": "code", "params": { "jsCode": "// Get all Jira issues from input\nconst items = $input.all().map(i => i.json);\n\n// Initialize grouped output\nconst grouped = {};\n\n// Iterate over each issue\nfor (const issue of items) {\n const f = issue.fields || {};\n\n const assigneeName = f.assignee?.displayName || 'Unassigned';\n const email = f.assignee?.emailAddress || 'user@example.com';\n const projectName = f.project?.name || 'Unknown Project';\n const sprint = f.customfield_10020?.[0]?.name || 'No Sprint';\n const timeSpentSeconds = f.timespent || 0;\n const timeSpentHours = (timeSpentSeconds / 3600).toFixed(2);\n\n if (!grouped[assigneeName]) {\n grouped[assigneeName] = {\n assignee: assigneeName,\n email,\n project_name: projectName,\n total_hours: 0,\n issues: []\n };\n }\n\n grouped[assigneeName].total_hours += parseFloat(timeSpentHours);\n grouped[assigneeName].issues.push({\n issue_key: issue.key,\n summary: f.summary,\n timespent_hours: timeSpentHours,\n status: f.status?.name || 'Unknown',\n priority: f.priority?.name || 'None',\n sprint,\n });\n}\n\n// Convert grouped object into array format\nconst output = Object.values(grouped).map(user => ({\n json: {\n assignee: user.assignee,\n email: user.email,\n project_name: user.project_name,\n total_hours: user.total_hours.toFixed(2),\n issues: user.issues,\n }\n}));\n\nreturn output;\n" }, "position": [ 448, 0 ] }, { "id": "3ef99004-e0bd-4346-8ac0-6e83a88260f0", "name": "Identify Issues with Missing Time Logs", "type": "code", "params": { "jsCode": "const users = $input.all().map(i => i.json);\n\nconst reminders = [];\n\nfor (const user of users) {\n const missing = user.issues.filter(i => parseFloat(i.timespent_hours) === 0);\n\n if (missing.length > 0) {\n const table = missing.map(i => \n `\n ${i.issue_key}\n ${i.summary}\n ${i.status}\n ${i.priority}\n ${i.sprint}\n `\n ).join('');\n\n reminders.push({\n json: {\n assignee: user.assignee,\n email: user.email,\n missing_count: missing.length,\n project_name: user.project_name,\n html_message: `\n

Hi ${user.assignee},

Our system found ${missing.length} issues where no time is logged:

\n \n \n ${table}\n

Issue Key	Summary	Status	Priority	Sprint

Please log your hours for these issues before EOD to ensure accurate billing.

Thank you,
Automation Bot 🤖

\n `\n }\n });\n }\n}\n\nreturn reminders;\n" }, "position": [ 832, 0 ] }, { "id": "db74c4fe-3bf1-45f9-a971-64ffc74695df", "name": "Generate Invoice Summary with Text Attachment", "type": "code", "params": { "jsCode": "// Combined Invoice Generator + Text File Export\n\nconst users = $input.all().map(i => i.json);\nconst RATE = 50; // hourly rate\nconst results = [];\n\nfor (const user of users) {\n const totalHours = parseFloat(user.total_hours || 0);\n if (totalHours === 0) continue;\n\n const totalAmount = totalHours * RATE;\n\n // Build the plain text table\n const issueLines = user.issues.map(i =>\n `${i.issue_key.padEnd(10)} | ${i.summary.padEnd(30)} | ${i.timespent_hours} hrs | ${i.status}`\n ).join('\\n');\n\n // Final plain-text invoice content\n const text = `\nYOUR_AWS_SECRET_KEY_HERE===\nINVOICE SUMMARY — ${user.project_name}\nYOUR_AWS_SECRET_KEY_HERE===\n\nAssignee: ${user.assignee}\nEmail: ${user.email}\nRate: $${RATE}/hour\n\n-------------------------------------------\nIssues\n-------------------------------------------\n${issueLines}\n\n-------------------------------------------\nTotal Hours: ${totalHours.toFixed(2)}\nTotal Amount: $${totalAmount.toFixed(2)}\n-------------------------------------------\n\nGenerated automatically by Techdome Billing Automation Bot.\n`;\n\n // Push JSON + Binary for email attachment\n results.push({\n json: {\n assignee: user.assignee,\n email: user.email,\n project_name: user.project_name,\n total_hours: totalHours.toFixed(2),\n total_amount: totalAmount.toFixed(2)\n },\n binary: {\n data: {\n fileName: `Invoice_${user.assignee}.txt`,\n mimeType: 'text/plain',\n data: Buffer.from(text, 'utf8').toString('base64')\n }\n }\n });\n}\n\nreturn results;\n" }, "position": [ 832, 384 ] }, { "id": "064ef92a-f13c-4926-8526-a1eb398fa3db", "name": "Combine Reminder & Invoice Data Streams", "type": "merge", "params": {}, "position": [ 1216, 16 ] }, { "id": "d3aec18e-05de-4ca9-8b19-263695b105b7", "name": "Reconcile JSON & Binary Attachments", "type": "code", "params": { "jsCode": "// Combine JSON + Binary after Merge node\n// Safe for n8n v1.112.6 and later\n\nconst combined = [];\n\n// Get all incoming items\nconst items = $input.all();\n\n// We might have duplicates or partials, so we merge smartly\nfor (const item of items) {\n const json = item.json || {};\n const binary = item.binary || {};\n\n // Case 1: this item already has both\n if (json.email && binary.data) {\n combined.push({ json, binary });\n continue;\n }\n\n // Case 2: only has JSON\n if (json.email && !binary.data) {\n // Try to find its binary partner\n const match = items.find(\n (i) => i.binary && i.binary.data && i.json?.assignee === json.assignee\n );\n\n if (match) {\n combined.push({ json, binary: match.binary });\n } else {\n combined.push({ json }); // fallback\n }\n continue;\n }\n\n // Case 3: only has Binary\n if (binary.data && !json.email) {\n // Try to find its JSON partner\n const match = items.find(\n (i) => i.json && i.json.assignee && i.binary === undefined\n );\n if (match) {\n combined.push({ json: match.json, binary });\n } else {\n combined.push({ binary });\n }\n continue;\n }\n}\n\nreturn combined;\n" }, "position": [ 1488, 16 ] }, { "id": "94b59a38-4e45-47dc-8c3d-d133ddd07455", "name": "Send Invoices & Reminders to Team", "type": "integration", "params": { "sendTo": "={{ $json.email }}", "message": "=Hi {{$json[\"assignee\"]}},

\nPlease find attached your invoice summary for {{$json[\"project_name\"]}}.

\n📊 Total Hours: {{ $('Aggregate Hours by Team Member').item.json.total_hours }}
\nRegards,
\nTechdome Billing Automation Bot\n", "options": { "attachmentsUi": { "attachmentsBinary": [ {} ] } }, "service": "gmail", "subject": "={{ $json.project_name }}", "operation": "read" }, "position": [ 1808, 16 ] } ] }

Auto-generate developer invoices & compliance reminders with Jira and Gmail