Synchronize your Google Sheets with Postgres
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 7 nodes and runs on a schedule (every hour). Along the way it connects Google Sheets and Postgres.
How it runs
Trigger: On a schedule (every hour).
- Retrieve Sheets Data (Google Sheets): uses Google Sheets
- Select Rows in Postgres (Postgres): select
- Split Out: splits a list into separate items
- Compare Datasets: uses Compare Datasets
- Insert Rows (Postgres): uses Postgres
- Update Rows (Postgres): update
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Compare Datasets
n8n-nodes-base.compareDatasets - Split Out
n8n-nodes-base.splitOut - Google Sheets
n8n-nodes-base.googleSheets - Postgres
n8n-nodes-base.postgres
From the author
Sync your Google Sheets Data with your Postgres database table, requiring minimal adjustments. Follow these steps: 1. Retrieve Data: Pull data from Google Sheets and PostgreSQL. 2. Compare Datasets: Identify differences, focusing on new or updated entries. 3.…