Save Files to Google Drive with Automated Logging
Workflow Description
An automation that receives save requests via webhook, retrieves data from Google Sheets, processes it, stores files in Google Drive, and maintains a comprehensive log file documenting all operations.
How it works
- 1.Receive file save request through webhook with file data and title
- 2.Fetch required data from Google Sheets spreadsheets
- 3.Process data and generate final file content
- 4.Save file to Google Drive with specified name and location
- 5.Record operation details (date, status, filename) in the log file
Use cases
- Automatically archive processed data in a central location with complete operation tracking
- Create regular backups of spreadsheets with detailed backup operation records
- Handle multiple save requests from external applications with automatic logging
Requirements
- Google account with write permissions on Google Drive
- Google Sheets spreadsheet containing data to be processed
- Webhook configuration to receive requests from external applications
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (27)
Get Config
Google Sheets
Create Date Folder
Google Drive
Set Date Folder ID
Code
Create File Type Folder
Google Drive
Upload File to Google Drive
Google Drive
Determine Folder Info
Code
Search Date Folder
Google Drive
Merge Event and Config Data
Merge
Check Existing Date Folder
If
Check Existing File Type Folder
If
Merge Final Parent Folder Data
Merge
Search File Type Folder
Google Drive
Set File Type Folder ID
Code
Configure Final Parent Folder ID
Code
Process Event and Config Data
Code
Get File Binary Content
HTTP Request
Log File Details to Google Sheet
Google Sheets
Check Reply Enabled Flag
If
Check if Store by Date is Enabled
If
Check if Store by File Type is Enabled
If
LINE Webhook Listener
Webhook
Send LINE Reply Message
HTTP Request
Validate File Type
Code
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note3
Sticky Note
Sticky Note2
Sticky Note