{"product_id":"daily-quote-video-automation-google-sheets-zvid-n8n","title":"Daily Quote Video Automation: Google Sheets → Zvid (n8n)","description":"\u003ch3\u003eTurn your Google Sheet into branded daily quote videos—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls the next unused quote from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, generates a branded vertical \u003cstrong\u003eMP4\u003c\/strong\u003e in \u003cstrong\u003eZvid\u003c\/strong\u003e, renders it, then writes the finished \u003cstrong\u003eVideoUrl\u003c\/strong\u003e back to the same row for review—running daily (8am) or on-demand.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled or manual execution:\u003c\/strong\u003e Runs every day at \u003cstrong\u003e8am\u003c\/strong\u003e (or you can start it manually) and loads its workflow configuration.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects the next quote:\u003c\/strong\u003e Reads all rows from a specified Google Sheets tab and finds the first row where the \u003cstrong\u003eStatus\u003c\/strong\u003e column is empty.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a Zvid project:\u003c\/strong\u003e Creates a Zvid project JSON using the \u003cstrong\u003equote\u003c\/strong\u003e, \u003cstrong\u003eauthor\u003c\/strong\u003e, optional \u003cstrong\u003eauthor note\u003c\/strong\u003e, and a rotating background video\/music selection.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates before rendering:\u003c\/strong\u003e Uses the official Zvid node to validate the project and stops with a detailed error if invalid.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional dry-run:\u003c\/strong\u003e If \u003cstrong\u003edryRun\u003c\/strong\u003e is enabled, it saves a draft in Zvid Editor and outputs an editor link plus estimated render credits—without updating the sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRenders the final video:\u003c\/strong\u003e With \u003cstrong\u003edryRun: false\u003c\/strong\u003e (default), submits a paid Zvid render and waits until completion, failure, or a configured timeout.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results back to Google Sheets:\u003c\/strong\u003e On success, updates the row with \u003cstrong\u003eStatus=done\u003c\/strong\u003e and \u003cstrong\u003eVideoUrl\u003c\/strong\u003e. The watch-video step downloads the finished MP4 inside n8n for review. Failed renders leave the row pending.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams producing \u003cstrong\u003edaily motivational\/quote\u003c\/strong\u003e short-form videos from a simple editorial spreadsheet.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing an audit-friendly pipeline: each row is rendered once, tracked via \u003cstrong\u003eStatus\u003c\/strong\u003e, and linked via \u003cstrong\u003eVideoUrl\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eContent operators using \u003cstrong\u003edryRun\u003c\/strong\u003e to preview Zvid drafts before spending render credits.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow category:\u003c\/strong\u003e n8n automation workflow\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used (as implemented):\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003ewait\u003c\/em\u003e, \u003cstrong\u003ezvidn8n-nodes-zvid\u003c\/strong\u003e (Zvid integration), plus a sticky note for workflow context.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eZvid setup:\u003c\/strong\u003e Install \u003ccode\u003e@zvid\/n8n-nodes-zvid\u003c\/code\u003e from n8n Settings → Community nodes (owner\/admin may need to install). Create a Zvid API credential using a key from \u003ca href=\"https:\/\/app.zvid.io\/api\" target=\"_blank\" rel=\"noopener noreferrer\"\u003ehttps:\/\/app.zvid.io\/api\u003c\/a\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46042471563443,"sku":"N8N-19632","price":70.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/4bvwC1XkPMnhmbTysbD1p_GDw2RbLi.png?v=1789549701","url":"https:\/\/buyflowscripts.com\/products\/daily-quote-video-automation-google-sheets-zvid-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}