Automates duplicating multi-sheet Google Spreadsheets by creating new documents, replicating sheet structures, and enriching data across sheets via looping.
This workflow streamlines the duplication and enrichment of complex multi-sheet Google Spreadsheets. It begins with a manual trigger, creates a new blank spreadsheet, fetches all sheet names from the source via HTTP request, and uses JavaScript to parse the metadata. It then loops over each sheet: deleting the default 'Sheet1', creating matching sheets in the new document, reading data from the source, and writing it to the destination with potential enrichment.
Key benefits include time saving
Platform
n8n
Category
Healthcare
Price
$22.99
Creator
Fred Garcia
google-sheets
automation
duplication
enrichment
spreadsheets
looping
productivity
healthcare
appointment-scheduling
data-migration
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.