n8n Workflow: Create Zvid Testimonial Videos from Google Sheets

Turn Google Sheets (or Judge.me) reviews into vertical Zvid testimonial videos—automatically

This n8n workflow pulls eligible customer reviews from Google Sheets (or Judge.me), trims them into a video-friendly quote, generates a three-scene vertical testimonial with Zvid, and writes the resulting video URL back to your source row in Google Sheets so each review is processed only once.

What this workflow does

• Runs on demand (manual trigger) or on a daily schedule at 9am.
• Reads the next pending review from Google Sheets or fetches reviews from Judge.me, then selects one that meets your configured minimum rating.
• Cleans and normalizes the review text and checks the configured music URL; if the audio file is unreachable or too large, music is disabled.
• Trims the review into a quote using rules—or, if enabled, calls OpenRouter to choose an in-budget quote from the original text.
• Builds a three-scene Zvid project JSON (hook, quote, CTA) and validates it with Zvid to catch payload issues and estimate credits.
• If dryRun is enabled, saves a draft in the Zvid editor and returns the editor link; otherwise submits a render job, polls until completion, and returns the final video URL.
• In Google Sheets mode, updates the source row with Status and VideoUrl so the review won’t be reprocessed.

Use cases

• Auto-produce vertical testimonial clips for SaaS marketing using only high-rated reviews.
• Weekly/monthly review-to-video pipelines for e-commerce using Google Sheets as the review queue.
• Rapid experimentation: use dryRun to preview drafts before rendering at scale.

Technical details

• n8n nodes include: if, set, code, wait, @zvid/n8n-nodes-zvid (Zvid), plus a sticky note.
• Requires installing @zvid/n8n-nodes-zvid via n8n Settings → Community nodes, and creating a Zvid API key at https://app.zvid.io/api-keys using Base URL https://api.zvid.io.