{"product_id":"n8n-abandoned-cart-video-automation-google-sheets-zvid","title":"n8n Abandoned Cart Video Automation: Google Sheets + Zvid","description":"\u003ch3\u003eTurn abandoned carts into personalized video recoveries with n8n + Google Sheets + Zvid\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically finds eligible abandoned carts, generates a branded \u003cstrong\u003eabandoned cart video\u003c\/strong\u003e using \u003cstrong\u003eZvid\u003c\/strong\u003e (up to three products), optionally emails a recovery message with the checkout link, and then records the result so the same cart isn’t selected again.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns hourly or on demand\u003c\/strong\u003e: Triggered on a schedule or via manual run, it loads workflow configuration including source, branding, music, and render settings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls the next cart to recover\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: Reads the first row with an empty \u003cem\u003eStatus\u003c\/em\u003e.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eShopify\u003c\/strong\u003e: Polls the Shopify Admin API for open checkouts within the configured age window.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStops cleanly when nothing is available\u003c\/strong\u003e: If no eligible cart\/checkouts are found, it outputs \u003cem\u003e“nothing to recover”\u003c\/em\u003e and exits.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates music availability\u003c\/strong\u003e: Probes the configured background music URL and skips music if unreachable or too large.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a 3-scene Zvid project\u003c\/strong\u003e: Creates a JSON project (hook, cart items, total\/CTA) from cart details and validates it with Zvid’s validate endpoint.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRenders (or drafts) the video\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eIf \u003cstrong\u003edryRun\u003c\/strong\u003e is enabled, saves a draft and returns an editor link—no rendering or record updates.\u003c\/li\u003e\n      \u003cli\u003eOtherwise submits the Zvid render job, polls until completion\/timeout, and extracts the finished video URL.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRecovers the cart and prevents reprocessing\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eOptionally sends an HTML recovery email with the video link.\u003c\/li\u003e\n      \u003cli\u003eMarks the Google Sheets row as done (including the video URL) or stores the Shopify checkout ID to avoid repeat selection.\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\u003eSend video-based abandonment recovery messages for carts captured in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAutomate Shopify checkout recovery for customers who didn’t complete purchase within a specific time window.\u003c\/li\u003e\n  \u003cli\u003eMaintain brand consistency with configured branding and optional background music.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic\u003c\/strong\u003e: if, set, code, wait, email send, zvidn8n-nodes-zvid.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegration required\u003c\/strong\u003e: Install \u003cstrong\u003e@zvid\/n8n-nodes-zvid\u003c\/strong\u003e in n8n (Settings → Community nodes) and configure Zvid credentials.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eZvid workflow\u003c\/strong\u003e: Builds and validates a Zvid project JSON, then renders via Zvid render job polling and returns the final video URL.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46086640107699,"sku":"N8N-19920","price":3.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9Q_wWpHgiXLiDznls8oJU_gzHMfurv.png?v=1790327020","url":"https:\/\/buyflowscripts.com\/products\/n8n-abandoned-cart-video-automation-google-sheets-zvid","provider":"N8N Commerce","version":"1.0","type":"link"}