{ "edges": [ { "to": "64f64cfa-5098-49ff-b8f7-f75a4874aeb8", "from": "b744deba-370b-4cd4-a3c2-89011a66e427", "toPort": "0", "fromPort": "0" }, { "to": "57f812f3-3dc7-4d66-b62e-fc66f6da84f0", "from": "64f64cfa-5098-49ff-b8f7-f75a4874aeb8", "toPort": "0", "fromPort": "0" }, { "to": "085776b2-4a0a-49f4-84a3-629aac33ec4b", "from": "005324fd-512c-437f-94b6-f030888b69df", "toPort": "0", "fromPort": "0" }, { "to": "005324fd-512c-437f-94b6-f030888b69df", "from": "57f812f3-3dc7-4d66-b62e-fc66f6da84f0", "toPort": "0", "fromPort": "0" }, { "to": "b744deba-370b-4cd4-a3c2-89011a66e427", "from": "868d15bc-d75e-45af-9657-6b1cc40bbdaf", "toPort": "0", "fromPort": "0" }, { "to": "868d15bc-d75e-45af-9657-6b1cc40bbdaf", "from": "8b5a7a7b-fec4-48c0-8dfc-75f2db56df2f", "toPort": "0", "fromPort": "0" }, { "to": "088fdaed-8e99-4756-9735-1d3ca3f4e472", "from": "085776b2-4a0a-49f4-84a3-629aac33ec4b", "toPort": "0", "fromPort": "0" }, { "to": "6b2e20f7-d4f6-4b9d-9a4b-71c190626df1", "from": "085776b2-4a0a-49f4-84a3-629aac33ec4b", "toPort": "0", "fromPort": "1" }, { "to": "ae3c3d89-517c-4c6e-8c29-c056d5a18ca1", "from": "6b2e20f7-d4f6-4b9d-9a4b-71c190626df1", "toPort": "0", "fromPort": "1" } ], "nodes": [ { "id": "8b5a7a7b-fec4-48c0-8dfc-75f2db56df2f", "name": "Receive Promo Request", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "27923033-a20e-4fc3-8bda-5308f6661a01", "options": {}, "httpMethod": "POST" }, "position": [ -656, -64 ] }, { "id": "868d15bc-d75e-45af-9657-6b1cc40bbdaf", "name": "Normalize Promo Data", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "66113943-5c51-4825-acd6-f90fb1c2ad83", "name": "body.code", "type": "string", "value": "={{ $json.body.code }}" }, { "id": "87925321-8d42-40ca-ae04-05d915598b4b", "name": "body.discount_type", "type": "string", "value": "={{ $json.body.discount_type }}" }, { "id": "5141b5e6-1c1e-48d6-87c8-dbf7c53e8295", "name": "body.value", "type": "number", "value": "={{ $json.body.value }}" }, { "id": "b7de7784-7564-440e-96ae-2d5f620c3573", "name": "body.expiry", "type": "string", "value": "={{ $json.body.expiry }}" }, { "id": "d56b63af-b89d-40b1-8e7d-f574394dc4aa", "name": "body.usage_limit", "type": "number", "value": "={{ $json.body.usage_limit }}" } ] } }, "position": [ -352, -64 ] }, { "id": "b744deba-370b-4cd4-a3c2-89011a66e427", "name": "Expiry Is Valid", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "1cba2ed6-e3c2-48da-bf85-cb0f47162a1e", "operator": { "type": "boolean", "operation": "true", "singleValue": true }, "leftValue": "={{ new Date($json[\"body\"][\"expiry\"]) > new Date() }}", "rightValue": "" } ] } }, "position": [ 64, -64 ] }, { "id": "64f64cfa-5098-49ff-b8f7-f75a4874aeb8", "name": "Send Promo Email", "type": "integration", "params": { "sendTo": "user@example.com", "message": "=

🎉 New Promo Code Available!

Code: {{ $('Expiry Is Valid').item.json.body.code }}

Discount: {{ $('Expiry Is Valid').item.json.body.value }}%

Expiry: {{ $('Expiry Is Valid').item.json.body.expiry }}

Usage Limit: {{ $('Expiry Is Valid').item.json.body.usage_limit }}

", "options": { "appendAttribution": false }, "service": "gmail", "subject": "=🎉 New Promo Code: {{ $('Expiry Is Valid').item.json.body.code }}", "operation": "read" }, "position": [ 288, -80 ] }, { "id": "57f812f3-3dc7-4d66-b62e-fc66f6da84f0", "name": "Save Promo to Sheet", "type": "integration", "params": { "columns": { "value": { "Code": "={{ $('Expiry Is Valid').item.json.body.code }}", "Expiry": "={{ $('Expiry Is Valid').item.json.body.expiry }}", "Discount": "={{ $('Expiry Is Valid').item.json.body.value }}", "Usage Limit": "={{ $('Expiry Is Valid').item.json.body.usage_limit }}" }, "schema": [ { "id": "Code", "type": "string", "display": true, "required": false, "displayName": "Code", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Discount", "type": "string", "display": true, "required": false, "displayName": "Discount", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Expiry", "type": "string", "display": true, "required": false, "displayName": "Expiry", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Usage Limit", "type": "string", "display": true, "required": false, "displayName": "Usage Limit", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Created At", "type": "string", "display": true, "removed": true, "required": false, "displayName": "Created At", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "", "cachedResultName": "" }, "documentId": { "__rl": true, "mode": "list", "value": "1KiQqP-eWsyCKWZa1X07rV0eGhk93TXC30uS9POyNGZQ", "cachedResultUrl": "", "cachedResultName": "" } }, "position": [ 528, -80 ] }, { "id": "005324fd-512c-437f-94b6-f030888b69df", "name": "Calculate Days Left", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "f6d0bdf2-d8bf-4baa-bd81-c507db8df7e2", "name": "daysLeft", "type": "string", "value": "={{ Math.ceil((new Date($json.Expiry) - new Date()) / (1000 * 60 * 60 * 24)) }}" } ] } }, "position": [ 944, -80 ] }, { "id": "085776b2-4a0a-49f4-84a3-629aac33ec4b", "name": "Is Urgent (1 Day Left)", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "1755407a-ff14-4a9f-a7a7-e4e68dbfdfe8", "operator": { "type": "string", "operation": "equals" }, "leftValue": "={{ $json.daysLeft }}", "rightValue": "1" } ] } }, "position": [ 1152, -80 ] }, { "id": "088fdaed-8e99-4756-9735-1d3ca3f4e472", "name": "Slack Urgent Alert", "type": "integration", "params": { "text": "=🚨 URGENT: Promo Expiring Tomorrow! Code: {{ $('Save Promo to Sheet').item.json.Code }} Discount:{{ $('Save Promo to Sheet').item.json.Discount }}% Expiry: {{ $('Save Promo to Sheet').item.json.Expiry }} ⚡ Only 1 day left!", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "list", "value": "C09S57E2JQ2", "cachedResultName": "n8n" }, "operation": "read", "otherOptions": {} }, "position": [ 1872, -368 ] }, { "id": "6b2e20f7-d4f6-4b9d-9a4b-71c190626df1", "name": "Is Warning (2–3 Days Left)", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "cdc81cf1-d994-45c3-a4b8-476685b62aeb", "operator": { "type": "boolean", "operation": "equals" }, "leftValue": "={{ $json.daysLeft > 1 && $json.daysLeft <= 3 }}", "rightValue": true } ] } }, "position": [ 1728, 256 ] }, { "id": "ae3c3d89-517c-4c6e-8c29-c056d5a18ca1", "name": "Slack Warning Alert", "type": "integration", "params": { "text": "=⚠️ Promo Expiring Soon Code:{{ $('Save Promo to Sheet').item.json.Code }} Discount:{{ $('Save Promo to Sheet').item.json.Discount }} % Expiry: {{ $('Save Promo to Sheet').item.json.Expiry }} ⏳ Days Left: {{ $json.daysLeft }}", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "list", "value": "C09S57E2JQ2", "cachedResultName": "n8n" }, "operation": "read", "otherOptions": {} }, "position": [ 1984, 272 ] } ] }

Send promo code expiry alerts using Webhook, Google Sheets, Gmail and Slack