Sync Google Sheets data to Notion database automatically
Workflow Description
Automation that transfers data from Google Sheets to Notion database instantly, processing records in batches and comparing changes to ensure real-time synchronization between both platforms without manual intervention.
How it works
- 1.Trigger workflow manually or on a scheduled interval
- 2.Extract data from specified Google Sheets worksheets
- 3.Process records in separate batches using Split In Batches node
- 4.Compare new data against existing records to detect changes
- 5.Insert or update corresponding records in Notion database
Use cases
- Automatically update sales pipelines and client lists in Notion from a centralized Google Sheets master spreadsheet
- Keep project trackers and task lists synchronized across marketing and development teams without manual data entry
Requirements
- Authorized Google account connection with read/write access to target spreadsheets
- Authorized Notion workspace connection with database modification permissions
- Clear identification of source sheet, target Notion database, and mapping between columns
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (26)
When clicking ‘Test workflow’
Manual Trigger
Gong
Gong
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Transcript Processor
Execute Workflow
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Execute Workflow Trigger
Execute Workflow Trigger
Call Aggregator
Aggregate
Integration Aggregator
Aggregate
Get Integrations
Google Sheets
Comma Separate Integrations
Set
Comma separate competitors
Set
Get list of Competitors
Notion
Merge 3 objects into one
Merge
Aggregate Call Data
Aggregate
Split Out Call Data and Competitors
Split Out
Reduce down to 1 object
Aggregate
Get Previous Phone Calls
Notion
Isolate Only Call IDs
Set
Only Process New Calls
Set
Loop Over Calls
Split In Batches
Process All Call Transcripts
Execute Workflow
Receive all Transcripts
No Op