Automate Google Sheets data synchronization with Google Drive folders
Workflow Description
This template connects your Google Sheets spreadsheets with Google Drive folders, automatically reading data from sheets and organizing files based on spreadsheet content. Perfect for automating file management, data export, and folder organization in the cloud without manual intervention.
How it works
- 1.Trigger automation manually or when spreadsheet updates
- 2.Read data from specified worksheets and columns
- 3.Process and structure data using code logic
- 4.Create or update files and folders in Google Drive
- 5.Log results and maintain automation history
Use cases
- Automatically create separate Google Drive folders for each spreadsheet row
- Export important data from sheets and save as files in the cloud
- Organize projects and documents based on categories in your spreadsheet
- Sync task lists between Google Sheets and project folder structures
Requirements
- Google Workspace account with full permissions on Sheets and Drive
- An existing spreadsheet containing data to be processed
- Basic understanding of data formats and desired folder structure
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 (28)
When clicking ‘Test workflow’
Manual Trigger
Generate Image
HTTP Request
Get image
HTTP Request
Sticky Note
Sticky Note
Update image background URL
Google Sheets
Image-to-Video
HTTP Request
Wait image 2 min
Wait
Wait video 5 min
Wait
Get Video
HTTP Request
Sticky Note1
Sticky Note
Generate Audio
HTTP Request
Get data from Google Sheet
Google Sheets
Update Sound background URL
Google Sheets
Update video background URL
Google Sheets
Sticky Note2
Sticky Note
Upload Sound to Google Drive
Google Drive
Save Video Background Locally1
Read Write File
Get Binary Video Background
HTTP Request
Save Music Background Locally1
Read Write File
Prepare Overlay Text (Quote & Author)1
Code
Generate Final Video Clip1
Execute Command
Initiate YouTube Resumable Upload
HTTP Request
Read output file
Read Write File
Upload Video to YouTube
HTTP Request
Update Quote Upload Status
Google Sheets
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note