Google Sheets duplication & enrichment automation

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 is looped for every sheet, providing an automated way to duplicate and transform structured data.

🎯 Use Case

- Automate duplication and data enrichment for multi-sheet Google Spreadsheets - Replicate templates across new documents with consistent formatting - Data team workflows requiring repetitive structured Google Sheets setup

Setup Instructions

1. Required Google Sheets - You must have a source spreadsheet with multiple sheets. - The destination spreadsheet will be created automatically. 2. API Credentials - Google Sheets OAuth2 – connect to both read and write spreadsheets. - HTTP Request Auth – if external API headers are needed. 3. Configure Fields in Write Sheet - Ensure you define appropriate columns and mapping for the destination sheet.

🔁 Workflow Logic

1. Manual Trigger: Starts the flow on user demand. 2. Create New Spreadsheet: Generates a blank spreadsheet. 3. HTTP Request: Retrieves all sheet names from the source spreadsheet. 4. JavaScript Code: Extracts titles and metadata from the HTTP response. 5. Loop Over Sheets: Iterates through each sheet retrieved. 6. Delete Default Sheet: Removes the placeholder 'Sheet1'. 7. Create Sheets: Replicates each original sheet in the new document. 8. Read Spreadsheet1: Pulls data from the matching original sheet. 9. Write Sheet: Appends the data to the newly created sheets.