{ "edges": [ { "to": "0bc1a6e8-1815-4707-bb6c-8e45862467f5", "from": "b02df9dd-cc1b-4c0a-9395-a9fdc55a1940", "toPort": "0", "fromPort": "0" }, { "to": "cf3113ce-4987-42f4-b0f1-2c929fbcd83f", "from": "02d8bb3f-8fca-47b6-973f-7712f28bd688", "toPort": "0", "fromPort": "0" }, { "to": "b02df9dd-cc1b-4c0a-9395-a9fdc55a1940", "from": "88d8d706-e0a2-4a44-8241-2ad02d833530", "toPort": "0", "fromPort": "0" }, { "to": "2f9f3414-66fd-4234-ab2d-364958da72db", "from": "95640737-cf0b-492f-a59b-f309e37fa57b", "toPort": "0", "fromPort": "0" }, { "to": "0d5d103d-c9ab-4bbc-ae7e-4a7dfba2cea9", "from": "95640737-cf0b-492f-a59b-f309e37fa57b", "toPort": "0", "fromPort": "1" }, { "to": "cec20384-722f-435c-8b6c-cd63e6416935", "from": "95640737-cf0b-492f-a59b-f309e37fa57b", "toPort": "0", "fromPort": "2" }, { "to": "02d8bb3f-8fca-47b6-973f-7712f28bd688", "from": "0bc1a6e8-1815-4707-bb6c-8e45862467f5", "toPort": "0", "fromPort": "1" }, { "to": "ad472c6b-7db7-441f-a8d9-8fbd86e710df", "from": "000e8299-b381-49ec-9c93-97843713ad5b", "toPort": "0", "fromPort": "0" }, { "to": "b02df9dd-cc1b-4c0a-9395-a9fdc55a1940", "from": "cec20384-722f-435c-8b6c-cd63e6416935", "toPort": "0", "fromPort": "0" }, { "to": "0bc1a6e8-1815-4707-bb6c-8e45862467f5", "from": "ad472c6b-7db7-441f-a8d9-8fbd86e710df", "toPort": "0", "fromPort": "0" }, { "to": "95640737-cf0b-492f-a59b-f309e37fa57b", "from": "cf3113ce-4987-42f4-b0f1-2c929fbcd83f", "toPort": "0", "fromPort": "0" }, { "to": "b02df9dd-cc1b-4c0a-9395-a9fdc55a1940", "from": "0d5d103d-c9ab-4bbc-ae7e-4a7dfba2cea9", "toPort": "0", "fromPort": "0" }, { "to": "88d8d706-e0a2-4a44-8241-2ad02d833530", "from": "2f9f3414-66fd-4234-ab2d-364958da72db", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "000e8299-b381-49ec-9c93-97843713ad5b", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ {} ] } }, "position": [ -672, 0 ] }, { "id": "ad472c6b-7db7-441f-a8d9-8fbd86e710df", "name": "Get row(s) in sheet", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "", "cachedResultName": "list urls" }, "documentId": { "__rl": true, "mode": "url", "value": "" } }, "position": [ -304, 0 ] }, { "id": "02d8bb3f-8fca-47b6-973f-7712f28bd688", "name": "Decodo", "type": "integration", "params": { "url": "={{ $json.url }}", "service": "decodo", "operation": "amazon", "__originalType": "@decodo/n8n-nodes-decodo.decodo" }, "position": [ 256, 16 ] }, { "id": "cf3113ce-4987-42f4-b0f1-2c929fbcd83f", "name": "Calculate Price Changes", "type": "code", "params": { "jsCode": "// Loop over input items and add a new field called 'myNewField' to the JSON of each one\nconst diff = $input.first().json.results[0].content.results.price_upper - $('Loop Over Items').first().json['baseline price (usd)']\n\nconst diffPercentage = (diff / $('Loop Over Items').first().json['baseline price (usd)']) * 100\n\nreturn {\n price: $input.first().json.results[0].content.results.price_upper,\n baseline: $('Loop Over Items').first().json['baseline price (usd)'],\n diff,\n title: $input.first().json.results[0].content.results.title,\n diffPercentage: Math.ceil(diffPercentage),\n url: $input.first().json.results[0].content.results.url,\n \n}" }, "position": [ 512, 0 ] }, { "id": "95640737-cf0b-492f-a59b-f309e37fa57b", "name": "Price Routing", "type": "switch", "params": { "rules": { "values": [ { "outputKey": "High", "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "790f7683-114f-4ca0-ba7d-7ff3b0d1fb18", "operator": { "type": "number", "operation": "gt" }, "leftValue": "={{ $json.diffPercentage }}", "rightValue": 10 } ] }, "renameOutput": true }, { "outputKey": "Normal", "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "0604d34f-29df-46f5-913d-7200d5e3f228", "operator": { "type": "number", "operation": "gte" }, "leftValue": "={{ $json.diffPercentage }}", "rightValue": 0 } ] }, "renameOutput": true }, { "outputKey": "Low", "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "7b823d5a-e1fb-4532-aeaf-dd8365448c53", "operator": { "type": "number", "operation": "lt" }, "leftValue": "={{ $json.diffPercentage }}", "rightValue": 0 } ] }, "renameOutput": true } ] }, "options": {} }, "position": [ 720, -16 ] }, { "id": "88d8d706-e0a2-4a44-8241-2ad02d833530", "name": "Set Meeting", "type": "integration", "params": { "end": "={{ $now.plus(3, 'hour') }}", "start": "={{ $now.plus(2, 'hour') }}", "service": "googleCalendar", "calendar": { "__rl": true, "mode": "list", "value": "", "cachedResultName": "" }, "operation": "read", "additionalFields": { "summary": "=[IMPORTANT DISCUSSION] Price Increase {{ $('Calculate Price Changes').item.json.title }} ", "attendees": [ "user@example.com", "user@example.com" ], "description": "=🚨 Price Increase Detected\nProduct: {{ $('Calculate Price Changes').item.json.title }}\nCurrent Price: USD {{ $('Calculate Price Changes').item.json.price }}\nNormal Price: USD {{ $('Calculate Price Changes').item.json.baseline }}\nPrice increased by +{{ $('Calculate Price Changes').item.json.diffPercentage }}%, which exceeds your alert threshold.\n👉 Check details: {{ $('Calculate Price Changes').item.json.url }}\n" } }, "position": [ 1248, -400 ] }, { "id": "2f9f3414-66fd-4234-ab2d-364958da72db", "name": "Send Message to Top Management", "type": "integration", "params": { "text": "=🚨 Price Increase Detected\nProduct: {{ $json.title }}\nCurrent Price: USD {{ $json.price }}\nNormal Price: USD {{ $json.baseline }}\nPrice increased by +{{ $json.diffPercentage }}%, which exceeds your alert threshold.\n👉 Check details: {{ $json.url }}\n", "service": "telegram", "operation": "read", "additionalFields": {} }, "position": [ 1008, -400 ] }, { "id": "cec20384-722f-435c-8b6c-cd63e6416935", "name": "Email Stakeholders", "type": "integration", "params": { "sendTo": "user@example.com", "message": "=\n\n\n \n \n Price Drop Alert\n \n\n\n \n \n \n \n

\n \n \n \n \n \n \n\n \n \n \n \n

\n \n \n \n \n

\n Price Drop Alert\n

\n 🎉 Price decreased: {{ $('Calculate Price Changes').item.json.title }}\n

\n Good news — the price for {{ $('Calculate Price Changes').item.json.title }} has dropped. Below are the details from the latest check:\n

\n\n \n \n \n \n \n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n

\n Baseline price\n	\n USD {{ $('Calculate Price Changes').item.json.baseline }}\n
\n Current price\n	\n {{ $('Calculate Price Changes').item.json.price }}\n
\n Change\n	\n {{ $('Calculate Price Changes').item.json.diffPercentage }}% ↓\n

\n\n \n

\n Recommendation:\n

\n \n \n \n \n \n

\n \n View product & buy now\n \n

\n\n

\n\n\n", "options": {}, "service": "gmail", "subject": "=Price Drop - {{ $('Calculate Price Changes').item.json.title }}", "operation": "read" }, "position": [ 1104, 112 ] }, { "id": "0d5d103d-c9ab-4bbc-ae7e-4a7dfba2cea9", "name": "No Operation, do nothing", "type": "passthrough", "params": { "mode": "noOp" }, "position": [ 1104, -128 ] }, { "id": "0bc1a6e8-1815-4707-bb6c-8e45862467f5", "name": "Loop Over Items", "type": "passthrough", "params": { "mode": "noOp", "options": {} }, "position": [ 16, 0 ] }, { "id": "b02df9dd-cc1b-4c0a-9395-a9fdc55a1940", "name": "Wait", "type": "passthrough", "params": { "mode": "noOp" }, "position": [ 1520, 96 ] } ] }

Automated Amazon price monitoring & alerts with Decodo, Google Sheets & Telegram