Import multiple CSV to Google Sheets
Needs changesNeeds changes. This template uses 2 thing(s) that n8n 3.0 removes: Read Binary Files, Item Lists (legacy). 2 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Read Binary Files: uses Read Binary Files
- Split In Batches (Loop Over Items (Split in Batches)): loops over the items in batches
- Read CSV (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
- Remove duplicates (Item Lists): reshapes item lists (legacy Item Lists node)
- Assign source file name (Edit Fields (Set)): sets or maps fields
- Keep only subscribers (Filter): keeps only the items that match a condition
- Sort by date (Item Lists): reshapes item lists (legacy Item Lists node)
- Upload to spreadsheet (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Read Binary Files: replace with Read/Write Files from Disk.
- Item Lists (legacy) in Remove duplicates, Sort by date: replace with Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used).
- Also check Spreadsheet File: Convert to File / Extract from File.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Read Binary Files Read Binary Files | Read/Write Files from Disk |
| Item Lists (legacy) Remove duplicates, Sort by date | Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used) |
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Read Binary Files
n8n-nodes-base.readBinaryFiles - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Spreadsheet File
n8n-nodes-base.spreadsheetFile - Item Lists
n8n-nodes-base.itemLists - Filter
n8n-nodes-base.filter - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set
From the author
This workflow imports multiple CSV files and appends or updates them to a Google Sheets document. Here's a step-by-step breakdown: 1. When clicked "Execute Workflow", the process starts. 2. The "Read Binary Files" node reads all the '.csv' files from the…