UGC-style video ad pipeline from a sheet queue

Deliverables

• Sheet-based ad queue with a status check
• Gemini script agent with a three-segment output
• Three parallel image and clip generation branches
• Status polling loops for each clip and the final render
• Creatomate stitching of the three clips
• Drive uploads and sheet status updates

The challenge

Short-form video ads need a constant flow of new creative, and filming or editing every variation by hand is slow. A brand testing different hooks and angles needs a way to go from a written brief to a usable video without a production session for each version.

Our approach

The workflow reads the ad queue from Google Sheets and works through it row by row, only processing rows whose status is Ready. For each row, an AI agent on a Google Gemini chat model writes a structured script split into three segments. Three branches then run side by side: each generates a starting image, starts a video generation job on Replicate, waits 30 seconds, checks the job status and loops until the clip is complete, then downloads the clip and uploads it to Google Drive. A Code node merges the data for the three clips and sends it to Creatomate to stitch into one video. The workflow polls the render until it finishes, downloads the final video, uploads it to Drive, marks the sheet row as complete and loops back for the next row.