Google Sheets Duplication & Enrichment Automation

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 savings for repetitive data setup, consistent formatting across new documents, and scalability for data teams handling structured spreadsheets. It's ideal for healthcare scenarios like appointment scheduling, where duplicating patient logs, calendars, or reports with updated data is frequent, ensuring compliance and accuracy without manual copying.

Use cases span productivity tasks: replicating templates for project tracking, migrating data between environments, or preparing enriched reports for analysis. Setup requires Google Sheets OAuth2 credentials; customize column mappings in the write nodes for specific transformations. This high-complexity automation handles 9+ nodes with loops and API integrations, delivering robust automation for business workflows.