FREE - Insane AI Workflow Creates Viral UGC Videos

TL;DR

This short guide shows you how the AI UGC Video Automation system works — from reading a Google Sheet to generating a UGC image, transforming it, creating an 8-second Veo video, and updating the sheet automatically. Reading time: 4 min

Output Video 1
Output Video 2

System overview

This automation pulls “Pending” rows from Google Sheets, generates a UGC-style image, converts it, uploads it, analyzes it, creates a selfie-style UGC video prompt, sends it to Kie.AI’s Veo model, waits for completion, grabs the final video, and updates your sheet with the result. If anything breaks, it retries and emails you.

Who benefits

• Content creators
• Ecommerce founders
• UGC agencies
• Media buyers
• AI video automation builders

Who will use it

• Operators: People uploading product data + instructions into Google Sheets
• Automation owners: Monitoring errors, API keys, and workflow uptime
• Editors: Reviewing final UGC videos

Key components & data flows

• Google Sheets → Input for product, audience, instructions
• Image Prompt Agent → Generates UGC image prompt
• Image generator (OpenRouter → Gemini Flash) → Produces transformed product image
• Image uploader (ImgBB) → Returns a URL for the image
• OpenAI Vision → Analyzes image to maintain consistency
• Video Prompt Agent → Creates Veo video prompt
• Kie.AI Veo API → Generates video
• Retry Loop → Polls for finished video
• Sheet updater → Writes final URL back to sheet
• Error handler → Sends email alerts

Flow:

Sheet → Image Prompt → Image Processing → Vision Analysis → Video Prompt → Veo → Poll → Sheet Update → Done