{"product_id":"n8n-workflow-create-zvid-testimonial-videos-from-google-sheets","title":"n8n Workflow: Create Zvid Testimonial Videos from Google Sheets","description":"\u003ch3\u003eTurn Google Sheets (or Judge.me) reviews into vertical Zvid testimonial videos—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls eligible customer reviews from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (or \u003cstrong\u003eJudge.me\u003c\/strong\u003e), trims them into a video-friendly quote, generates a \u003cstrong\u003ethree-scene vertical testimonial\u003c\/strong\u003e with \u003cstrong\u003eZvid\u003c\/strong\u003e, and writes the resulting \u003cstrong\u003evideo URL\u003c\/strong\u003e back to your source row in Google Sheets so each review is processed only once.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand\u003c\/strong\u003e (manual trigger) or on a \u003cstrong\u003edaily schedule at 9am\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eReads the \u003cstrong\u003enext pending review\u003c\/strong\u003e from Google Sheets or fetches reviews from \u003cstrong\u003eJudge.me\u003c\/strong\u003e, then selects one that meets your configured \u003cstrong\u003eminimum rating\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCleans and normalizes\u003c\/strong\u003e the review text and checks the configured \u003cstrong\u003emusic URL\u003c\/strong\u003e; if the audio file is unreachable or too large, \u003cstrong\u003emusic is disabled\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eTrims the review into a quote using \u003cstrong\u003erules\u003c\/strong\u003e—or, if enabled, calls \u003cstrong\u003eOpenRouter\u003c\/strong\u003e to choose an \u003cstrong\u003ein-budget\u003c\/strong\u003e quote from the original text.\u003c\/li\u003e\n  \u003cli\u003eBuilds a \u003cstrong\u003ethree-scene Zvid project JSON\u003c\/strong\u003e (hook, quote, CTA) and validates it with Zvid to catch payload issues and estimate credits.\u003c\/li\u003e\n  \u003cli\u003eIf \u003cstrong\u003edryRun\u003c\/strong\u003e is enabled, saves a draft in the Zvid editor and returns the editor link; otherwise submits a render job, \u003cstrong\u003epolls until completion\u003c\/strong\u003e, and returns the final \u003cstrong\u003evideo URL\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIn \u003cstrong\u003eGoogle Sheets mode\u003c\/strong\u003e, updates the source row with \u003cstrong\u003eStatus\u003c\/strong\u003e and \u003cstrong\u003eVideoUrl\u003c\/strong\u003e so the review won’t be reprocessed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAuto-produce vertical testimonial clips for \u003cstrong\u003eSaaS marketing\u003c\/strong\u003e using only high-rated reviews.\u003c\/li\u003e\n  \u003cli\u003eWeekly\/monthly review-to-video pipelines for \u003cstrong\u003ee-commerce\u003c\/strong\u003e using Google Sheets as the review queue.\u003c\/li\u003e\n  \u003cli\u003eRapid experimentation: use \u003cstrong\u003edryRun\u003c\/strong\u003e to preview drafts before rendering at scale.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003e@zvid\/n8n-nodes-zvid\u003c\/strong\u003e (Zvid), plus a \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eRequires installing \u003cstrong\u003e@zvid\/n8n-nodes-zvid\u003c\/strong\u003e via n8n Settings → Community nodes, and creating a Zvid API key at \u003cstrong\u003ehttps:\/\/app.zvid.io\/api-keys\u003c\/strong\u003e using Base URL \u003cstrong\u003ehttps:\/\/api.zvid.io\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46086641025203,"sku":"N8N-19919","price":25.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9lxGFTq4ra_FRKFdUSpSY_KNBDSxsL.png?v=1790327044","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-create-zvid-testimonial-videos-from-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}