Create Multi-Sheet Excel Workbooks by Merging Datasets with Google Drive & Sheets

This n8n workflow enables the automated generation of multi-sheet Excel workbooks (.xlsx) directly from JSON datasets. Starting with a Manual Trigger, two Code nodes produce sample datasets (e.g., People and Locations tables). Each dataset is processed by a Convert to File node to create individual Excel worksheets (Sheet1, Sheet2, etc.), then merged into a single multi-tab workbook using the Merge node. Optionally, data can be appended to a Google Sheet for collaboration, and the file saved to Google Drive.

Ideal for teams in healthcare billing and insurance that generate recurring reports with multiple tabs, such as patient summaries, claims data, and provider lists. It eliminates manual copy-pasting from JSON sources into Excel, saving hours on reporting tasks. Ops, marketing, and data teams benefit from this no-code/low-code pattern to package API or database outputs into professional Excel files.

Setup requires only Google Sheets and Google Drive OAuth2 credentials. Duplicate the example sheet provided, select your spreadsheet/worksheet, and connect Drive for file uploads. Perfect for n8n beginners learning the Code → Convert to File → Merge workflow pattern, with high reusability across industries for any multi-dataset reporting needs.