{ "edges": [ { "to": "f336716c-b603-4b83-8535-801e0567b0e6", "from": "ab40f58c-20ac-4e3b-a58c-296cf4db84ae", "toPort": "0", "fromPort": "0" }, { "to": "e06c3942-d62e-4101-bee7-f9b5a8340d88", "from": "d02ca829-e017-4b1e-b130-3454322a0793", "toPort": "0", "fromPort": "0" }, { "to": "996b70f4-8cf3-439d-9a0c-ef9147fe991e", "from": "0bd76ab3-5fed-4d5f-b768-723cbb0c50db", "toPort": "0", "fromPort": "0" }, { "to": "0bd76ab3-5fed-4d5f-b768-723cbb0c50db", "from": "e06c3942-d62e-4101-bee7-f9b5a8340d88", "toPort": "0", "fromPort": "0" }, { "to": "5a21a430-64d1-4699-9c35-73d6b6046e1a", "from": "996b70f4-8cf3-439d-9a0c-ef9147fe991e", "toPort": "0", "fromPort": "0" }, { "to": "ab40f58c-20ac-4e3b-a58c-296cf4db84ae", "from": "996b70f4-8cf3-439d-9a0c-ef9147fe991e", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "d02ca829-e017-4b1e-b130-3454322a0793", "name": "Every Monday 9 AM", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "triggerAtHour": 9 } ] } }, "position": [ 1152, 544 ] }, { "id": "e06c3942-d62e-4101-bee7-f9b5a8340d88", "name": "Configure Settings", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "config-1", "name": "googleSheetId", "type": "string", "value": "YOUR_GOOGLE_SHEET_ID" }, { "id": "config-2", "name": "sheetName", "type": "string", "value": "Invoices" }, { "id": "config-3", "name": "recipientEmail", "type": "string", "value": "user@example.com" }, { "id": "config-4", "name": "slackChannel", "type": "string", "value": "YOUR_SLACK_CHANNEL_ID" }, { "id": "config-5", "name": "businessName", "type": "string", "value": "Your Business Name" } ] } }, "position": [ 1424, 544 ] }, { "id": "0bd76ab3-5fed-4d5f-b768-723cbb0c50db", "name": "Read All Invoices", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "name", "value": "={{ $json.sheetName }}" }, "documentId": { "__rl": true, "mode": "id", "value": "={{ $json.googleSheetId }}" } }, "position": [ 1728, 544 ] }, { "id": "996b70f4-8cf3-439d-9a0c-ef9147fe991e", "name": "Calculate Totals and Find Overdue", "type": "code", "params": { "jsCode": "const invoices = $input.all().map(i => i.json);\nconst config = $('Configure Settings').first().json;\nconst today = new Date();\n\nlet totalPaid = 0;\nlet totalUnpaid = 0;\nlet totalOverdue = 0;\nconst overdueList = [];\nconst unpaidList = [];\n\nfor (const inv of invoices) {\n const amount = parseFloat(inv['Amount'] || inv['amount'] || 0);\n const status = (inv['Status'] || inv['status'] || '').toLowerCase();\n const dueDate = new Date(inv['Due Date'] || inv['due_date'] || '');\n const clientName = inv['Client Name'] || inv['client_name'] || 'Unknown';\n const invoiceId = inv['Invoice ID'] || inv['invoice_id'] || 'N/A';\n\n if (status === 'paid') {\n totalPaid += amount;\n } else {\n totalUnpaid += amount;\n unpaidList.push({ invoiceId, clientName, amount, dueDate: dueDate.toISOString().split('T')[0] });\n\n if (dueDate < today) {\n totalOverdue += amount;\n const daysOverdue = Math.floor((today - dueDate) / (1000 * 60 * 60 * 24));\n overdueList.push({ invoiceId, clientName, amount, dueDate: dueDate.toISOString().split('T')[0], daysOverdue });\n }\n }\n}\n\nconst overdueRows = overdueList.map(o =>\n `${o.invoiceId}${o.clientName}$${o.amount.toFixed(2)}${o.dueDate}${o.daysOverdue} days`\n).join('');\n\nconst unpaidRows = unpaidList.map(u =>\n `${u.invoiceId}${u.clientName}$${u.amount.toFixed(2)}${u.dueDate}`\n).join('');\n\nconst emailHtml = `\n

Weekly Invoice Summary - ${config.businessName}

Report generated: ${today.toISOString().split('T')[0]}

\n\n \n \n \n

Total Paid	$${totalPaid.toFixed(2)}
Total Unpaid	$${totalUnpaid.toFixed(2)}
Total Overdue	$${totalOverdue.toFixed(2)}

\n${overdueList.length > 0 ? `\n

Overdue Invoices (${overdueList.length})

\n\n \n ${overdueRows}\n

ID	Client	Amount	Due Date	Overdue

` : '

No overdue invoices this week.

'}\n${unpaidList.length > 0 ? `\n

All Unpaid Invoices (${unpaidList.length})

\n\n \n ${unpaidRows}\n

ID	Client	Amount	Due Date

` : ''}\n`;\n\nconst slackOverdueText = overdueList.map(o =>\n `- *${o.invoiceId}* | ${o.clientName} | $${o.amount.toFixed(2)} | Due: ${o.dueDate} (*${o.daysOverdue} days overdue*)`\n).join('\\n');\n\nreturn [{\n json: {\n ...config,\n emailHtml,\n totalPaid,\n totalUnpaid,\n totalOverdue,\n totalPaidFormatted: totalPaid.toFixed(2),\n totalUnpaidFormatted: totalUnpaid.toFixed(2),\n totalOverdueFormatted: totalOverdue.toFixed(2),\n overdueCount: overdueList.length,\n hasOverdue: overdueList.length > 0,\n slackOverdueText,\n reportDate: today.toISOString().split('T')[0]\n }\n}];" }, "position": [ 2048, 544 ] }, { "id": "5a21a430-64d1-4699-9c35-73d6b6046e1a", "name": "Email Weekly Summary", "type": "integration", "params": { "sendTo": "={{ $json.recipientEmail }}", "message": "={{ $json.emailHtml }}", "options": {}, "service": "gmail", "subject": "=Weekly Invoice Summary - {{ $json.businessName }} ({{ $json.reportDate }})", "operation": "read" }, "position": [ 2384, 512 ] }, { "id": "ab40f58c-20ac-4e3b-a58c-296cf4db84ae", "name": "Any Overdue?", "type": "if", "params": { "options": {}, "conditions": { "options": { "caseSensitive": false }, "combinator": "and", "conditions": [ { "id": "condition-overdue", "operator": { "type": "boolean", "operation": "equals" }, "leftValue": "={{ $json.hasOverdue }}", "rightValue": true } ] } }, "position": [ 2384, 704 ] }, { "id": "f336716c-b603-4b83-8535-801e0567b0e6", "name": "Alert Overdue to Slack", "type": "integration", "params": { "text": "=:warning: *Overdue Invoice Alert* - {{ $json.businessName }}\n{{ $json.overdueCount }} invoice(s) overdue, totalling *${{ $json.totalOverdueFormatted }}*\n\n{{ $json.slackOverdueText }}", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "name", "value": "#general" }, "operation": "read", "otherOptions": {}, "authentication": "oAuth2" }, "position": [ 2624, 688 ] } ] }

Send weekly invoice summaries and overdue alerts from Google Sheets via Gmail and Slack