Automate Google Sheets Duplication
detail.loadingPreview
Effortlessly duplicate entire Google Sheets, including all its sheets and data, to a new spreadsheet. This workflow streamlines the process of creating backups, templates, or distributing identical data sets.
About This Workflow
This n8n workflow automates the duplication of all sheets from a master Google Spreadsheet into a newly created destination spreadsheet. It begins by creating the new spreadsheet and then fetches metadata from your master sheet to identify all existing sheets. A loop processes each sheet individually, first creating a corresponding sheet in the new destination and then copying all data, preserving column structure. The process is triggered manually, offering flexibility and control. It's ideal for scenarios requiring regular data replication or for setting up standardized spreadsheets.
Key Features
- Full Sheet Duplication: Copies all sheets and their contents from a source to a new destination.
- Automated Spreadsheet Creation: Generates a new Google Spreadsheet to house the duplicated data.
- Preserves Data & Structure: Maintains column integrity and data throughout the copying process.
- Manual Trigger Control: Start the duplication process on demand, ensuring flexibility.
- Error Prevention: Processes sheets individually to avoid API overload and maintain order.
How To Use
- Set up Google Sheets Credentials: Authorize n8n to access your Google Sheets account.
- Configure the 'Start & Create' Node: (Optional) Customize the title of the new spreadsheet.
- Input Master Spreadsheet ID: In the 'HTTP Request' node, replace
YOUR_MASTER_SPREADSHEET_IDwith the actual ID of your source Google Sheet. - Update Credentials: Ensure the
GOOGLE_SHEETS_CREDENTIAL_IDis correctly set in the 'HTTP Request', 'Create Sheets', and 'Write sheet' nodes. - Review 'Important Notes': Pay attention to the notes regarding credential updates and column structure consistency.
- Run the Workflow: Click the 'Execute Workflow' button in n8n to start the duplication process.
Apps Used
Workflow JSON
{
"id": "e65eb845-2e5c-4d71-89e1-3e6258d174a4",
"name": "Automate Google Sheets Duplication",
"nodes": 20,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: e65eb845-2e5c...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.