n8n UGC Video Ads from Google Sheets + GenMagic + Gmail

Turn Google Sheets product rows into UGC-style 6-second video ads—automatically

This n8n automation workflow pulls new products from your Google Sheet, has GenMagic generate multiple UGC-style ad variants, emails them for your approval via Gmail, and then renders only the variants you select as vertical 9:16 spoken clips. Results (links, captions, and cost) are written back to the sheet.

What this workflow does

• Runs hourly: “Check Hourly” triggers the workflow every hour.
• Finds the next product: “Get New Products” reads rows where Status is new, and “Pick Next Product” selects the first one.
• Reads the product’s own facts: “Fetch Product Page” + “Extract Product Details” capture the title, description, image, and text so the scripts rely on the product page content.
• Generates ad variants in JSON: “Generate Ad Variants” asks GenMagic to produce multiple variants (angle, spoken line ≤ 16 words, presenter + setting, action, caption). Presenters introduce the product without claiming they personally used it.
• Sends for review by email: “Format Variants for Review” + “Request Approval by Email” email the variants and pause execution until you reply with which ones to render.
• Renders only approved clips: “Read Approval” parses your response; “Any Variant Approved?” marks the row skipped if you reply 0. Approved variants proceed to:
  • “Generate Presenter Photo” (Nano Banana using your product photo as reference)
  • “Generate Spoken Clip” (6-second 9:16, sound on, Veo 3.1 Lite)
  • “Save Ad Clip to Drive”
• Writes outputs back: “Construct Results” + “Mark Product Ready” update your Google Sheet with clip links, captions, and cost.

Use cases

• Hands-off ad production for an e-commerce catalog where new SKUs appear in Google Sheets.
• Marketing teams needing approval-gated UGC-style creative (email review + selective rendering).
• SaaS operators automating the end-to-end flow: product intake → creative variants → approved video assets → spreadsheet reporting.

Technical details

• Integrations/nodes: if, code, gmail, limit, sticky note, Google Drive, plus Google Sheets-driven row logic.
• Core tools: GenMagic (variant generation) and Nano Banana (presenter photo reference), with spoken clip rendering via Veo 3.1 Lite.