Automated Duplication of Google Sheets Data

This n8n workflow automates the process of duplicating sheets from a master Google Spreadsheet into a newly created destination spreadsheet. The process starts with a manual trigger, enabling users to initiate the duplication on demand. It uses Google Sheets API to fetch metadata and sheet data, then creates a new spreadsheet and replicates each sheet along with its data.

The workflow’s key steps include: 1. User manually triggers the workflow. 2. It creates a new empty spreadsheet. 3. Retrieves all sheet names and IDs from the master spreadsheet via an API call. 4. Loops through each sheet, creating a duplicate in the new spreadsheet, followed by copying the data from the original sheet into the new. 5. Removes the default ‘Sheet1’ from the newly created spreadsheet to leave only the duplicated sheets.

This setup is ideal for scenarios requiring regular backups, data migration, or creating templates from existing spreadsheets without manual copy-pasting. It ensures data consistency across sheets in different documents and reduces manual effort.

Use cases include large data replication tasks, automated report generation, or setting up standardized templates for team collaboration.