New price {{ $('Format Product').item.json[\"price\"] }} CHF is bellow {{ $('List Products').item.json[\"price_alert\"] }} CHF
\n\nView product: {{ $('List Products').item.json[\"link\"] }}\n\n\n","options":{},"subject":"=⚠️ Price Reduction: {{ $('Format Product').item.json.name }}\n"},"credentials":{"gmailOAuth2":{"id":"DMcPDN0IHPwGmI7f","name":"Gmail account"}},"typeVersion":2.1,"notes":"This gmail node performs automated tasks as part of the workflow."},{"id":"427f51a9-7ebf-42df-bb97-e0a17a37d2cb","name":"Monitor Zalando Product","type":"n8n-nodes-base.formTrigger","position":[380,280],"webhookId":"6da9a655-b46b-454d-bb96-32e203627a20","parameters":{"path":"6da9a655-b46b-454d-bb96-32e203627a20","options":{},"formTitle":"Add Product","formFields":{"values":[{"fieldLabel":"link","requiredField":true},{"fieldType":"number","fieldLabel":"price_alert","requiredField":true}]},"formDescription":"Past in a Zalando URL and the price bellow you would like to be notified"},"typeVersion":2,"notes":"This formTrigger node performs automated tasks as part of the workflow."},{"id":"39711d6f-d699-415b-9a1b-3971839e7e8a","name":"Add Product","type":"n8n-nodes-base.googleSheets","position":[580,280],"parameters":{"columns":{"value":{"link":"={{ $json.link }}","price_alert":"={{ $json.price_alert }}"},"schema":[{"id":"link","type":"string","display":true,"removed":false,"required":false,"displayName":"link","defaultMatch":false,"canBeUsedToMatch":true},{"id":"price_alert","type":"string","display":true,"required":false,"displayName":"price_alert","defaultMatch":false,"canBeUsedToMatch":true},{"id":"price","type":"string","display":true,"removed":true,"required":false,"displayName":"price","defaultMatch":false,"canBeUsedToMatch":true},{"id":"name","type":"string","display":true,"removed":true,"required":false,"displayName":"name","defaultMatch":false,"canBeUsedToMatch":true},{"id":"update","type":"string","display":true,"removed":true,"required":false,"displayName":"update","defaultMatch":false,"canBeUsedToMatch":true}],"mappingMode":"defineBelow","matchingColumns":["link"]},"options":{},"operation":"appendOrUpdate","sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Links"},"documentId":{"__rl":true,"mode":"list","value":"1sM66Rk10ZOhQKbawVB-xZ2WYhBeSr6wnJqvX6Aspbkg","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Zalando Links"}},"credentials":{"googleSheetsOAuth2Api":{"id":"1nTQmlgxR0AJJDGA","name":"n8ninja - Sheet"}},"typeVersion":4.3,"alwaysOutputData":true,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"id":"881acff3-1736-4d53-8c3b-3354ec2da07b","name":"Sticky Note1","type":"n8n-nodes-base.stickyNote","position":[400,-191],"parameters":{"color":6,"width":275.01592825011585,"height":439.37809705210145,"content":"# Setup\n### 1/ Add Your credentials\n[Google SHeet]({{ $env.WEBHOOK_URL }}\n\n### 2/ Create a Google Spreadsheet that will be your database.\nCopy this template: \n{{ $env.WEBHOOK_URL }}\n\n### 3/ Add products to monitor from this form \n# 👇"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"92ae590a-bf1d-4c17-a654-f281379fcee6","name":"Sticky Note","type":"n8n-nodes-base.stickyNote","position":[1620,600],"parameters":{"color":6,"width":275.01592825011585,"height":93.37809705210145,"content":"### Fill with your email\n# 👇"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"8834da7f-7ca1-4cad-98b9-2335bfc81b8f","name":"Sticky Note2","type":"n8n-nodes-base.stickyNote","position":[40,580],"parameters":{"color":6,"width":275.01592825011585,"height":136.37809705210145,"content":"### Change frequency 👉🏻\n\n(don't put less than once a day, or you will need to also add the hour in the format product node)\n"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"b1838412-6c3e-4519-8946-f6aeff0c9e8d","name":"Sticky Note3","type":"n8n-nodes-base.stickyNote","position":[900,340],"parameters":{"color":7,"width":202.64787116404852,"height":85.79488430601403,"content":"### Crafted by the\n## [🥷 n8n.ninja](n8n.ninja)"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."}],"connections":{"Scrap Product":{"main":[[],[],[],[],[],[],[],[],[]]},"Add Log in History":{"main":[[]]},"Update Products Infos":{"main":[[]]},"List Products":{"main":[[]]},"Add Product":{"main":[[]]}},"name":"Googlesheets Workflow","settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"description":"Automated workflow: Googlesheets Workflow. This workflow integrates 9 different services: stickyNote, httpRequest, formTrigger, scheduleTrigger, set. It contains 20 nodes and follows best practices for error handling and security.","meta":{"instanceId":"workflow-ac2689a0","versionId":"1.0.0","createdAt":"2025-09-29T07:07:51.894639","updatedAt":"2025-09-29T07:07:51.894647","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"notes":"Excellent quality workflow: Googlesheets Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}