{"product_id":"n8n-ugc-video-ads-from-google-sheets-genmagic-gmail","title":"n8n UGC Video Ads from Google Sheets + GenMagic + Gmail","description":"\u003ch3\u003eTurn Google Sheets product rows into UGC-style 6-second video ads—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n automation workflow\u003c\/strong\u003e pulls new products from your Google Sheet, has \u003cstrong\u003eGenMagic\u003c\/strong\u003e generate multiple UGC-style ad variants, emails them for your approval via \u003cstrong\u003eGmail\u003c\/strong\u003e, and then renders only the variants you select as \u003cstrong\u003evertical 9:16 spoken clips\u003c\/strong\u003e. Results (links, captions, and cost) are written back to the sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns hourly\u003c\/strong\u003e: “Check Hourly” triggers the workflow every hour.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFinds the next product\u003c\/strong\u003e: “Get New Products” reads rows where \u003cem\u003eStatus\u003c\/em\u003e is \u003cstrong\u003enew\u003c\/strong\u003e, and “Pick Next Product” selects the first one.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads the product’s own facts\u003c\/strong\u003e: “Fetch Product Page” + “Extract Product Details” capture the title, description, image, and text so the scripts rely on the product page content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates ad variants in JSON\u003c\/strong\u003e: “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.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends for review by email\u003c\/strong\u003e: “Format Variants for Review” + “Request Approval by Email” email the variants and pause execution until you reply with which ones to render.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRenders only approved clips\u003c\/strong\u003e: “Read Approval” parses your response; “Any Variant Approved?” marks the row skipped if you reply \u003cstrong\u003e0\u003c\/strong\u003e. Approved variants proceed to:\n    \u003cul\u003e\n      \u003cli\u003e“Generate Presenter Photo” (Nano Banana using your product photo as reference)\u003c\/li\u003e\n      \u003cli\u003e“Generate Spoken Clip” (6-second 9:16, sound on, Veo 3.1 Lite)\u003c\/li\u003e\n      \u003cli\u003e“Save Ad Clip to Drive”\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites outputs back\u003c\/strong\u003e: “Construct Results” + “Mark Product Ready” update your Google Sheet with clip links, captions, and cost.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eHands-off ad production for an e-commerce catalog where new SKUs appear in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eMarketing teams needing \u003cstrong\u003eapproval-gated\u003c\/strong\u003e UGC-style creative (email review + selective rendering).\u003c\/li\u003e\n  \u003cli\u003eSaaS operators automating the end-to-end flow: product intake → creative variants → approved video assets → spreadsheet reporting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/nodes\u003c\/strong\u003e: if, code, gmail, limit, sticky note, Google Drive, plus Google Sheets-driven row logic.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore tools\u003c\/strong\u003e: GenMagic (variant generation) and Nano Banana (presenter photo reference), with spoken clip rendering via \u003cstrong\u003eVeo 3.1 Lite\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46359688839347,"sku":"N8N-22251","price":23.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/DPrwrooXqu7dLy67EXt2S_w2CzIuEJ.png?v=1793696443","url":"https:\/\/buyflowscripts.com\/products\/n8n-ugc-video-ads-from-google-sheets-genmagic-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}