Workflow: Synchronize your Google Sheets with Postgres
Integrations: compareDatasets, googleSheets, postgres, scheduleTrigger, splitOut, stickyNote, stopAndError

{"id": "wDD4XugmHIvx3KMT", "meta": {"instanceId": "workflow-5620e689", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:54.744051", "updatedAt": "2025-09-29T07:07:54.744072", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "name": "Synchronize your Google Sheets with Postgres", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "nodes": [{"id": "44171bad-84b6-49f8-b538-fb0c2d52db43", "name": "Schedule Trigger", "type": "n8n-nodes-base.scheduleTrigger", "position": [900, 360], "parameters": {"rule": {"interval": [{"field": "hours"}]}}, "typeVersion": 1.1, "notes": "This scheduleTrigger node performs automated tasks as part of the workflow."}, {"id": "1d1558cc-523b-4985-81e2-da49e3d0f4b7", "name": "Compare Datasets", "type": "n8n-nodes-base.compareDatasets", "position": [1820, 380], "parameters": {"options": {}, "resolve": "preferInput1", "mergeByFields": {"values": [{"field1": "first_name", "field2": "first_name"}]}}, "typeVersion": 2.3, "notes": "This compareDatasets node performs automated tasks as part of the workflow."}, {"id": "b4442fd7-6817-40bb-a76e-851659c836ec", "name": "Split Out Relevant Fields", "type": "n8n-nodes-base.splitOut", "position": [1460, 240], "parameters": {"options": {}, "fieldToSplitOut": "first_name, last_name, town, age"}, "typeVersion": 1, "notes": "This splitOut node performs automated tasks as part of the workflow."}, {"id": "b63899bd-f842-4ead-a590-9bdacdc9b3c0", "name": "Retrieve Sheets Data", "type": "n8n-nodes-base.googleSheets", "position": [1200, 240], "parameters": {"options": {}, "sheetName": {"__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Sheet1"}, "documentId": {"__rl": true, "mode": "list", "value": "1jhUobbdaEuX093J745TsPFMPFbzAIIgx6HnIzdqYqhg", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Testing_Sheet"}}, "typeVersion": 4.2, "notes": "This googleSheets node performs automated tasks as part of the workflow."}, {"id": "ae4918fb-07ef-48db-ba25-ea34c5af43af", "name": "Select Rows in Postgres", "type": "n8n-nodes-base.postgres", "position": [1200, 540], "parameters": {"table": {"__rl": true, "mode": "list", "value": "testing", "cachedResultName": "testing"}, "schema": {"__rl": true, "mode": "list", "value": "public"}, "options": {}, "operation": "select", "returnAll": true}, "typeVersion": 2.3, "notes": "This postgres node performs automated tasks as part of the workflow."}, {"id": "4d08d771-0e80-445e-92db-08197418512d", "name": "Insert Rows", "type": "n8n-nodes-base.postgres", "position": [2300, 260], "parameters": {"table": {"__rl": true, "mode": "list", "value": "testing", "cachedResultName": "testing"}, "schema": {"__rl": true, "mode": "list", "value": "public"}, "columns": {"value": {}, "schema": [{"id": "first_name", "type": "string", "display": true, "required": false, "displayName": "first_name", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "last_name", "type": "string", "display": true, "required": false, "displayName": "last_name", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "town", "type": "string", "display": true, "required": false, "displayName": "town", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "age", "type": "number", "display": true, "required": false, "displayName": "age", "defaultMatch": false, "canBeUsedToMatch": true}], "mappingMode": "autoMapInputData", "matchingColumns": []}, "options": {}}, "typeVersion": 2.3, "notes": "This postgres node performs automated tasks as part of the workflow."}, {"id": "3fd7baa1-72c7-4587-a557-02eb4dfa92f5", "name": "Update Rows", "type": "n8n-nodes-base.postgres", "position": [2300, 460], "parameters": {"table": {"__rl": true, "mode": "list", "value": "testing", "cachedResultName": "testing"}, "schema": {"__rl": true, "mode": "list", "value": "public"}, "columns": {"value": {"age": "={{ $json.age }}", "town": "={{ $json.town }}", "last_name": "={{ $json.last_name }}", "first_name": "={{ $json.first_name }}"}, "schema": [{"id": "first_name", "type": "string", "display": true, "removed": false, "required": false, "displayName": "first_name", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "last_name", "type": "string", "display": true, "removed": false, "required": false, "displayName": "last_name", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "town", "type": "string", "display": true, "required": false, "displayName": "town", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "age", "type": "number", "display": true, "required": false, "displayName": "age", "defaultMatch": false, "canBeUsedToMatch": true}], "mappingMode": "defineBelow", "matchingColumns": ["first_name", "last_name"]}, "options": {}, "operation": "update"}, "typeVersion": 2.3, "notes": "This postgres node performs automated tasks as part of the workflow."}, {"id": "fc8dbe79-a54d-46fb-8ef7-4bb8b2a402ee", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [360, 260], "parameters": {"width": 485.5994596522446, "height": 350.08576009540855, "content": "## Setup ##\nIn order to make this automation work for you, you need to make a few adjustments:\n\n1. Add your Postgres & Google Sheets Credentials to the respective Nodes\n\n2. Select the Sheet (Google Sheets) and the table (Postgres) you want to sync\n\n3. Update the Insert & Update Queries so that the data is updated in the table you also selected the rows from in the first step"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "3719112b-1ec7-4402-a366-b1b845819e8d", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [2080, 160], "parameters": {"width": 485.5994596522446, "height": 486.693620858174, "content": "## Updating Your Database \nUsing Insert Rows & Update Rows as Separate Postgres Node's"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "7742972b-7996-4f9a-9c1d-700737b94eec", "name": "Sticky Note2", "type": "n8n-nodes-base.stickyNote", "position": [1080, 140], "parameters": {"width": 543.3950930518761, "height": 553.2461684092643, "content": "## Retrieving Data & Spitting Out Fields \nGet the Data you want to compare and split out the relevant fields"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "error-65318e66", "name": "Error Handler", "type": "n8n-nodes-base.stopAndError", "typeVersion": 1, "position": [1000, 400], "parameters": {"message": "Workflow execution error", "options": {}}}], "active": false, "pinData": {}, "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "versionId": "ac0f0ed3-3f25-4672-a34a-29b5f4402e63", "connections": {"b63899bd-f842-4ead-a590-9bdacdc9b3c0": {"main": [[{"node": "error-handler-b63899bd-f842-4ead-a590-9bdacdc9b3c0-28e0e1d9", "type": "main", "index": 0}]]}}, "description": "Automated workflow: Synchronize your Google Sheets with Postgres. This workflow integrates 7 different services: stickyNote, scheduleTrigger, splitOut, stopAndError, googleSheets. It contains 11 nodes and follows best practices for error handling and security.", "notes": "Excellent quality workflow: Synchronize your Google Sheets with Postgres. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}