Technology Stack: n8n, OpenAI (LLM), Google Sheets, Custom API (Voice + Image + Video Rendering)
This advanced no-code automation transforms a simple Google Sheet entry into a fully edited video — complete with images, voiceover, background music, and intro clips. Built entirely in n8n, the system reads user-defined fields like topic, caption style, tone, and script preferences from Sheet 1. It then passes this data to an LLM (OpenAI) to generate an optimized visual + audio prompt.
In parallel, Sheet 2 holds creative assets like intro video, background music, and styling preferences, which are fetched and passed into a custom API that renders:
- Relevant images based on the prompt
- AI-generated voiceover
- Edited video with transitions, music, and text overlays
The final output is a complete video ready for posting on YouTube, TikTok, Instagram, or any platform.
Use Case Highlights:
- Auto-generates educational, motivational, or promotional videos from spreadsheet input
- GPT-powered prompt creation ensures high-quality, tailored content
- Eliminates the need for manual editing — everything is handled by automation
- Ideal for content creators, agencies, YouTube automation channels, and marketers
