Create multi-sheet Excel workbooks by merging datasets with Google Drive & Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 8 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Google Drive.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Export Excel file (Google Drive): download
- Data Set (Code): runs custom JavaScript code
- Data Set (Code): runs custom JavaScript code
- Convert to File: converts data to a file (xlsx)
- Convert to File: converts data to a file (xlsx)
- Merge: merges the data from its input branches
- Save to google sheets (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Convert to File
n8n-nodes-base.convertToFile - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Google Drive
n8n-nodes-base.googleDrive
From the author
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…