Google Sheets duplication & enrichment automation
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers 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. It also calls sheets.googleapis.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Create New Spreadsheet (Google Sheets): work with spreadsheet
- HTTP Request: calls sheets.googleapis.com
- Code: runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Google Sheets: remove
- Create Sheets (Google Sheets): create
- Read Spreadsheet (Google Sheets): uses Google Sheets
- Write sheet (Google Sheets): append or update
Services it uses
HTTP calls to: sheets.googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets
From the author
How it Works This workflow reads sheet details from a source Google Spreadsheet, creates a new spreadsheet, replicates the sheet structure, enriches the content by reading data, and writes it into the corresponding sheets in the new spreadsheet. The process…