Workflow: Postgrestrigger Workflow
Integrations: code, filter, googleSheets, manualTrigger, postgresTrigger, stickyNote, stopAndError

{"nodes": [{"id": "678e86bc-2755-4c79-97d6-fa4da1ed9ff9", "name": "Postgres Trigger", "type": "n8n-nodes-base.postgresTrigger", "disabled": true, "position": [500, 480], "parameters": {"schema": {"__rl": true, "mode": "list", "value": "computed", "cachedResultName": "computed"}, "firesOn": "UPDATE", "tableName": {"__rl": true, "mode": "list", "value": "users", "cachedResultName": "users"}, "additionalFields": {}}, "credentials": {"postgres": {"id": "{{ $credentials.postgres.id }}", "name": "Postgres Product Analytics"}}, "typeVersion": 1, "notes": "This postgresTrigger node performs automated tasks as part of the workflow."}, {"id": "accecdfc-283c-4119-9b23-4cf44bc5e68c", "name": "Filter", "type": "n8n-nodes-base.filter", "notes": "Filter out @n8n.io emails", "position": [980, 540], "parameters": {"conditions": {"string": [{"value1": "={{ $json.email }}", "value2": "n8n.io", "operation": "notContains"}]}}, "notesInFlow": true, "typeVersion": 1}, {"id": "d16d7ae7-0c60-48f0-97fe-c7618cab73d3", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [0, 380], "parameters": {"width": 424, "height": 559, "content": "## \ud83d\udc4b How to use this template\nThis template shows how to sync data from one service to another. In this example we're saving a new qualified lead to a Google Sheets file. Here's how you can test the template:\n\n1. Duplicate our [Google Sheets]({{ $env.WEBHOOK_URL }} file\n2. Double click the `Google Sheets` node and create a credential by signing in.\n3. Select the correct Google Sheets document and sheet.\n4. Click the `Execute Workflow` button and double click the nodes to see the input and output data\n\n### To customize it to you needs, just do the following:\n1. Enable or exchange the `Postgres trigger` with any service that fits your use case.\n2. Change the `Filter` to fit your needs\n3. Adjust the Google Sheets node as described above\n4. Disable or remove the `On clicking \"Execute Node\"` and `Code` node\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "8bc7439e-d814-4960-8b75-fc77805f74c7", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [460, 380], "parameters": {"width": 344, "height": 562, "content": "### 1. Trigger step listens for new events\n\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "63b2bc4c-8e33-4432-af4b-4595b2012ce1", "name": "Sticky Note6", "type": "n8n-nodes-base.stickyNote", "position": [840, 460], "parameters": {"width": 462, "height": 407, "content": "### 2. Filter and transform your data\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nIn this case, we only want to save qualified users that don't have `@n8n.io` in their email address.\n\nTo edit the filter, simply drag and drop input data into the fields or change the values directly. **Besides filters, n8n has other powerful transformation nodes like [Set]({{ $env.WEBHOOK_URL }} [ItemList]({{ $env.WEBHOOK_URL }} [Code]({{ $env.WEBHOOK_URL }} and many more.**"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "448e2c49-aa75-405b-ba51-3acbce0fb758", "name": "Sticky Note2", "type": "n8n-nodes-base.stickyNote", "position": [1340, 460], "parameters": {"width": 342.52886836027733, "height": 407.43618112665195, "content": "### 3. Save the user in a Google Sheet\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nFor simplicity, we're saving our qualified user in a Google Sheet.\n\n**You can replace this node with any service like [Excel]({{ $env.WEBHOOK_URL }} [HubSpot]({{ $env.WEBHOOK_URL }} [Pipedrive]({{ $env.WEBHOOK_URL }} [Zendesk]({{ $env.WEBHOOK_URL }} etc.**"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "c0ee182d-4c31-488b-a547-5f2d2ba8786e", "name": "On clicking \"Execute Node\"", "type": "n8n-nodes-base.manualTrigger", "notes": "For testing the workflow", "position": [500, 680], "parameters": {}, "notesInFlow": true, "typeVersion": 1}, {"id": "87f2a11e-f704-4c9e-ac8b-ee1f057cd347", "name": "Code", "type": "n8n-nodes-base.code", "notes": "Mock Data", "position": [680, 680], "parameters": {"jsCode": "return [\n  {\n    \"id\": 1,\n    \"username\": \"max_mustermann\",\n    \"email\": \"max_mustermann@acme.com\",\n    \"company_size\": \"500-999\",\n    \"role\": \"Sales\",\n    \"users\": 50\n  }\n]"}, "notesInFlow": true, "typeVersion": 1}, {"id": "0992077f-b6d3-47d2-94d2-c612dfbf5062", "name": "Google Sheets", "type": "n8n-nodes-base.googleSheets", "notes": "Add to \"Users to contact\"", "position": [1400, 540], "parameters": {"columns": {"value": {"id": "={{ $json.id }}", "email": "={{ $json.email }}", "username": "={{ $json.username }}"}, "schema": [{"id": "id", "type": "string", "display": true, "removed": false, "required": false, "displayName": "id", "defaultMatch": true, "canBeUsedToMatch": true}, {"id": "username", "type": "string", "display": true, "removed": false, "required": false, "displayName": "username", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "email", "type": "string", "display": true, "removed": false, "required": false, "displayName": "email", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "contacted", "type": "string", "display": true, "removed": true, "required": false, "displayName": "contacted", "defaultMatch": false, "canBeUsedToMatch": true}], "mappingMode": "defineBelow", "matchingColumns": ["id"]}, "options": {"cellFormat": "USER_ENTERED"}, "operation": "appendOrUpdate", "sheetName": {"__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Sheet1"}, "documentId": {"__rl": true, "mode": "list", "value": "1gVfyernVtgYXD-oPboxOSJYQ-HEfAguEryZ7gTtK0V8", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Qualified leads to contact"}}, "credentials": {"googleSheetsOAuth2Api": {"id": "{{ $credentials.googleSheetsOAuth2Api.id }}", "name": "Google Sheets account"}}, "notesInFlow": true, "typeVersion": 4}, {"id": "error-2cc4d065", "name": "Error Handler", "type": "n8n-nodes-base.stopAndError", "typeVersion": 1, "position": [1000, 400], "parameters": {"message": "Workflow execution error", "options": {}}}], "connections": {"0992077f-b6d3-47d2-94d2-c612dfbf5062": {"main": [[{"node": "error-handler-0992077f-b6d3-47d2-94d2-c612dfbf5062-ff65bd19", "type": "main", "index": 0}]]}}, "name": "Postgrestrigger 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: Postgrestrigger Workflow. This workflow integrates 7 different services: filter, stickyNote, code, stopAndError, postgresTrigger. It contains 10 nodes and follows best practices for error handling and security.", "meta": {"instanceId": "workflow-cb4d239c", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:42.355078", "updatedAt": "2025-09-29T07:07:42.355149", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "notes": "Excellent quality workflow: Postgrestrigger Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}