Create multi-sheet Excel workbooks by merging datasets with Google Drive & Sheets

Create multi-sheet Excel workbooks in n8n to automate reporting using Google Drive + Google Sheets

Build an automated Excel file with multiple tabs directly in n8n. Two Code nodes generate datasets, each is converted into its own Excel worksheet, then combined into a single .xlsx and (optionally) appended to a Google Sheet for sharing—eliminating manual copy-paste and speeding up reporting.

Who’s it for - Teams that publish recurring reports as Excel with multiple tabs - Ops/Marketing/Data folks who want a no-code/low-code way to package JSON into Excel - n8n beginners learning the Code → Convert to File → Merge pattern

How it works 1. Manual Trigger starts the run. 2. Code nodes emit JSON rows for each table (e.g., People, Locations). 3. Convert to File nodes turn each JSON list into an Excel binary, assigning Sheet1/Sheet2 (or your names). 4. Merge combines both binaries into a single Excel workbook with multiple tabs. 5. Google Sheets (optional) appends the JSON rows to a live spreadsheet for collaboration.

Setup (only 2 connections)

1️⃣ Connect Google Sheets (OAuth2) 1. In n8n → Credentials → New → Google Sheets (OAuth2) 2. Sign in with your Google account and grant access 3. Copy the example sheet referenced in the Google Sheets node (open the node and duplicate the linked sheet), or select your own 4. In the workflow’s Google Sheets node, select your Spreadsheet and Worksheet

https://docs.google.com/spreadsheets/d/1G6FSm3VdMZt6VubM6g8j0mFw59iEw9npJE0upxj3Y6k/edit?gid=1978181834gid=1978181834

2️⃣ Connect Google Drive (OAuth2) 1. In n8n → Credentials → New → Google Drive (OAuth2) 2. Sign in with the Google account that will store your Excel outputs and allow access 3. In your Drive-related nodes (if used), point to the folder where you want the .xlsx saved or retrieved