Developer & DevOps
Import CSV files into Google Sheets automatically
7 nodes
302
149
Automatic trigger
Workflow Description
Automate importing CSV files and converting them into formatted data in Google Sheets with filtering and organization capabilities triggered manually, streamlining data transfer workflows and ensuring consistency.
How it works
- 1.Manually trigger the automation to start the import process
- 2.Read and parse the CSV file contents
- 3.Filter data according to specified criteria
- 4.Insert formatted data into Google Sheets
Use cases
- Import contact lists from CSV into customer relationship management systems
- Transfer financial data from CSV reports to Google Sheets for analysis
- Update product or inventory lists automatically from CSV sources
- Consolidate data from multiple sources into a unified spreadsheet
Requirements
- Google Workspace account with permissions to create and modify sheets
- Valid CSV file in a recognized and readable format
- Google Sheets API access configured in n8n
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Google Sheets
Spreadsheet File
Details
Trigger
Automatic trigger
Nodes
7
Apps
2
Views
302
Downloads
149
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 (7)
When clicking "Execute Workflow"
Manual Trigger
Upload to spreadsheet
Google Sheets
Add unique field
Set
Import CSV
Spreadsheet File
Download CSV
HTTP Request
Keep only DACH in 2023
Filter
Sticky Note
Sticky Note