Daily Quote Video Automation: Google Sheets → Zvid (n8n)

Turn your Google Sheet into branded daily quote videos—automatically

This n8n workflow pulls the next unused quote from Google Sheets, generates a branded vertical MP4 in Zvid, renders it, then writes the finished VideoUrl back to the same row for review—running daily (8am) or on-demand.

What this workflow does

• Scheduled or manual execution: Runs every day at 8am (or you can start it manually) and loads its workflow configuration.
• Selects the next quote: Reads all rows from a specified Google Sheets tab and finds the first row where the Status column is empty.
• Builds a Zvid project: Creates a Zvid project JSON using the quote, author, optional author note, and a rotating background video/music selection.
• Validates before rendering: Uses the official Zvid node to validate the project and stops with a detailed error if invalid.
• Optional dry-run: If dryRun is enabled, it saves a draft in Zvid Editor and outputs an editor link plus estimated render credits—without updating the sheet.
• Renders the final video: With dryRun: false (default), submits a paid Zvid render and waits until completion, failure, or a configured timeout.
• Writes results back to Google Sheets: On success, updates the row with Status=done and VideoUrl. The watch-video step downloads the finished MP4 inside n8n for review. Failed renders leave the row pending.

Use cases

• SaaS teams producing daily motivational/quote short-form videos from a simple editorial spreadsheet.
• Automation engineers needing an audit-friendly pipeline: each row is rendered once, tracked via Status, and linked via VideoUrl.
• Content operators using dryRun to preview Zvid drafts before spending render credits.

Technical details

• n8n workflow category: n8n automation workflow
• Nodes used (as implemented): if, set, code, wait, zvidn8n-nodes-zvid (Zvid integration), plus a sticky note for workflow context.
• Zvid setup: Install @zvid/n8n-nodes-zvid from n8n Settings → Community nodes (owner/admin may need to install). Create a Zvid API credential using a key from https://app.zvid.io/api.