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: 1. Reads tasks from Google Sheets (Status: "Ready") 2. AI agent generates optimized image prompt 3. Downloads and uploads 3 reference images to temp storage 4. NanoBanana Pro combines images into realistic UGC selfie 5. Analyzes output image quality 6. Updates sheet with results (Status: "Edited") Video Generation Pipeline: 1. Reads edited tasks from Google Sheets (Status: "Edited") 2. AI agent generates video prompt with natural dialogue 3. Veo 3.1 transforms image into 8-second video 4. Polls generation status every 10 seconds 5. 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 ⚙️ 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