n8n Abandoned Cart Video Automation: Google Sheets + Zvid

Turn abandoned carts into personalized video recoveries with n8n + Google Sheets + Zvid

This n8n workflow automatically finds eligible abandoned carts, generates a branded abandoned cart video using Zvid (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.

What this workflow does

• Runs hourly or on demand: Triggered on a schedule or via manual run, it loads workflow configuration including source, branding, music, and render settings.
• Pulls the next cart to recover:
  • Google Sheets: Reads the first row with an empty Status.
  • Shopify: Polls the Shopify Admin API for open checkouts within the configured age window.
• Stops cleanly when nothing is available: If no eligible cart/checkouts are found, it outputs “nothing to recover” and exits.
• Validates music availability: Probes the configured background music URL and skips music if unreachable or too large.
• Builds a 3-scene Zvid project: Creates a JSON project (hook, cart items, total/CTA) from cart details and validates it with Zvid’s validate endpoint.
• Renders (or drafts) the video:
  • If dryRun is enabled, saves a draft and returns an editor link—no rendering or record updates.
  • Otherwise submits the Zvid render job, polls until completion/timeout, and extracts the finished video URL.
• Recovers the cart and prevents reprocessing:
  • Optionally sends an HTML recovery email with the video link.
  • Marks the Google Sheets row as done (including the video URL) or stores the Shopify checkout ID to avoid repeat selection.

Use cases

• Send video-based abandonment recovery messages for carts captured in Google Sheets.
• Automate Shopify checkout recovery for customers who didn’t complete purchase within a specific time window.
• Maintain brand consistency with configured branding and optional background music.

Technical details

• n8n nodes/logic: if, set, code, wait, email send, zvidn8n-nodes-zvid.
• Integration required: Install @zvid/n8n-nodes-zvid in n8n (Settings → Community nodes) and configure Zvid credentials.
• Zvid workflow: Builds and validates a Zvid project JSON, then renders via Zvid render job polling and returns the final video URL.