Developer & DevOps
Connect Google Sheets with n8n
12 nodes
226
122
Automatic trigger
Workflow Description
A template connecting Google Sheets with n8n for automated data processing. Enables manual workflow triggers, batch data splitting, filtering, and custom processing operations directly from spreadsheets with efficient record handling.
How it works
- 1.Initiate workflow manually when needed
- 2.Extract data from the specified Google Sheets spreadsheet
- 3.Split records into manageable batches for processing
- 4.Filter data according to defined criteria
- 5.Execute required operations on each batch
- 6.Route results through the workflow pipeline
Use cases
- Process large datasets from spreadsheets incrementally
- Clean and filter records before sending to external applications
- Automate repetitive data management tasks within sheets
- Synchronize Google Sheets data with internal systems
Requirements
- Active Google Workspace or Google Drive account
- n8n authenticated access to Google Sheets
- Basic understanding of spreadsheet data structure
- Identification of columns and rows to process
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Split In Batches
Google Sheets
N8N
Details
Trigger
Automatic trigger
Nodes
12
Apps
3
Views
226
Downloads
122
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 (12)
/
When clicking ‘Test workflow’
Manual Trigger
Loop Over Items
Split In Batches
Edit Fields-set_model_data
Set
Google Sheets-Clear Sheet Data
Google Sheets
n8n-get all workflow
N8N
Filter-get workflow contain modelid
Filter
Split Out-nodes
Split Out
Filter-node contain modelId
Filter
Google Sheets-Save node and workflow data
Google Sheets
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note4
Sticky Note