{ "edges": [ { "to": "8c62cf19-72d0-4f71-9c99-76869162fee2", "from": "4be4bfce-c8a2-44a3-9103-2fdccd49e412", "toPort": "0", "fromPort": "0" }, { "to": "4be4bfce-c8a2-44a3-9103-2fdccd49e412", "from": "01fbe124-54ef-43a6-a681-020854625e06", "toPort": "0", "fromPort": "0" }, { "to": "001c98f6-ecfc-4596-9302-a76a67ed1a9a", "from": "4db7aa08-fd1d-4c55-acd4-85c859506034", "toPort": "0", "fromPort": "0" }, { "to": "fb104676-0af7-4fc0-8d9d-3b1b28d1d8c9", "from": "91761b47-e3b5-41fa-8471-7e622500b5b6", "toPort": "0", "fromPort": "0" }, { "to": "b837f97e-e59f-46aa-8a69-460f76bf95a9", "from": "c62f5422-acc7-4bc5-8c51-6e12d9334c0a", "toPort": "0", "fromPort": "0" }, { "to": "35aec01b-9358-4693-a672-b51aceb93913", "from": "c62f5422-acc7-4bc5-8c51-6e12d9334c0a", "toPort": "0", "fromPort": "1" }, { "to": "4db7aa08-fd1d-4c55-acd4-85c859506034", "from": "b837f97e-e59f-46aa-8a69-460f76bf95a9", "toPort": "0", "fromPort": "0" }, { "to": "4eb2cc81-0567-4b6d-a99c-a6043f2018b2", "from": "fb104676-0af7-4fc0-8d9d-3b1b28d1d8c9", "toPort": "0", "fromPort": "0" }, { "to": "001c98f6-ecfc-4596-9302-a76a67ed1a9a", "from": "21fbcd30-05d8-417f-a113-d46ded6a395a", "toPort": "0", "fromPort": "0" }, { "to": "91761b47-e3b5-41fa-8471-7e622500b5b6", "from": "3d4ac165-d2f1-4cdd-9720-917d7e790a18", "toPort": "0", "fromPort": "0" }, { "to": "3d4ac165-d2f1-4cdd-9720-917d7e790a18", "from": "5209eeca-53a5-4eae-a5c5-d1a772ec0595", "toPort": "0", "fromPort": "0" }, { "to": "c62f5422-acc7-4bc5-8c51-6e12d9334c0a", "from": "5209eeca-53a5-4eae-a5c5-d1a772ec0595", "toPort": "0", "fromPort": "1" }, { "to": "21fbcd30-05d8-417f-a113-d46ded6a395a", "from": "35aec01b-9358-4693-a672-b51aceb93913", "toPort": "0", "fromPort": "0" }, { "to": "5209eeca-53a5-4eae-a5c5-d1a772ec0595", "from": "8c62cf19-72d0-4f71-9c99-76869162fee2", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "01fbe124-54ef-43a6-a681-020854625e06", "name": "Incoming Request", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "subscription-renewal", "options": {}, "httpMethod": "POST" }, "position": [ -16, 320 ] }, { "id": "4be4bfce-c8a2-44a3-9103-2fdccd49e412", "name": "Set Defaults", "type": "set", "params": { "options": {} }, "position": [ 208, 304 ] }, { "id": "8c62cf19-72d0-4f71-9c99-76869162fee2", "name": "Filter Expiring & Build Data", "type": "code", "params": { "jsCode": "// Output 0: reminders, Output 1: summary\nconst threshold = $json[0].daysThreshold || 7;\nconst adminEmail = $json[0].adminEmail;\nconst now = Date.now();\nconst MS_IN_DAY = 86400000;\n\nconst reminders = [];\n\nitems.forEach(item => {\n const task = item.json;\n if (!task.due_date) return; // Skip tasks without due date\n const dueTs = Number(task.due_date);\n const daysLeft = Math.ceil((dueTs - now) / MS_IN_DAY);\n if (daysLeft <= threshold) {\n // Try to locate a custom field named \"Email\"\n const emailField = (task.custom_fields || []).find(f => f.name === 'Email');\n const customerEmail = emailField ? emailField.value : 'user@example.com';\n\n reminders.push({\n json: {\n taskId: task.id,\n subscriptionName: task.name,\n dueDateISO: new Date(dueTs).toISOString(),\n daysLeft,\n customerEmail,\n fromEmail: item.json.fromEmail,\n adminEmail,\n threshold\n }\n });\n }\n});\n\nconst summary = [{\n json: {\n runAt: new Date().toISOString(),\n totalReminders: reminders.length,\n adminEmail,\n threshold\n }\n}];\n\nreturn [reminders, summary];" }, "position": [ 544, 288 ] }, { "id": "5209eeca-53a5-4eae-a5c5-d1a772ec0595", "name": "Split per Subscription", "type": "passthrough", "params": { "mode": "noOp", "options": {} }, "position": [ 784, 160 ] }, { "id": "3d4ac165-d2f1-4cdd-9720-917d7e790a18", "name": "Prepare Reminder Email", "type": "set", "params": { "options": {} }, "position": [ 1264, 80 ] }, { "id": "91761b47-e3b5-41fa-8471-7e622500b5b6", "name": "Throttle Reminders", "type": "passthrough", "params": { "mode": "noOp", "unit": "seconds" }, "position": [ 1552, 48 ] }, { "id": "fb104676-0af7-4fc0-8d9d-3b1b28d1d8c9", "name": "Send Reminder Email", "type": "integration", "params": { "options": {}, "service": "smtp", "subject": "={{ $json.subject }}", "toEmail": "={{ $json.toEmail }}", "fromEmail": "={{ $json.fromEmail }}", "operation": "read" }, "position": [ 1792, 80 ] }, { "id": "4eb2cc81-0567-4b6d-a99c-a6043f2018b2", "name": "Log Reminder Status", "type": "set", "params": { "options": {} }, "position": [ 1968, 80 ] }, { "id": "c62f5422-acc7-4bc5-8c51-6e12d9334c0a", "name": "Any Reminders Sent?", "type": "if", "params": { "options": {}, "conditions": { "number": [ { "value1": "={{ $json.totalReminders }}", "value2": 0, "operation": "larger" } ] } }, "position": [ 1008, 288 ] }, { "id": "b837f97e-e59f-46aa-8a69-460f76bf95a9", "name": "Build Admin Summary", "type": "code", "params": { "jsCode": "const total = $json.totalReminders;\nconst threshold = $json.threshold;\nconst runAt = $json.runAt;\n\nconst html = `

Hi Team,

${total} renewal reminder(s) were sent during the latest run (threshold: ${threshold} days).

Run time: ${runAt}

Regards,
n8n Bot

`;\n\nreturn [{\n json: {\n adminEmail: $json.adminEmail,\n fromEmail: $json.fromEmail || 'user@example.com',\n summarySubject: `${total} subscription reminder(s) sent`,\n summaryHtml: html\n }\n}];" }, "position": [ 1680, 256 ] }, { "id": "4db7aa08-fd1d-4c55-acd4-85c859506034", "name": "Send Admin Summary", "type": "integration", "params": { "options": {}, "service": "smtp", "subject": "={{ $json.summarySubject }}", "toEmail": "={{ $json.adminEmail }}", "fromEmail": "={{ $json.fromEmail }}", "operation": "read" }, "position": [ 1872, 256 ] }, { "id": "35aec01b-9358-4693-a672-b51aceb93913", "name": "Prepare No-Expiry Email", "type": "set", "params": { "options": {} }, "position": [ 1392, 480 ] }, { "id": "21fbcd30-05d8-417f-a113-d46ded6a395a", "name": "Send No-Expiry Email", "type": "integration", "params": { "options": {}, "service": "smtp", "subject": "={{ $json.subject }}", "toEmail": "={{ $json.toEmail }}", "fromEmail": "={{ $json.fromEmail }}", "operation": "read" }, "position": [ 1632, 480 ] }, { "id": "001c98f6-ecfc-4596-9302-a76a67ed1a9a", "name": "Cleanup Execution", "type": "code", "params": { "jsCode": "return [{json:{status:'completed',finishedAt:new Date().toISOString()}}];" }, "position": [ 2160, 320 ] } ] }

Send subscription renewal reminders with Email and ClickUp