{"meta":{"instanceId":"workflow-160b5855","versionId":"1.0.0","createdAt":"2025-09-29T07:07:45.853316","updatedAt":"2025-09-29T07:07:45.853384","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"nodes":[{"id":"e033bb47-6d34-487b-9cb4-952d002f387e","name":"Google Sheets Trigger","type":"n8n-nodes-base.googleSheetsTrigger","position":[-320,540],"parameters":{"options":{},"pollTimes":{"item":[{"mode":"everyMinute"}]},"sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Sheet1"},"documentId":{"__rl":true,"mode":"url","value":"{{ $env.WEBHOOK_URL }}"}},"credentials":{"googleSheetsTriggerOAuth2Api":{"id":"o5WqBpa5EJcKTpKq","name":"5@gmail"}},"typeVersion":1,"notes":"This googleSheetsTrigger node performs automated tasks as part of the workflow."},{"id":"1b6af5fd-90ee-44e7-8afe-cb3c844491f7","name":"Remove Duplicates","type":"n8n-nodes-base.removeDuplicates","position":[120,520],"parameters":{"compare":"selectedFields","options":{},"fieldsToCompare":"Email"},"typeVersion":1,"notes":"This removeDuplicates node performs automated tasks as part of the workflow."},{"id":"a6c952c3-bc17-44cf-b661-898068914480","name":"Verify your emails","type":"n8n-nodes-base.httpRequest","onError":"continueRegularOutput","position":[280,520],"parameters":{"url":"{{ $env.API_BASE_URL }}","method":"POST","options":{},"sendBody":true,"contentType":"form-urlencoded","sendHeaders":true,"bodyParameters":{"parameters":[{"name":"email","value":"={{ $json.Email }}"}]},"headerParameters":{"parameters":[{"name":"api_key","value":"9Q6H0QETRF=GS1"}]}},"retryOnFail":true,"typeVersion":4.1,"notes":"This httpRequest node performs automated tasks as part of the workflow."},{"id":"b5887e19-e5c2-4896-bbda-1835a51e1e1b","name":"Sticky Note","type":"n8n-nodes-base.stickyNote","position":[-400,440],"parameters":{"color":4,"width":1083.1212624694333,"height":364.82606941347825,"content":"## Check email deliverability "},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"c350ff47-d30e-4aa1-8470-9808525111b7","name":"Update data to google sheets","type":"n8n-nodes-base.googleSheets","position":[500,520],"parameters":{"columns":{"value":{},"schema":[{"id":"Email","type":"string","display":true,"removed":false,"required":false,"displayName":"Email","defaultMatch":false,"canBeUsedToMatch":true}],"mappingMode":"autoMapInputData","matchingColumns":["Email"]},"options":{},"operation":"update","sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Sheet1"},"documentId":{"__rl":true,"mode":"list","value":"1rzuojNGTaBvaUEON6cakQRDva3ueGg5kNu9v12aaSP4","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"n8n Template-Email Validation"}},"credentials":{"googleSheetsOAuth2Api":{"id":"uv83GKvueqitpnrd","name":"5@gmail"}},"typeVersion":4.3,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"id":"3bbdd0f1-66b6-4774-bb93-44336b827d3e","name":"If Email Exists","type":"n8n-nodes-base.if","position":[-100,540],"parameters":{"options":{},"conditions":{"options":{"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"84aff430-6fe2-4c39-940a-178d2dcd1d09","operator":{"type":"string","operation":"empty","singleValue":true},"leftValue":"={{ $json.Status }}","rightValue":""}]}},"typeVersion":2,"notes":"This if node performs automated tasks as part of the workflow."}],"connections":{"Verify your emails":{"main":[[],[],[],[],[],[],[],[],[]]},"Google Sheets Trigger":{"main":[[]]},"Update data to google sheets":{"main":[[]]}},"name":"Googlesheetstrigger 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: Googlesheetstrigger Workflow. This workflow integrates 7 different services: stickyNote, httpRequest, googleSheetsTrigger, stopAndError, googleSheets. It contains 10 nodes and follows best practices for error handling and security.","notes":"Excellent quality workflow: Googlesheetstrigger Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}