Library / Image, Video & Audio
Image, Video & Audio
Create UGC product ads from Google Sheets rows with Gemini, Veo and PostWire
Runs daily to claim the next ready product row in Google Sheets, write UGC ad copy with Gemini, and produce photo and video ads for social posting.
What it does
## Turn a product photo into UGC-style ads and post them Add a product and its photo to Google Sheets and get a UGC ad pack: a creator selfie photo for Instagram and Facebook and a talking selfie video for TikTok, Instagram Reels and YouTube Shorts. ### How it works 1. Every day at 10:00 takes the next row marked ready with a photo link and claims it. 2. Write the ad with Gemini looks at the photo and writes the photo edit, the Veo shot with one spoken line and a caption per network, using only the facts in the row. 3. Nano Banana UGC photo edits the real product photo into a creator selfie; Post the UGC photo (PostWire) publishes it on Instagram and Facebook. 4. Veo 3.1 UGC clip renders the 8-second vertical selfie video; Post the UGC video publishes it on TikTok, Reels and Shorts. 5. Mark the product as posted writes every link in the row. If a render or a network fails, Write the fix in the row and Email me the fix say what to fix. ### Setup 1. Install the verified PostWire node (search "PostWire" in the nodes panel), create an account at postwire.io, connect your networks and paste your API key into a PostWire API credential. 2. Add a Google Gemini credential to the three Gemini nodes. Nano Banana costs about 0.04 USD per image and Veo 3.1 Fast about 1.20 USD per clip. 3. Create a sheet with the columns product, photo_url, benefit, audience, status, posted_at, links and note, and pick it in the three Sheets nodes. 4. Connect Gmail and fill in Ad settings. ### Customize Change the creator and setting in Ad settings, or the networks in the two PostWire nodes.
The steps
- Every day at 10:00
- Ad settings
- Read the product queue
- Has a product photo
- Take the next product
- Mark the product as generating
- Write the ad with Gemini
- Read the plan
- Download the product photo
- Nano Banana UGC photo
- Post the UGC photo
- Veo 3.1 UGC clip
- Post the UGC video
- Collect the results
18 steps in total.
Similar automations
Image, Video & AudioCreate AI UGC Video Ads from Any Product Image18 stepsEmail AutomationTurn TikTok trends into Instagram and Facebook posts with Apify, Gemini, and PostWire20 stepsImage, Video & AudioGenerate Facebook Video Ads with Veo 3 and Claude17 stepsImage, Video & AudioCreate UGC Product Videos with Nano Banana62 steps