{"product_id":"n8n-workflow-flash-sale-video-email-banners-sheets-zvid","title":"n8n Workflow: Flash-Sale Video \u0026 Email Banners (Sheets + Zvid)","description":"\u003ch3\u003eAutomate flash-sale creative: generate a Zvid vertical video + matching email banner from Google Sheets or Shopify\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically pulls eligible flash-sale data (from a pending \u003cstrong\u003eGoogle Sheets row\u003c\/strong\u003e or a \u003cstrong\u003eShopify price drop\u003c\/strong\u003e), renders a \u003cstrong\u003evertical flash-sale video\u003c\/strong\u003e and \u003cstrong\u003eemail banner\u003c\/strong\u003e via \u003cstrong\u003eZvid\u003c\/strong\u003e, and can then update your sheet and send the banner as an HTML email.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand or on a schedule\u003c\/strong\u003e: starts with a manual trigger for testing or on an hourly schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects the sale source\u003c\/strong\u003e based on configuration:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eShopify mode\u003c\/strong\u003e: polls Shopify for qualifying price drops.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets mode\u003c\/strong\u003e: reads the next unprocessed row from Google Sheets.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStops cleanly\u003c\/strong\u003e: if no eligible sale is found, it returns a “nothing to announce” result.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks background music URL\u003c\/strong\u003e and disables music if the file is unreachable or too large.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds and validates Zvid render payloads\u003c\/strong\u003e for both:\n    \u003cul\u003e\n      \u003cli\u003ea \u003cstrong\u003eflash-sale video\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003ea \u003cstrong\u003ebanner image\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupports dry run\u003c\/strong\u003e: when enabled, saves drafts in the Zvid editor and outputs preview links plus a credit estimate.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExecutes production renders\u003c\/strong\u003e when dry run is off: submits jobs one at a time, polls Zvid until both complete, then collects the final video and banner URLs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptionally updates outputs\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eupdates the originating Google Sheets row with status + URLs\u003c\/li\u003e\n      \u003cli\u003esends the banner as an \u003cstrong\u003eHTML email\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003edownloads finished assets for review\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurn Shopify price drops into ready-to-send flash-sale creative without manual design work.\u003c\/li\u003e\n  \u003cli\u003eUse Google Sheets as your “pending announcements” queue, then auto-generate video + email banners per row.\u003c\/li\u003e\n  \u003cli\u003ePreview renders via Zvid drafts during testing, then switch to production to publish automatically.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n + nodes)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCommunity node: \u003cstrong\u003e@zvid\/n8n-nodes-zvid\u003c\/strong\u003e (set up under n8n Settings → Community nodes)\u003c\/li\u003e\n  \u003cli\u003eCore workflow logic: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eDelivery: \u003cstrong\u003eemail send\u003c\/strong\u003e (HTML banner)\u003c\/li\u003e\n  \u003cli\u003eZvid rendering: \u003cstrong\u003ezvidn8n-nodes-zvid\u003c\/strong\u003e using your Zvid API key (\u003cstrong\u003ehttps:\/\/app.zvid.io\/api-keys\u003c\/strong\u003e)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46086643155123,"sku":"N8N-19918","price":9.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/bbEhYy8ndfvSW6YBc73Sz_jF06l0vg.png?v=1790327083","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-flash-sale-video-email-banners-sheets-zvid","provider":"N8N Commerce","version":"1.0","type":"link"}