Generate UGC product videos from Google Sheets with DALL·E, GPT-4 and Sora

Description

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.