{"product_id":"n8n-workflow-weekly-restaurant-specials-video-from-google-sheets","title":"n8n Workflow: Weekly Restaurant Specials Video from Google Sheets","description":"\u003ch3\u003eTurn Your Weekly Restaurant Specials Into a Branded Vertical Reel (Every Monday)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically reads your restaurant’s menu specials from Google Sheets every week, generates a Zvid video project, validates it, and returns a shareable “weekly specials” reel URL—along with a ready-to-post caption.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eDesigned for consistent, branded social video production, the workflow:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules weekly\u003c\/strong\u003e: runs every Monday at 9am (or you can trigger it on-demand with a manual test trigger).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls dish data from Google Sheets\u003c\/strong\u003e: loads configuration values (restaurant details, branding, timing, media, and dry-run settings), then reads rows from your menu tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects this week’s specials\u003c\/strong\u003e: filters rows where \u003cem\u003eThisWeek = TRUE\u003c\/em\u003e, then normalizes up to \u003cstrong\u003efive dishes\u003c\/strong\u003e (name, description, price, photo URL).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a Zvid project\u003c\/strong\u003e: creates a sizzle hook, generates \u003cstrong\u003eone scene per dish\u003c\/strong\u003e, and appends a booking end card. Photo inputs are expected to be within \u003cstrong\u003e1920×1920\u003c\/strong\u003e to avoid distortion.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates before rendering\u003c\/strong\u003e: sends the project to Zvid’s validate endpoint to check schema and estimate credits. If validation fails, it stops with a detailed error.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRenders and outputs results\u003c\/strong\u003e: with \u003ccode\u003edryRun=false\u003c\/code\u003e (default), it submits a render job and polls until completion or timeout. With \u003ccode\u003edryRun=true\u003c\/code\u003e, it saves an editor draft via \u003cem\u003eZvid Project → Create\u003c\/em\u003e (note: not exposed in published npm v0.1.8—keep \u003ccode\u003efalse\u003c\/code\u003e for that version).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns review assets\u003c\/strong\u003e: outputs the completed video URL and a suggested caption. A gated Watch step downloads completed media for review; final sharing is manual.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly Instagram\/TikTok “specials” reels for restaurants using Google Sheets as the source of truth\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building repeatable Zvid-driven video pipelines in n8n\u003c\/li\u003e\n  \u003cli\u003eSaaS operators validating credit usage and schema before rendering via Zvid validation\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWorkflow nodes include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, and \u003cstrong\u003ezvidn8n-nodes-zvid\u003c\/strong\u003e (plus \u003cstrong\u003esticky note\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003eInstall the node: \u003cstrong\u003e@zvid\/n8n-nodes-zvid\u003c\/strong\u003e via \u003cem\u003eSettings → Community nodes\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (menu tab) and \u003cstrong\u003eZvid\u003c\/strong\u003e (project build, validate, render, and draft creation in dry-run).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146264498355,"sku":"N8N-20264","price":29.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/KUIImUAqIKliZr9H6bhep_cQyXvbJO.png?v=1790845596","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-weekly-restaurant-specials-video-from-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}