Generate UGC-style AI videos with Google Sheets, NanoBanana Pro and Veo 3.1

🎬 AI-Powered UGC Video Generator

Automatically create consistent, professional UGC (User-Generated Content) videos at scale using cutting-edge AI models. This workflow combines three reference images into hyper-realistic selfie-style photos, then transforms them into engaging 8-second videos perfect for TikTok, Instagram Reels, and social media ads.

✨ What This Workflow Does

Part 1: Image Generation Combines 3 reference images (product + character + background) using NanoBanana Pro AI agent generates optimized prompts for realistic UGC selfie photos Analyzes output quality before proceeding to video generation

Part 2: Video Creation Transforms static images into dynamic 8-second videos using Google Veo 3.1 AI agent creates natural dialogue and scene descriptions Batch processes multiple tasks automatically via Google Sheets

🎯 Perfect For

E-commerce brands** creating product demonstration videos Marketing agencies** producing social media ad content at scale Content creators** generating consistent UGC-style videos A/B testing** multiple video variations quickly Dropshippers** needing authentic product videos without filming

🚀 Key Features

✅ Consistent Characters - Same person, style, and aesthetic across all videos
✅ Batch Processing - Manage multiple tasks via Google Sheets
✅ Multi-Model Support - Primary + fallback AI models for reliability
✅ Smart Error Handling - Automatic retries and status tracking
✅ Dual Workflow - Separate pipelines for image and video generation
✅ Quality Analysis - AI checks image quality before video creation

🛠️ Required APIs

Essential: Google Sheets API (free) Atlas Cloud API (for NanoBanana Pro & Veo 3.1)

Choose at least ONE: OpenAI API (GPT-5-Mini recommended) Groq API (fast & free tier available) Google Gemini API (alternative)

📋 How It Works

Image Generation Pipeline: Reads tasks from Google Sheets (Status: "Ready") AI agent generates optimized image prompt Downloads and uploads 3 reference images to temp storage NanoBanana Pro combines images into realistic UGC selfie Analyzes output image quality Updates sheet with results (Status: "Edited")

Video Generation Pipeline: Reads edited tasks from Google Sheets (Status: "Edited") AI agent generates video prompt with natural dialogue Veo 3.1 transforms image into 8-second video Polls generation status every 10 seconds Updates sheet with final video (Status: "Finished")

💡 Pro Tips

Use high-quality reference images** (minimum 1024x1024px) Keep character photos consistent** (same person, similar lighting) Write clear scene descriptions** for better results Test with 1 task first** before running large batches Monitor API quotas** to avoid rate limits

📺 Full Tutorial

Complete setup walkthrough available on YouTube: Watch Tutorial

🎓 What You'll Learn

Setting up multi-step AI automation workflows Integrating multiple AI models (OpenAI, Groq, Gemini) Using NanoBanana Pro for advanced image editing Generating videos with Google Veo 3.1 Managing batch processes via Google Sheets Implementing fallback models for reliability Handling errors and status tracking

📊 Google Sheets Template Structure

The workflow includes a pre-built template with these columns: Task ID** - Unique identifier Product Photo** - Product image URL Character** - Person reference image URL Background** - Scene background URL Product Name** - Name of the product Product Description** - Details about the product Target Market** - Audience for the video Video Scene** - Scene description for video Status** - Workflow status (Ready → Edited → Finished) Image Prompt** - Generated prompt for image Image Result** - Output image URL Analyze Image** - Quality analysis results Video Prompt** - Generated prompt for video Video Result** - Final video URL Error Message** - Error details if failed

🔄 Status Flow Ready → Edited → Finished ↓ ↓ ↓ Error Error Error

⚙️ Customization Options

Adjust Image Style: Modify the Image Prompt Agent system message Change composition (close-up, medium shot, wide) Adjust lighting (natural, studio, dramatic)

Modify Video Output: Edit Video Prompt Agent for different styles Change duration (default: 8 seconds) Customize dialogue language (default: Indonesian) Adjust camera angles and movements

Add More AI Models: Connect additional providers as fallbacks Models are tried in order until success Supports OpenAI, Anthropic, Groq, Gemini

🔐 Security Notes

Never commit API keys to version control Use environment variables in production Don't share your Google Sheets publicly Rotate API keys regularly Set billing alerts on all platforms

📞 Support & Updates

Created by: Kristian Ekachandra

Follow for more AI automation workflows: 🎥 YouTube: @aichandre 📸 Instagram: @aichandre 🎵 TikTok: @aichandre

🏷️ Tags

ai-video ugc content-creation video-generation batch-processing google-sheets openai groq nanobanana-pro veo-3.1 marketing social-media tiktok instagram-reels automation