This automation workflow instantly duplicates a master Google Sheet — including all tabs, names, and data — with a single manual trigger. Perfect for users who regularly replicate templates, archive files, or distribute personal copies without risking the original.
## Who it´s for
- Managers who need to quickly duplicate report templates in Google Sheets
- Administrators managing multiple copies of one sheet for different teams
- Analysts working with isolated data copies without risking the original
## What the automation does
- Triggered manually on demand
- Creates a new Google Spreadsheet via Google Sheets API
- Retrieves metadata from the master file (sheet names and order)
- Loops through each sheet to copy structure and data
- Removes the default ´Sheet1´ after completion
- Preserves exact layout and formatting of the original
## What´s included
- Ready-to-use n8n workflow
- Trigger and loop logic pre-configured
- Integrations with Google Sheets API v4 using OAuth 2.0
- Basic text guide for setup and adaptation
## Requirements for setup
- Google account with access to Google Sheets
- Configured OAuth 2.0 credentials for Google Sheets API
- Running n8n instance with internet access and HTTP request capabilities
## Benefits and outcomes
- Saves time on repetitive spreadsheet duplication
- Ensures consistency through templated structures
- Reduces human error in copying layouts
- Enables safe data handling without modifying the source
- Scales template distribution across teams
- Automates backup creation before major updates
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.
Google Spreadsheet duplicate
copy Google Sheets with data
duplicate spreadsheet automation
n8n Google Sheets workflow
Google Sheets API v4
OAuth 2 0 Google Sheets
manual trigger automation
copy all sheets in spreadsheet
preserve spreadsheet structure
create spreadsheet from template
automate Google Sheets copy
metadata retrieval Google Sheets
remove default Sheet1
isolated data copy Google Sheets
report template duplication
No feedback yet