{ "edges": [ { "to": "f077e19c-408e-48da-9bd8-51ce5332459f", "from": "18f3d827-6ffb-4ef9-9080-13a5bf65773b", "toPort": "0", "fromPort": "0" }, { "to": "a8409e3e-720e-4163-b730-cfdfeb22a1b8", "from": "db1f10ec-9594-4446-9c9d-c42321165efa", "toPort": "0", "fromPort": "0" }, { "to": "a57f0035-73a4-4720-8de1-9315d6a28c3a", "from": "db1f10ec-9594-4446-9c9d-c42321165efa", "toPort": "0", "fromPort": "0" }, { "to": "3153af6e-e5eb-4560-a406-14b85781064a", "from": "a8409e3e-720e-4163-b730-cfdfeb22a1b8", "toPort": "0", "fromPort": "0" }, { "to": "12d16c58-99c9-4b5c-b35c-6ed7474f64a1", "from": "a57f0035-73a4-4720-8de1-9315d6a28c3a", "toPort": "0", "fromPort": "0" }, { "to": "db1f10ec-9594-4446-9c9d-c42321165efa", "from": "5d987c19-ccb9-48cc-8070-11c355c8f55f", "toPort": "0", "fromPort": "0" }, { "to": "6612a7be-3eb9-4283-b95f-e82867780a3c", "from": "5d987c19-ccb9-48cc-8070-11c355c8f55f", "toPort": "0", "fromPort": "0" }, { "to": "566f5199-04e1-4bb4-9fb3-19eab294368a", "from": "ec99697c-9837-4945-8743-ad1099286938", "toPort": "0", "fromPort": "0" }, { "to": "9f0f080c-568d-4145-a82f-39bf2849d72e", "from": "ec99697c-9837-4945-8743-ad1099286938", "toPort": "0", "fromPort": "0" }, { "to": "18f3d827-6ffb-4ef9-9080-13a5bf65773b", "from": "fda19308-3460-4416-b4c2-d1dafb8a053e", "toPort": "0", "fromPort": "0" }, { "to": "5d987c19-ccb9-48cc-8070-11c355c8f55f", "from": "f077e19c-408e-48da-9bd8-51ce5332459f", "toPort": "0", "fromPort": "0" }, { "to": "fda19308-3460-4416-b4c2-d1dafb8a053e", "from": "566f5199-04e1-4bb4-9fb3-19eab294368a", "toPort": "0", "fromPort": "0" }, { "to": "fda19308-3460-4416-b4c2-d1dafb8a053e", "from": "9f0f080c-568d-4145-a82f-39bf2849d72e", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "ec99697c-9837-4945-8743-ad1099286938", "name": "Daily Tax Check", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ {} ] } }, "position": [ -2752, 2336 ] }, { "id": "566f5199-04e1-4bb4-9fb3-19eab294368a", "name": "Fetch Tax Calendar", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "name", "value": "TaxCalendar" }, "documentId": { "__rl": true, "mode": "id", "value": "YOUR_TAX_CALENDAR_ID" }, "authentication": "serviceAccount" }, "position": [ -2528, 2240 ] }, { "id": "9f0f080c-568d-4145-a82f-39bf2849d72e", "name": "Fetch Company Config", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "name", "value": "CompanyConfig" }, "documentId": { "__rl": true, "mode": "id", "value": "YOUR_CONFIG_ID" }, "authentication": "serviceAccount" }, "position": [ -2528, 2432 ] }, { "id": "fda19308-3460-4416-b4c2-d1dafb8a053e", "name": "Analyze Deadlines", "type": "code", "params": { "jsCode": "const taxCalendar = $('Fetch Tax Calendar').all();\nconst companyConfig = $('Fetch Company Config').first().json;\nconst now = new Date();\nconst today = now.toISOString().split('T')[0];\n\nconst getDaysDifference = (date1, date2) => {\n const diffTime = new Date(date1) - new Date(date2);\n return Math.ceil(diffTime / (1000 * 60 * 60 * 24));\n};\n\nconst jurisdictions = (companyConfig.Jurisdictions || 'Federal').split(',').map(j => j.trim());\nconst entityType = companyConfig.EntityType || 'Corporation';\n\nconst upcomingDeadlines = [];\nconst criticalDeadlines = [];\nconst overdueDeadlines = [];\n\ntaxCalendar.forEach(item => {\n const deadline = item.json;\n const deadlineDate = new Date(deadline.DeadlineDate);\n const daysUntil = getDaysDifference(deadlineDate, now);\n \n if (deadline.IsActive !== 'TRUE' && deadline.IsActive !== true) return;\n \n const jurisdictionMatch = !deadline.Jurisdiction || jurisdictions.includes(deadline.Jurisdiction);\n const entityMatch = !deadline.EntityType || deadline.EntityType === entityType || deadline.EntityType === 'All';\n \n if (!jurisdictionMatch || !entityMatch) return;\n \n const deadlineInfo = {\n id: deadline.DeadlineID || `TAX-${Date.now()}`,\n name: deadline.DeadlineName,\n description: deadline.Description || '',\n deadlineDate: deadline.DeadlineDate,\n daysUntil: daysUntil,\n jurisdiction: deadline.Jurisdiction || 'Federal',\n category: deadline.Category || 'General',\n assignedTo: deadline.AssignedTo || 'Finance Team',\n penalties: deadline.Penalties || 'Standard penalties',\n priority: 'Normal'\n };\n \n if (daysUntil < 0) {\n deadlineInfo.priority = 'Critical';\n overdueDeadlines.push(deadlineInfo);\n } else if (daysUntil <= 3) {\n deadlineInfo.priority = 'Critical';\n criticalDeadlines.push(deadlineInfo);\n upcomingDeadlines.push(deadlineInfo);\n } else if (daysUntil <= 7) {\n deadlineInfo.priority = 'High';\n upcomingDeadlines.push(deadlineInfo);\n } else if (daysUntil <= 30) {\n deadlineInfo.priority = 'Medium';\n upcomingDeadlines.push(deadlineInfo);\n }\n});\n\nreturn {\n date: today,\n timestamp: now.toISOString(),\n jurisdictions: jurisdictions.join(', '),\n entityType: entityType,\n totalUpcoming: upcomingDeadlines.length,\n criticalCount: criticalDeadlines.length,\n overdueCount: overdueDeadlines.length,\n next7Days: upcomingDeadlines.filter(d => d.daysUntil <= 7).length,\n upcomingDeadlines: upcomingDeadlines,\n criticalDeadlines: criticalDeadlines,\n overdueDeadlines: overdueDeadlines,\n requiresImmediateAction: overdueDeadlines.length > 0 || criticalDeadlines.length > 0,\n alertLevel: overdueDeadlines.length > 0 ? 'CRITICAL' : criticalDeadlines.length > 0 ? 'HIGH' : 'MEDIUM'\n};" }, "position": [ -2304, 2336 ] }, { "id": "18f3d827-6ffb-4ef9-9080-13a5bf65773b", "name": "AI Analysis", "type": "http", "params": { "url": "https://api.openai.com/v1/chat/completions", "method": "POST", "options": {}, "jsonBody": "={\n \"model\": \"gpt-4\",\n \"messages\": [\n {\n \"role\": \"system\",\n \"content\": \"You are a tax compliance advisor. Analyze deadlines and provide insights.\"\n },\n {\n \"role\": \"user\",\n \"content\": \"Analyze these tax deadlines for {{ $json.date }}: {{ JSON.stringify($json.upcomingDeadlines) }}. Provide risk assessment and recommendations.\"\n }\n ]\n}", "sendBody": true, "specifyBody": "json" }, "position": [ -2080, 2336 ] }, { "id": "f077e19c-408e-48da-9bd8-51ce5332459f", "name": "Merge AI Insights", "type": "code", "params": { "jsCode": "const deadlineData = $('Analyze Deadlines').first().json;\nconst aiResponse = $input.first().json;\n\nlet aiInsights = 'AI analysis completed';\ntry {\n aiInsights = aiResponse.choices[0].message.content;\n} catch (e) {\n aiInsights = 'AI analysis unavailable';\n}\n\nreturn {\n ...deadlineData,\n aiInsights: aiInsights\n};" }, "position": [ -1856, 2336 ] }, { "id": "5d987c19-ccb9-48cc-8070-11c355c8f55f", "name": "Has Deadlines", "type": "if", "params": { "options": {}, "conditions": { "number": [ { "value1": "={{ $json.totalUpcoming }}", "value2": 0, "operation": "larger" } ] } }, "position": [ -1632, 2336 ] }, { "id": "db1f10ec-9594-4446-9c9d-c42321165efa", "name": "Is Critical", "type": "if", "params": { "options": {}, "conditions": { "boolean": [ { "value1": "={{ $json.requiresImmediateAction }}", "value2": true } ] } }, "position": [ -1408, 2240 ] }, { "id": "a8409e3e-720e-4163-b730-cfdfeb22a1b8", "name": "Format Email", "type": "code", "params": { "jsCode": "const data = $input.first().json;\n\nconst emailHtml = `\n\n\n

Tax Compliance Alert

${data.date} | Alert: ${data.alertLevel}

Summary

Overdue: ${data.overdueCount}

Critical (≤3 days): ${data.criticalCount}

Next 7 Days: ${data.next7Days}

Total Upcoming: ${data.totalUpcoming}

\n ${data.overdueDeadlines.length > 0 ? `\n

OVERDUE DEADLINES

\n ${data.overdueDeadlines.map(dl => `\n

${dl.name}
\n Due: ${dl.deadlineDate} (${Math.abs(dl.daysUntil)} days overdue)
\n Assigned: ${dl.assignedTo}

\n `).join('')}\n

\n ` : ''}\n ${data.criticalDeadlines.length > 0 ? `\n

CRITICAL DEADLINES

\n ${data.criticalDeadlines.map(dl => `\n

${dl.name}
\n Due: ${dl.deadlineDate} (${dl.daysUntil} days)
\n Assigned: ${dl.assignedTo}

\n `).join('')}\n

\n ` : ''}\n

AI Insights

${data.aiInsights}

\n\n\n`;\n\nreturn {\n ...data,\n emailHtml: emailHtml,\n emailSubject: `${data.alertLevel} Tax Alert - ${data.overdueCount} Overdue, ${data.criticalCount} Critical`\n};" }, "position": [ -1184, 2144 ] }, { "id": "3153af6e-e5eb-4560-a406-14b85781064a", "name": "Send Email", "type": "integration", "params": { "options": {}, "service": "smtp", "subject": "={{ $json.emailSubject }}", "toEmail": "user@example.com", "fromEmail": "user@example.com", "operation": "read" }, "position": [ -960, 2144 ] }, { "id": "a57f0035-73a4-4720-8de1-9315d6a28c3a", "name": "Format Slack", "type": "code", "params": { "jsCode": "const data = $input.first().json;\n\nconst blocks = [\n {\n type: \"header\",\n text: {\n type: \"plain_text\",\n text: `Tax Alert - ${data.date}`,\n emoji: true\n }\n },\n {\n type: \"section\",\n fields: [\n { type: \"mrkdwn\", text: `*Overdue:* ${data.overdueCount}` },\n { type: \"mrkdwn\", text: `*Critical:* ${data.criticalCount}` },\n { type: \"mrkdwn\", text: `*Next 7 Days:* ${data.next7Days}` },\n { type: \"mrkdwn\", text: `*Total:* ${data.totalUpcoming}` }\n ]\n }\n];\n\nif (data.overdueDeadlines.length > 0) {\n blocks.push({\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: `*OVERDUE:*\\n${data.overdueDeadlines.map(dl => `• ${dl.name} - ${Math.abs(dl.daysUntil)} days overdue`).join('\\n')}`\n }\n });\n}\n\nif (data.criticalDeadlines.length > 0) {\n blocks.push({\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: `*CRITICAL:*\\n${data.criticalDeadlines.map(dl => `• ${dl.name} - ${dl.daysUntil} days left`).join('\\n')}`\n }\n });\n}\n\nreturn { ...data, slackBlocks: blocks };" }, "position": [ -1184, 2336 ] }, { "id": "12d16c58-99c9-4b5c-b35c-6ed7474f64a1", "name": "Send to Slack", "type": "integration", "params": { "text": "=Tax Alert", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "id", "value": "C12345678" }, "operation": "read", "otherOptions": {} }, "position": [ -960, 2336 ] }, { "id": "6612a7be-3eb9-4283-b95f-e82867780a3c", "name": "Log to Sheet1", "type": "integration", "params": { "columns": { "value": {}, "schema": [], "mappingMode": "autoMapInputData", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "name", "value": "ComplianceLog" }, "documentId": { "__rl": true, "mode": "id", "value": "YOUR_LOG_ID" }, "authentication": "serviceAccount" }, "position": [ -1408, 2432 ] } ] }

Tax deadline management & compliance alerts with GPT-4, Google Sheets & Slack