{ "edges": [ { "to": "fe2a2a00-3f37-4ca1-b38a-3091b4d577f5", "from": "46d71fc4-9f17-4635-8f0b-692d7ee3e0d7", "toPort": "0", "fromPort": "0" }, { "to": "122edb03-03ae-446d-98d3-8e12e46c4332", "from": "6dfdcc94-ca0b-4edf-b1b5-75baf14fba55", "toPort": "0", "fromPort": "0" }, { "to": "46d71fc4-9f17-4635-8f0b-692d7ee3e0d7", "from": "d9463e4e-e7dc-4335-bf72-0b58ee871e3b", "toPort": "0", "fromPort": "0" }, { "to": "1dca24f0-285d-402e-a961-33e757934d12", "from": "fe2a2a00-3f37-4ca1-b38a-3091b4d577f5", "toPort": "0", "fromPort": "0" }, { "to": "46d71fc4-9f17-4635-8f0b-692d7ee3e0d7", "from": "59e7faf4-d3ed-4422-92b3-e1bcaac0bb8f", "toPort": "1", "fromPort": "0" }, { "to": "6dfdcc94-ca0b-4edf-b1b5-75baf14fba55", "from": "41752228-49fe-40bc-a0dc-5d00f7a0c1b8", "toPort": "0", "fromPort": "0" }, { "to": "59e7faf4-d3ed-4422-92b3-e1bcaac0bb8f", "from": "7e8d7622-6c5d-468b-b7b3-49cd2a394394", "toPort": "0", "fromPort": "0" }, { "to": "d9463e4e-e7dc-4335-bf72-0b58ee871e3b", "from": "7e8d7622-6c5d-468b-b7b3-49cd2a394394", "toPort": "0", "fromPort": "0" }, { "to": "453d7da8-74c4-4182-a899-85eb154b9607", "from": "3b72e912-8bc1-4cc9-a24d-81b67207ceea", "toPort": "0", "fromPort": "0" }, { "to": "41752228-49fe-40bc-a0dc-5d00f7a0c1b8", "from": "453d7da8-74c4-4182-a899-85eb154b9607", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "59e7faf4-d3ed-4422-92b3-e1bcaac0bb8f", "name": "Upload file", "type": "integration", "params": { "name": "={{$json[\"Screenshot\"][\"filename\"]}}", "driveId": { "__rl": true, "mode": "id", "value": "" }, "options": { "simplifyOutput": false }, "service": "googleDrive", "folderId": { "__rl": true, "mode": "id", "value": "" }, "operation": "read", "inputDataFieldName": "=Screenshot" }, "position": [ -528, 336 ] }, { "id": "3b72e912-8bc1-4cc9-a24d-81b67207ceea", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "weeks", "triggerAtDay": [ 6 ], "triggerAtHour": 10 } ] } }, "position": [ -752, 656 ] }, { "id": "d9463e4e-e7dc-4335-bf72-0b58ee871e3b", "name": "calcDate", "type": "code", "params": { "jsCode": "const purchaseDate = new Date($json['Purchase Date']);\nconst delay = parseInt($json['Redeem Delay']);\n\nconst claimableDate = new Date(purchaseDate);\nclaimableDate.setDate(purchaseDate.getDate() + delay);\n\nreturn [{\n json: {\n ...$json,\n 'Claimable Date': claimableDate.toISOString().split('T')[0]\n }\n}];" }, "position": [ -528, 208 ] }, { "id": "453d7da8-74c4-4182-a899-85eb154b9607", "name": "Get row(s) in sheet", "type": "integration", "params": { "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "", "cachedResultUrl": "", "cachedResultName": "" }, "documentId": { "__rl": true, "mode": "list", "value": "" } }, "position": [ -528, 656 ] }, { "id": "122edb03-03ae-446d-98d3-8e12e46c4332", "name": "Send a message", "type": "integration", "params": { "sendTo": "", "message": "={{ $json.body }}\n", "options": { "appendAttribution": false }, "service": "gmail", "subject": "=Weekly Claimable Bonus Points - Checked {{ $json.dateChecked }}", "operation": "read" }, "position": [ 160, 656 ] }, { "id": "41752228-49fe-40bc-a0dc-5d00f7a0c1b8", "name": "filteredRows", "type": "code", "params": { "jsCode": "const today = new Date();\nconst todayStr = today.toISOString().slice(0, 10);\n\nconst filtered = items.filter(item => {\n const claimDate = new Date(item.json[\"Claimable Date\"]);\n return claimDate <= today;\n}).map(item => {\n return {\n json: {\n ...item.json,\n currentDate: todayStr\n }\n };\n});\n\nreturn filtered;" }, "position": [ -288, 656 ] }, { "id": "6dfdcc94-ca0b-4edf-b1b5-75baf14fba55", "name": "rewrite", "type": "code", "params": { "jsCode": "const today = new Date();\nconst todayStr = today.toISOString().slice(0, 10);\n\nconst rows = items\n .map(i => i.json)\n .filter(r => new Date(r[\"Claimable Date\"]) <= today);\n\nif (rows.length === 0) {\n return [{\n json: {\n body: \"

No claimable points this week.

\",\n dateChecked: todayStr\n }\n }];\n}\n\n// Build HTML table\nlet html = `

Claimable Bonus Points as of ${todayStr}:

`;\nhtml += ``;\nhtml += \"\";\n\n// Updated headers\nconst headers = [\n \"Row\",\n \"Coupon Name\",\n \"Account Used to Buy\",\n \"Program\",\n \"Points\",\n \"Bonus Points\",\n \"Purchase Date\",\n \"Redeem Delay (days)\",\n \"Claimable Date\",\n \"Coupon Screen\"\n];\n\nheaders.forEach(h => {\n html += ``;\n});\nhtml += \"\";\n\n// Add rows\nrows.forEach(r => {\n html += \"\";\n html += ``;\n html += ``;\n html += ``;\n html += ``;\n html += ``;\n html += ``;\n html += ``;\n html += ``;\n html += ``;\n html += ``;\n html += \"\";\n});\n\nhtml += \"

${h}
${r.row_number \|\| \"\"}	${r[\"Coupon Name\"] \|\| \"\"}	${r[\"Account Used to Buy\"] \|\| \"\"}	${r[\"Program\"] \|\| \"\"}	${r[\"Points\"] \|\| \"\"}	${r[\"Bonus Points\"] \|\| \"\"}	${r[\"Purchase Date\"] \|\| \"\"}	${r[\"Redeem Delay (days)\"] \|\| \"\"}	${r[\"Claimable Date\"] \|\| \"\"}	${r[\"Coupon Screen\"] \|\| \"\"}

\";\n\nreturn [{\n json: {\n body: html,\n dateChecked: todayStr\n }\n}];\n" }, "position": [ -64, 656 ] }, { "id": "46d71fc4-9f17-4635-8f0b-692d7ee3e0d7", "name": "Merge", "type": "merge", "params": { "mode": "combine", "options": {}, "combineBy": "combineAll" }, "position": [ -288, 272 ] }, { "id": "7e8d7622-6c5d-468b-b7b3-49cd2a394394", "name": "Tracking Form", "type": "trigger", "params": { "kind": "n8n-nodes-base.formTrigger", "path": "CouponTracker", "options": { "formSubmittedText": "Your response has been recorded" }, "formTitle": "Coupon Points Tracker", "formFields": { "values": [ { "fieldLabel": "Coupon Name", "requiredField": true }, { "fieldLabel": "Account Used", "requiredField": true }, { "fieldType": "dropdown", "fieldLabel": "Program", "fieldOptions": { "values": [ { "option": "Payback" }, { "option": "Miles and More" }, { "option": "OTHER" } ] }, "requiredField": true }, { "fieldType": "number", "fieldLabel": "Base Points Expected", "requiredField": true }, { "fieldType": "number", "fieldLabel": "Extra Points Expected" }, { "fieldType": "date", "fieldLabel": "Purchase Date", "requiredField": true }, { "fieldType": "number", "fieldLabel": "Redeem Delay", "requiredField": true }, { "fieldType": "file", "fieldLabel": "Screenshot", "multipleFiles": false } ] } }, "position": [ -752, 272 ] }, { "id": "1dca24f0-285d-402e-a961-33e757934d12", "name": "Append row in sheet", "type": "integration", "params": { "columns": { "value": { "Coupon Name": "={{ $json['Coupon Name'] }}" }, "schema": [ { "id": "Coupon Name", "type": "string", "display": true, "required": false, "displayName": "Coupon Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Account Used to Buy", "type": "string", "display": true, "required": false, "displayName": "Account Used to Buy", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Program", "type": "string", "display": true, "required": false, "displayName": "Program", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Points", "type": "string", "display": true, "required": false, "displayName": "Points", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Bonus Points", "type": "string", "display": true, "required": false, "displayName": "Bonus Points", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Purchase Date", "type": "string", "display": true, "required": false, "displayName": "Purchase Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Redeem Delay (days)", "type": "string", "display": true, "required": false, "displayName": "Redeem Delay (days)", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Claimable Date", "type": "string", "display": true, "required": false, "displayName": "Claimable Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Coupon Screen", "type": "string", "display": true, "required": false, "displayName": "Coupon Screen", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "fields", "type": "string", "display": true, "removed": false, "required": false, "displayName": "fields", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "autoMapInputData", "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": "", "cachedResultUrl": "", "cachedResultName": "" } }, "position": [ 160, 272 ] }, { "id": "fe2a2a00-3f37-4ca1-b38a-3091b4d577f5", "name": "Clean Set", "type": "set", "params": { "values": { "string": [ { "name": "Coupon Name", "value": "={{ $json[\"Coupon Name\"] }}" }, { "name": "Account Used to Buy", "value": "={{ $json[\"Account Used\"] }}" }, { "name": "Program", "value": "={{ $json[\"Program\"] }}" }, { "name": "Points", "value": "={{ $json[\"Base Points Expected\"] }}" }, { "name": "Bonus Points", "value": "={{ $json[\"Extra Points Expected\"] }}" }, { "name": "Purchase Date", "value": "={{ $json[\"Purchase Date\"] }}" }, { "name": "Redeem Delay (days)", "value": "={{ $json[\"Redeem Delay\"] }}" }, { "name": "Claimable Date", "value": "={{ $json[\"Claimable Date\"] }}" }, { "name": "Coupon Screen", "value": "={{ $json[\"webViewLink\"] }}" } ] }, "options": {}, "keepOnlySet": true }, "position": [ -64, 272 ] } ] }

Track coupon points with Google Sheets, Drive Storage, and Gmail weekly summary