Automatic Top 10 Videos | GSheets -> OpenRouter -> JSON2VIDEO -> Youtube

Automated "Top 10" YouTube Video Factory Workflow Overview This workflow automates the entire lifecycle of creating and publishing "Top 10" style YouTube videos. It operates in two distinct phases: first, it uses AI to generate a list of potential video topics and stores them in a Google Sheet. Second, it processes each topic from the sheet, using AI to write a complete script (intro, outro, and the 10 ranked items), generates a video using a template-based service, and finally uploads the finished video to YouTube as "unlisted". This powerful automation acts as a content factory, transforming a simple idea queue in a spreadsheet into a library of ready-to-publish videos with minimal human intervention. Key Technologies Used - Google Sheets: Acts as the central database and control panel for video ideas and their creation/posting status. - OpenRouter: Serves as the AI gateway, providing access to powerful language models like GPT-4o for all creative and scriptwriting tasks. - JSON2Video: A specialized API that generates videos from structured JSON data. It combines AI-generated image prompts and voiceover text with a pre-designed video template. - ElevenLabs: Integrated via the JSON2Video API to generate high-quality AI voiceovers for the scripts. - YouTube: The final destination for the automated content, where videos are uploaded and managed. - n8n: The orchestration platform that connects these services and automates the entire process. How AI Integrates into the Flow AI is the creative engine of this workflow, responsible for generating all the core content. It's used in three critical stages: 1. Topic Ideation: An AI Agent (4o-mini model) brainstorms a list of evergreen "Top 10" video subjects, ensuring a constant supply of fresh ideas. 2. Script Writing (Intro/Outro): A second AI Agent (4o model) takes a video subject from the Google Sheet and writes a compelling intro and outro. This includes both the voiceover text and a descriptive prompt for generating a matching background image. 3. Content Generation (The Top 10 List): A third, highly-specialized AI Agent (4o model) generates the main content.