Data & Databases

Sync Google Sheets data to Notion database automatically

26 nodes 122 79 Automatic trigger
Download

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. 1.Trigger workflow manually or on a scheduled interval
  2. 2.Extract data from specified Google Sheets worksheets
  3. 3.Process records in separate batches using Split In Batches node
  4. 4.Compare new data against existing records to detect changes
  5. 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

Gong Twitter/X Google Sheets Notion Split In Batches

Details

Trigger Automatic trigger
Nodes 26
Apps 5
Views 122
Downloads 79

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (26)

/

When clicking ‘Test workflow’

Manual Trigger

#1

Gong

Gong

#2

Sticky Note

Sticky Note

#3

Sticky Note1

Sticky Note

#4

Transcript Processor

Execute Workflow

#5

Sticky Note2

Sticky Note

#6

Sticky Note3

Sticky Note

#7

Sticky Note4

Sticky Note

#8

Sticky Note5

Sticky Note

#9

Execute Workflow Trigger

Execute Workflow Trigger

#10

Call Aggregator

Aggregate

#11

Integration Aggregator

Aggregate

#12

Get Integrations

Google Sheets

#13

Comma Separate Integrations

Set

#14

Comma separate competitors

Set

#15

Get list of Competitors

Notion

#16

Merge 3 objects into one

Merge

#17

Aggregate Call Data

Aggregate

#18

Split Out Call Data and Competitors

Split Out

#19

Reduce down to 1 object

Aggregate

#20

Get Previous Phone Calls

Notion

#21

Isolate Only Call IDs

Set

#22

Only Process New Calls

Set

#23

Loop Over Calls

Split In Batches

#24

Process All Call Transcripts

Execute Workflow

#25

Receive all Transcripts

No Op

#26