Hi {{ $('On form submission').item.json.Name }},
\n Scan the QR code below to claim your special discount.
Hurry, the offer is limited!
\n\n\n","options":{},"subject":"[n8n] Exclusive Discount Coupon","toEmail":"={{ $('Form Fields').item.json.Email }}","fromEmail":"=EMAILFROM"},"credentials":{"smtp":{"id":"hRjP3XbDiIQqvi7x","name":"SMTP info@n3witalia.com"}},"typeVersion":2.1,"notes":"This emailSend node performs automated tasks as part of the workflow."},{"id":"5893bd1d-762d-4337-8392-6d358002845a","name":"Update Lead","type":"n8n-nodes-base.httpRequest","position":[1020,100],"parameters":{"url":"{{ $env.BASE_URL }}","method":"PATCH","options":{"response":{"response":{"responseFormat":"json"}}},"jsonBody":"={\n \"data\": {\n \"type\": \"Leads\",\n \"id\": \"{{ $('Not used?').item.json['ID LEAD'] }}\",\n \"attributes\": {\n \"coupon_used_c\": \"yes\"\n }\n }\n}","sendBody":true,"sendHeaders":true,"specifyBody":"json","headerParameters":{"parameters":[{"name":"Authorization","value":"=Bearer {{$node[\"Token SuiteCRM 1\"].json[\"access_token\"]}}"},{"name":"Content-Type","value":"application/vnd.api+json"}]}},"notesInFlow":true,"typeVersion":3,"notes":"This httpRequest node performs automated tasks as part of the workflow."},{"id":"fd0a43f4-a3f1-4008-947c-f8208d2126f7","name":"Not used?","type":"n8n-nodes-base.if","position":[540,240],"parameters":{"options":{},"conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"50546d87-ab37-4c8a-b835-e1a60f3aa0dc","operator":{"type":"string","operation":"empty","singleValue":true},"leftValue":"={{ $json['USED COUPON?'] }}","rightValue":""},{"id":"025a42b8-fb90-44a8-951a-0e321b42c3b9","operator":{"type":"number","operation":"exists","singleValue":true},"leftValue":"={{ $json.row_number }}","rightValue":""}]}},"typeVersion":2.2,"notes":"This if node performs automated tasks as part of the workflow."},{"id":"0029c366-aec1-4305-aab5-2ab6845e2828","name":"Coupon OK","type":"n8n-nodes-base.respondToWebhook","position":[1480,100],"parameters":{"options":{},"respondWith":"text","responseBody":"Qr valid!"},"typeVersion":1.1,"notes":"This respondToWebhook node performs automated tasks as part of the workflow."},{"id":"4c326412-0965-4f1c-9b77-2704d37a7151","name":"No coupon","type":"n8n-nodes-base.respondToWebhook","position":[320,460],"parameters":{"options":{"responseCode":200},"respondWith":"text","responseBody":"Coupon not valid"},"typeVersion":1.1,"notes":"This respondToWebhook node performs automated tasks as part of the workflow."},{"id":"e18cf9e7-584d-4f49-88b8-4c3a513ff613","name":"Coupon KO","type":"n8n-nodes-base.respondToWebhook","position":[800,320],"parameters":{"options":{"responseCode":200},"respondWith":"text","responseBody":"Coupon already used"},"typeVersion":1.1,"notes":"This respondToWebhook node performs automated tasks as part of the workflow."},{"id":"55a63a65-5472-4e50-8150-604c6bc9dd18","name":"Token SuiteCRM 1","type":"n8n-nodes-base.httpRequest","position":[800,100],"parameters":{"url":"{{ $env.BASE_URL }}","options":{},"requestMethod":"POST","bodyParametersUi":{"parameter":[{"name":"grant_type","value":"client_credentials"},{"name":"client_id","value":"CLIENTID"},{"name":"client_secret","value":"CLIENTSECRET"}]},"allowUnauthorizedCerts":true},"notesInFlow":true,"typeVersion":1,"notes":"This httpRequest node performs automated tasks as part of the workflow."},{"id":"c843c9f2-9940-423c-bc9d-8530fb43f229","name":"Set coupon","type":"n8n-nodes-base.set","position":[-180,340],"parameters":{"options":{},"assignments":{"assignments":[{"id":"4e9a4330-d654-410f-9b99-aa57545c2c80","name":"qr","type":"string","value":"={{ $json.query.qr }}"}]}},"typeVersion":3.4,"notes":"This set node performs automated tasks as part of the workflow."},{"id":"9a2d877d-9016-460e-b376-ea27c59a492a","name":"Get Lead","type":"n8n-nodes-base.googleSheets","position":[320,240],"parameters":{"options":{"returnFirstMatch":true},"filtersUI":{"values":[{"lookupValue":"={{ $json.qr }}","lookupColumn":"COUPON"}]},"sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Foglio1"},"documentId":{"__rl":true,"mode":"list","value":"1lnRZodxZSOA0QSuzkAb7ZJcfFfNXpX7NcxMdckMTN90","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Coupon"}},"credentials":{"googleSheetsOAuth2Api":{"id":"JYR6a64Qecd6t8Hb","name":"Google Sheets account"}},"typeVersion":4.5,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"id":"da2e62e5-898c-4024-8d85-517b18dcefc3","name":"Sticky Note","type":"n8n-nodes-base.stickyNote","position":[-200,280],"parameters":{"width":360,"height":220,"content":"Check if the QR code scan is valid"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"507dc2ab-a762-49b8-a13a-c9b20c7135d8","name":"Sticky Note1","type":"n8n-nodes-base.stickyNote","position":[300,180],"parameters":{"width":360,"height":220,"content":"Check if coupon is valid"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"f44b5645-1611-4c16-83ac-ee8a4821970b","name":"Sticky Note5","type":"n8n-nodes-base.stickyNote","position":[760,40],"parameters":{"width":420,"height":220,"content":"Enter the lead with the relative coupon on Suite CRM. Change SUITECRMURL, CLIENTSECRET and CLIENTID"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"ad0a5999-2616-4c7b-8108-6f13e573490b","name":"Update coupon used","type":"n8n-nodes-base.googleSheets","position":[1240,100],"parameters":{"columns":{"value":{"ID LEAD":"={{ $json.data.id }}","USED COUPON?":"yes"},"schema":[{"id":"NAME","type":"string","display":true,"required":false,"displayName":"NAME","defaultMatch":false,"canBeUsedToMatch":true},{"id":"SURNAME","type":"string","display":true,"required":false,"displayName":"SURNAME","defaultMatch":false,"canBeUsedToMatch":true},{"id":"EMAIL","type":"string","display":true,"required":false,"displayName":"EMAIL","defaultMatch":false,"canBeUsedToMatch":true},{"id":"PHONE","type":"string","display":true,"required":false,"displayName":"PHONE","defaultMatch":false,"canBeUsedToMatch":true},{"id":"COUPON","type":"string","display":true,"required":false,"displayName":"COUPON","defaultMatch":false,"canBeUsedToMatch":true},{"id":"DATE","type":"string","display":true,"required":false,"displayName":"DATE","defaultMatch":false,"canBeUsedToMatch":true},{"id":"ID LEAD","type":"string","display":true,"removed":false,"required":false,"displayName":"ID LEAD","defaultMatch":false,"canBeUsedToMatch":true},{"id":"USED COUPON?","type":"string","display":true,"required":false,"displayName":"USED COUPON?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"row_number","type":"string","display":true,"removed":true,"readOnly":true,"required":false,"displayName":"row_number","defaultMatch":false,"canBeUsedToMatch":true}],"mappingMode":"defineBelow","matchingColumns":["ID LEAD"],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{},"operation":"update","sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Foglio1"},"documentId":{"__rl":true,"mode":"list","value":"1lnRZodxZSOA0QSuzkAb7ZJcfFfNXpX7NcxMdckMTN90","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Coupon"}},"credentials":{"googleSheetsOAuth2Api":{"id":"JYR6a64Qecd6t8Hb","name":"Google Sheets account"}},"typeVersion":4.5,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"id":"acd6a7fb-aeae-4baf-8f60-af16715a6de6","name":"Sticky Note6","type":"n8n-nodes-base.stickyNote","position":[1560,-380],"parameters":{"width":220,"height":220,"content":"Set the Webhook URL"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"091a00b6-34bd-4221-b2f1-4d55719a273a","name":"Sticky Note7","type":"n8n-nodes-base.stickyNote","position":[-480,-900],"parameters":{"color":3,"width":680,"height":240,"content":"## Coupon assignment and simple validation system\n\nThis workflow is designed to manage the assignment and validation of unique QR code coupons within a lead generation system. The process begins with a webhook that receives data from a user-filled form, containing information such as name, surname, email, and phone number. This data is then processed to check if the lead already exists in the system, preventing duplicates.\n\nDISCLAIMER: The system is very simple and basic but can be improved and made very efficient through specific controls and new implementations"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."}],"active":false,"settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"versionId":"00ea32a4-635c-41c0-a789-e7b45efdf193","connections":{"Webhook":{"main":[[],[],[],[],[],[],[],[],[]]},"Token SuiteCRM":{"main":[[],[],[],[],[],[],[],[],[]]},"Create Lead SuiteCRM":{"main":[[],[],[],[],[],[],[],[],[]]},"Get QR":{"main":[[],[],[],[],[],[],[],[],[]]},"Update Lead":{"main":[[],[],[],[],[],[],[],[],[]]},"Coupon OK":{"main":[[],[],[],[],[],[],[],[],[]]},"No coupon":{"main":[[],[],[],[],[],[],[],[],[]]},"Coupon KO":{"main":[[],[],[],[],[],[],[],[],[]]},"Token SuiteCRM 1":{"main":[[],[],[],[],[],[],[],[],[]]},"Duplicate Lead?":{"main":[[]]},"Get Coupon":{"main":[[]]},"Update Sheet":{"main":[[]]},"Send Email":{"main":[[],[],[],[],[],[],[],[]]},"Get Lead":{"main":[[]]},"Update coupon used":{"main":[[]]}},"description":"Automated workflow: Unique QRcode coupon assignment and validation for Lead Generation system. This workflow integrates 10 different services: webhook, stickyNote, httpRequest, formTrigger, set. It contains 53 nodes and follows best practices for error handling and security.","notes":"Excellent quality workflow: Unique QRcode coupon assignment and validation for Lead Generation system. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}