Marketing
Automatic Video Curation with Command Line FFMPEG + Sheets
This workflow automates video creation for social media. It fetches quotes, selects video and music backgrounds from Google Drive and Sheets, overlays text using FFmpeg, and uploads the final video to YouTube, updating Google Sheets with the upload status.
Built · ~5 hours saved per week
Content creators and marketers
This workflow makes videos automatically. It takes quotes, background videos, and music, puts them together, and uploads them to YouTube. It also keeps track of what it creates in Google Sheets.
1. Set up Google Drive credentials to access video and music files. 2. Set up Google Sheets credentials to read quotes and update statuses. 3. Set up YouTube API credentials for uploading videos. 4. Make sure you have FFmpeg installed on your system where n8n runs.
Google Drive account, Google Sheets account, YouTube account, FFmpeg installed.
You can change the Google Sheet IDs, folder IDs for video and music backgrounds, fonts, font sizes, colors, and margins for the text overlay. You can also change the FFmpeg command for different video effects.
Key Technologies: n8n,Google Sheets,Google Drive,YouTube Data API,FFmpeg
Automation Value: Automates video creation, saving time and effort. Ensures consistent branding by using predefined assets. Manages content publication and tracking automatically. Reduces manual errors in video production and uploads.
Best Practices: Use descriptive variable names for clarity. Implement error handling for empty data sets in the "Select Random Video, Music & Quote" node. Store sensitive credentials securely using n8n credentials. Regularly check Google Sheet formats for consistency. Optimize FFmpeg commands for performance and video quality.
Tags: Image or Video, Content Management, Data Transformation, Content Creation, Google
Integrations: Google Sheets, Google Drive, Code, HTTP