Synchronize Google Sheets with PostgreSQL

Name: Synchronize Google Sheets with PostgreSQL
Rating: 5 (5 reviews)
Author: Free N8N

Advanced

29 nodes connected

detail.loadingPreview

Free N8N Temples

106 views

0 downloads

Data Syncautomationdatabasegoogle sheetspostgresqlsync

Automate the synchronization of data between Google Sheets and a PostgreSQL database.

About This Workflow

This workflow synchronizes data from a Google Sheet to a PostgreSQL database. It retrieves data from Google Sheets, compares it with existing data in PostgreSQL, and then inserts new records or updates existing ones based on the comparison.

Key Features

Scheduled execution (hourly).
Connects to Google Sheets and PostgreSQL.
Compares datasets based on specified fields (e.g., first_name).
Supports inserting new records.
Supports updating existing records.
Splits out relevant fields for processing.

How To Use

Setup Instructions:

Credentials: Ensure your Google Sheets and PostgreSQL credentials are set up in n8n.
Google Sheets Node: Configure the Retrieve Sheets Data node with your specific documentId and sheetName (or gid).
PostgreSQL Nodes: Configure the Select Rows in Postgres, Insert Rows, and Update Rows nodes with your PostgreSQL connection details, table (testing), and schema (public).
Field Mapping: In the Split Out Relevant Fields node, ensure the fieldToSplitOut parameter lists all the columns you wish to synchronize (e.g., first_name, last_name, town, age).
Comparison Logic: In the Compare Datasets node, define the mergeByFields to specify how records should be matched between the Google Sheet data and PostgreSQL data. The example uses first_name.
Insert/Update Logic: The Insert Rows and Update Rows nodes handle the database operations. The Update Rows node specifically uses first_name and last_name as matching keys for updates, and the columns parameter maps data from the input to the database fields.
Scheduling: The Schedule Trigger is set to run hourly. Adjust this interval as needed.

Node Descriptions:

Schedule Trigger: Initiates the workflow on a defined schedule.
Retrieve Sheets Data: Fetches data from a specified Google Sheet.
Split Out Relevant Fields: Extracts specific fields from the incoming data.
Select Rows in Postgres: Retrieves existing data from the PostgreSQL table to be used for comparison.
Compare Datasets: Compares data from Google Sheets with data from PostgreSQL.
Insert Rows: Inserts new records into the PostgreSQL table if they are not found during comparison.
Update Rows: Updates existing records in the PostgreSQL table if changes are detected during comparison.

Apps Used

automation

database

google sheets

postgresql

sync

Workflow JSON

{
  "id": "5552a274-4fe7-48aa-b59d-b88f2cb3ec41",
  "name": "Synchronize Google Sheets with PostgreSQL",
  "nodes": 29,
  "category": "Data Sync",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.

Get This Workflow

ID: 5552a274-4fe7...

About the Author

Free n8n Workflows Official

System Admin

The official repository for verified enterprise-grade workflows.

Statistics

Downloads0

Rating5/5

Get Custom Workflow

Need a specific automation? Our experts can build it for you.

Trusted by top companies
7+ years experience

Related Workflows

Discover more workflows you might like

Intermediate

Operationscsv-to-jsondata-transformationwebhook-api

Universal CSV to JSON API Converter

Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.

19 nodes

294

View Workflow

Beginner

SalesAIWeb ScrapingLead Generation

Automate Local Business Outreach with AI-Powered Yelp Scraper

This workflow automates the process of scraping local business details from Yelp using AI, then leverages that data to send personalized partnership proposals via Gmail. It's perfect for sales and marketing teams looking to streamline lead generation and outreach campaigns.

7 nodes

165

View Workflow

Intermediate

OperationsGetty ImagesCMSContent Automation

Automate Getty Images Editorial Search & CMS Integration

This n8n workflow automates searching for editorial images on Getty Images, extracts key details and embed codes, and prepares them for seamless integration into your Content Management System (CMS), streamlining your content creation process.

19 nodes

423

View Workflow

Synchronize Google Sheets with PostgreSQL

Advanced

29 nodes connected

detail.loadingPreview

Free N8N Temples

106 views

0 downloads

Data Syncautomationdatabasegoogle sheetspostgresqlsync

Automate the synchronization of data between Google Sheets and a PostgreSQL database.

About This Workflow

Key Features

Scheduled execution (hourly).
Connects to Google Sheets and PostgreSQL.
Compares datasets based on specified fields (e.g., first_name).
Supports inserting new records.
Supports updating existing records.
Splits out relevant fields for processing.

How To Use

Setup Instructions:

Credentials: Ensure your Google Sheets and PostgreSQL credentials are set up in n8n.
Google Sheets Node: Configure the Retrieve Sheets Data node with your specific documentId and sheetName (or gid).
PostgreSQL Nodes: Configure the Select Rows in Postgres, Insert Rows, and Update Rows nodes with your PostgreSQL connection details, table (testing), and schema (public).
Field Mapping: In the Split Out Relevant Fields node, ensure the fieldToSplitOut parameter lists all the columns you wish to synchronize (e.g., first_name, last_name, town, age).
Comparison Logic: In the Compare Datasets node, define the mergeByFields to specify how records should be matched between the Google Sheet data and PostgreSQL data. The example uses first_name.
Insert/Update Logic: The Insert Rows and Update Rows nodes handle the database operations. The Update Rows node specifically uses first_name and last_name as matching keys for updates, and the columns parameter maps data from the input to the database fields.
Scheduling: The Schedule Trigger is set to run hourly. Adjust this interval as needed.

Node Descriptions:

Schedule Trigger: Initiates the workflow on a defined schedule.
Retrieve Sheets Data: Fetches data from a specified Google Sheet.
Split Out Relevant Fields: Extracts specific fields from the incoming data.
Select Rows in Postgres: Retrieves existing data from the PostgreSQL table to be used for comparison.
Compare Datasets: Compares data from Google Sheets with data from PostgreSQL.
Insert Rows: Inserts new records into the PostgreSQL table if they are not found during comparison.
Update Rows: Updates existing records in the PostgreSQL table if changes are detected during comparison.

Apps Used

automation

database

google sheets

postgresql

sync

Workflow JSON

{
  "id": "5552a274-4fe7-48aa-b59d-b88f2cb3ec41",
  "name": "Synchronize Google Sheets with PostgreSQL",
  "nodes": 29,
  "category": "Data Sync",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.