Automate Multi-Sheet Excel Workbook Creation with Google Drive and Sheets
Automatically generate Excel workbooks with multiple sheets by merging datasets using Google Drive and Google Sheets in n8n. This workflow streamlines reporting by eliminating manual data entry.
This workflow is designed for teams that need to create recurring reports in Excel with multiple tabs. It uses n8n to automate the process of generating datasets, converting them into Excel sheets, and merging them into a single workbook. The workflow can also append data to a Google Sheet for easy sharing and collaboration. Users can customize the workflow by replacing sample data, renaming sheet tabs, and adjusting Google Sheets mapping settings.
Platform
n8n
Category
Data & Analytics
Price
Free
Creator
Ravi Sharma
gid
code
merge
stickyNote
googleDrive
googleSheets
convertToFile
manualTrigger
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.