Create ready to publish quote videos without editing. The system picks a quote, pairs it with a stock video and background music, then uploads the final clip to YouTube. It suits marketing teams and creators who post simple daily content.

A manual start collects quotes and usage status from Google Sheets and lists media files from Google Drive. A merge and code step chooses one video, one track, and one quote at random while avoiding repeats. Files download to local storage, overlay text is prepared, and FFmpeg renders the final clip. After rendering, a resumable upload starts and the YouTube node publishes the video. Google Sheets then gets updated with the video link and marks the assets as used.

You need Google accounts with Drive and Sheets access, a YouTube channel with upload permission, and FFmpeg available on the n8n host. Expect production time to drop from hours to minutes for each video, which makes daily posting realistic. Ideal for motivational channels, brand quotes, and simple thought leadership clips that do not need heavy editing.

• Manual start to control when new videos are produced
• Reads quotes and usage status from Google Sheets
• Lists and downloads video and music files from Google Drive
• Random selection logic picks one unique quote, video, and track
• Saves media locally to speed up rendering
• Builds overlay text with the quote and author
• Renders the final clip using FFmpeg via Execute Command
• Uses a resumable upload then publishes with the YouTube node
• Writes back the YouTube link and marks assets as used in Google Sheets

• Reduce manual work from 2 hours to 5 minutes per video
• Automate 90% of repetitive editing steps
• Prevent duplicates by tracking used quotes and backgrounds
• Handle large asset libraries without changing the flow
• Connect Google Sheets, Google Drive and YouTube in one run

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, Google Drive and YouTube. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, connect Google Sheets: double click any Google Sheets node, open the 'Credential to connect with' dropdown, click 'Create new credential', choose Google Sheets OAuth2, and follow the on screen steps. Name the credential clearly, for example 'GSheets Marketing'.
4. Connect Google Drive: double click a Google Drive node, create a new Google Drive OAuth2 credential, and complete the on screen authorization. Use a clear name such as 'GDrive Media'. Ensure the account has access to the folders with your videos and music.
5. Connect YouTube: double click the YouTube node, create a new YouTube OAuth2 credential, and authorize upload permissions. Confirm the correct channel is selected under the authorized account.
6. Set Google Drive folder IDs: open the video and music listing nodes. Paste the correct folder IDs into the folder fields. Make sure these folders contain the assets you want to use and that the authorized account can view them.
7. Map Google Sheets: open the Google Sheets nodes and confirm the Document ID and Sheet names match your spreadsheet. Prepare sheets for quotes and for background asset logs. Include columns for status and links as shown in the node fields.
8. Install FFmpeg on the machine running n8n. Confirm the execute command node points to the correct FFmpeg path and that input and output file names match the read file node settings.
9. Adjust overlay text formatting in the 'Prepare Overlay Text' code step if you want a different style or line breaks.
10. Run a test: click Execute Workflow. Check that media files are downloaded, a clip is rendered, the video uploads to YouTube, and the Google Sheet updates with the link and used flags.
11. If Google Drive download fails, verify file permissions or switch to using file IDs instead of view links. Ensure the authorized drive account can access the files.
12. If YouTube upload fails, review OAuth scopes, channel selection, and quota. Confirm the output file path in the read file node matches the FFmpeg output path.