Create videos automatically and upload them to YouTube
Workflow Description
A workflow that extracts video content data from Google Sheets, processes it to generate videos programmatically, and uploads them directly to your YouTube channel with full metadata. Completely automated from data to published video.
How it works
- 1.Retrieve video scripts, descriptions, and metadata from your prepared Google Sheets spreadsheet
- 2.Process and merge the data to structure it for video generation commands
- 3.Execute system commands to render video files with the specified content and parameters
- 4.Save generated videos to Google Drive for backup and review purposes
- 5.Upload the completed videos to YouTube with titles, descriptions, and tags from the sheet
Use cases
- Content creators producing bulk video content from templated scripts and data variations
- Marketing agencies scheduling regular YouTube uploads from a centralized data source
- Video producers generating multiple versions of the same concept automatically
Requirements
- Active Google account with full permissions on Sheets, Drive, and YouTube API access
- Well-structured Google Sheets spreadsheet containing video scripts, metadata, and parameters
- Local server or execution environment capable of running video rendering commands (ffmpeg or similar)
- YouTube channel authenticated and authorized to receive programmatic uploads
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 (23)
Start AutoClip Workflow
Manual Trigger
Retrieve Video Background Data
Google Sheets
Retrieve Quote Data
Google Sheets
List Video Background Files
Google Drive
Configure Music Background Folder ID
Set
List Music Background Files
Google Drive
Retrieve Music Background Data
Google Sheets
Merge File Selection Data
Merge
Select Random Video, Music & Quote
Code
Sticky Note
Sticky Note
Download Selected Video Background
Google Drive
Download Selected Music Background
Google Drive
Save Video Background Locally
Read Write File
Save Music Background Locally
Read Write File
Prepare Overlay Text (Quote & Author)
Code
Generate Final Video Clip
Execute Command
Sticky Note1
Sticky Note
Initiate YouTube Resumable Upload
HTTP Request
Read output file
Read Write File
Upload Video to YouTube
HTTP Request
Update Quote Upload Status
Google Sheets
Mark Background as Used
Google Sheets
Sticky Note2
Sticky Note