Back to Templates
This n8n template demonstrates how to fully automate the creation of UGC-style product videos using AI, starting from a simple Google Sheet.
It transforms product data into AI-generated images, cinematic video scripts, and final videos, then uploads everything to Google Drive and updates your sheet automatically.
💡 Use cases
- Generate UGC ads at scale for e-commerce products
- Create TikTok / Reels content automatically
- Build content pipelines for agencies or creators
- Rapidly test different product angles, audiences, and messaging
- Automate creative production from structured data (Google Sheets)
Good to know
- This workflow uses multiple AI services (image + video), so cost depends on usage:
- Image generation (DALL·E)
- Video generation (Sora)
- Video generation is asynchronous and may take several minutes per item
- Some AI models (like Sora) may be region-restricted or limited access
- Generated image URLs may expire, so storing them (as done here) is important
How it works
- Reads product data from Google Sheets and selects rows marked "Pending".
- Creates a prompt and generates a product image.
- Analyzes the image and turns it into a video script.
- Sends the script to Sora and waits until the video is ready.
- Uploads the video to Google Drive and updates the sheet.
- Logs errors and marks the row as "Error".
How to use
- Add products to Google Sheets with name, description, audience, and set status to "Pending".
- Run the workflow or let the schedule trigger process items automatically.
- The system generates image → script → video, uploads them, and updates your sheet.
Requirements
- Requires OpenAI, Google Sheets, and Google Drive accounts.
- Requires an n8n instance with credentials configured.
Customizing this workflow
- Replace the schedule trigger with a webhook or form for real-time use.
- Generate multiple videos per product.
- Send outputs to platforms like TikTok, Meta Ads, or CMS tools.
- Add voiceovers, captions, or permanent asset storage.