Files & Documents
Import multiple CSV files into Google Sheets
9 nodes
272
112
Automatic trigger
Workflow Description
Automate bulk CSV file imports into Google Sheets by reading binary files, processing them in batches, transforming spreadsheet data, and uploading rows directly to your cloud sheet without manual effort or delays.
How it works
- 1.Trigger manually and read uploaded binary CSV files
- 2.Split files into safe processing batches
- 3.Transform and filter spreadsheet data based on requirements
- 4.Upload processed rows automatically to your Google Sheets tab
Use cases
- Transfer user or product lists from multiple CSV reports
- Consolidate sales data from different systems into one unified sheet
Requirements
- Google account with Google Sheets access permissions
- CSV files with clear header rows and consistent formatting
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Read Binary Files
Split In Batches
Spreadsheet File
Google Sheets
Details
Trigger
Automatic trigger
Nodes
9
Apps
4
Views
272
Downloads
112
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 (9)
When clicking "Execute Workflow"
Manual Trigger
Read Binary Files
Read Binary Files
Split In Batches
Split In Batches
Read CSV
Spreadsheet File
Remove duplicates
Item Lists
Keep only subscribers
Filter
Sort by date
Item Lists
Upload to spreadsheet
Google Sheets
Assign source file name
Set