Workflow: Googlesheetstrigger Workflow
Integrations: googleSheets, googleSheetsTrigger, httpRequest, if, removeDuplicates, stickyNote

{"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."}], "pinData": {}, "connections": {"a6c952c3-bc17-44cf-b661-898068914480": {"main": [[{"node": "error-handler-a6c952c3-bc17-44cf-b661-898068914480", "type": "main", "index": 0}], [{"node": "error-handler-a6c952c3-bc17-44cf-b661-898068914480-ba330bc9", "type": "main", "index": 0}], [{"node": "error-handler-a6c952c3-bc17-44cf-b661-898068914480-582b6959", "type": "main", "index": 0}], [{"node": "error-handler-a6c952c3-bc17-44cf-b661-898068914480-dc001f13", "type": "main", "index": 0}], [{"node": "error-handler-a6c952c3-bc17-44cf-b661-898068914480-0a01b6f1", "type": "main", "index": 0}], [{"node": "error-handler-a6c952c3-bc17-44cf-b661-898068914480-56f4bd54", "type": "main", "index": 0}], [{"node": "error-handler-a6c952c3-bc17-44cf-b661-898068914480-38a05c74", "type": "main", "index": 0}], [{"node": "error-handler-a6c952c3-bc17-44cf-b661-898068914480-c4b9b475", "type": "main", "index": 0}], [{"node": "error-handler-a6c952c3-bc17-44cf-b661-898068914480-9f57153a", "type": "main", "index": 0}]]}, "e033bb47-6d34-487b-9cb4-952d002f387e": {"main": [[{"node": "error-handler-e033bb47-6d34-487b-9cb4-952d002f387e-60d78ab1", "type": "main", "index": 0}]]}, "c350ff47-d30e-4aa1-8470-9808525111b7": {"main": [[{"node": "error-handler-c350ff47-d30e-4aa1-8470-9808525111b7-19e36e39", "type": "main", "index": 0}]]}}, "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.", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "notes": "Excellent quality workflow: Googlesheetstrigger Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}