{"product_id":"create-ugc-ads-from-google-sheets-with-gemini-n8n","title":"Create UGC Ads from Google Sheets with Gemini \u0026 n8n","description":"\u003ch3\u003eCreate UGC Ads from Google Sheets with Gemini \u0026amp; n8n (Automated Daily Posting)\u003c\/h3\u003e\n\u003cp\u003eAutomatically generate creator-style UGC ad assets and platform-ready copy every day: this n8n workflow pulls the next “ready” product from Google Sheets, uses Google Gemini (Nano Banana image edits + Veo 3.1 video generation) to create UGC visuals and an ad plan, then publishes to Instagram\/Facebook\/TikTok\/Reels\/Shorts via PostWire—logging results back to your sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 10:00\u003c\/strong\u003e and scans your Google Sheets for the first row where \u003cem\u003estatus = ready\u003c\/em\u003e and \u003cem\u003ephoto_url\u003c\/em\u003e is valid.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClaims the row\u003c\/strong\u003e by setting the status to \u003cem\u003egenerating\u003c\/em\u003e so it won’t be processed twice.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Google Gemini\u003c\/strong\u003e to analyze the product photo and return a JSON \u003cstrong\u003ead plan\u003c\/strong\u003e including:\n    \u003cul\u003e\n      \u003cli\u003ea photo edit instruction,\u003c\/li\u003e\n      \u003cli\u003ea \u003cstrong\u003eVeo 3.1\u003c\/strong\u003e video prompt,\u003c\/li\u003e\n      \u003cli\u003ecaptions\/titles tailored for each platform.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a UGC-style creator image\u003c\/strong\u003e using Gemini (Nano Banana), downloads the product photo, creates the edited selfie-style asset, and publishes it to \u003cstrong\u003eInstagram\u003c\/strong\u003e and \u003cstrong\u003eFacebook\u003c\/strong\u003e via \u003cstrong\u003ePostWire\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates an 8-second 9:16 selfie video\u003c\/strong\u003e using \u003cstrong\u003eVeo 3.1\u003c\/strong\u003e, then publishes to \u003cstrong\u003eTikTok\u003c\/strong\u003e, \u003cstrong\u003eInstagram Reels\u003c\/strong\u003e, and \u003cstrong\u003eYouTube Shorts\u003c\/strong\u003e via PostWire.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks publishing success\u003c\/strong\u003e and writes posted links\/status back to Google Sheets, or logs an error note and emails “fix instructions” via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMarketing teams batch-produce UGC ads by updating a Google Sheet with new products and setting them to “ready.”\u003c\/li\u003e\n  \u003cli\u003eSaaS operators automate daily content creation and multichannel posting without manual asset editing.\u003c\/li\u003e\n  \u003cli\u003en8n users test reliable AI-to-publishing pipelines with Gemini-powered images, videos, and structured JSON outputs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: reads the next ready product and logs \u003cem\u003eposted_at\u003c\/em\u003e, links, and notes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e: Gemini image edit (Nano Banana) + \u003cstrong\u003eVeo 3.1\u003c\/strong\u003e video generation (8-second, 9:16) and JSON ad plan output.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePostWire\u003c\/strong\u003e: publishes generated image\/video assets to Instagram, Facebook, TikTok, Reels, and Shorts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: emails fix instructions on errors.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlow logic\u003c\/strong\u003e: uses nodes such as \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003elimit\u003c\/code\u003e, \u003ccode\u003efilter\u003c\/code\u003e, and \u003ccode\u003eaggregate\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46232436670643,"sku":"N8N-21037","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/WN_2qByrLBuojeXf_vnXY_hqB4CQho.png?v=1792142321","url":"https:\/\/buyflowscripts.com\/products\/create-ugc-ads-from-google-sheets-with-gemini-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}