Generate and publish AI short videos using Gemini, Sora-2, Apify, and Google Sheets

1. Overview This workflow automates the process of collecting viral content ideas, generating videos using AI services, and publishing posts to social media platforms. It uses scheduled triggers and external APIs to run the entire content pipeline with minimal manual input. Google Sheets is used as the central data layer to store ideas, track processing status, and prevent duplicate content. The workflow is designed to support continuous content production by connecting idea discovery, content generation, and publishing into a single automated system. 2. What Can This Workflow Do? This workflow can be used for: - Automatically collecting viral content ideas on a scheduled basis - Generating videos from text-based ideas without manual recording or editing - Publishing video content to social media platforms using a single workflow - Managing content status and processing history through Google Sheets - Running automated content pipelines for multiple niches or channels The workflow is suitable for users who want to reduce manual work while maintaining a structured and repeatable content production process. 3. Required API Keys & Credentials The following credentials must be configured before running the workflow: - Apify API Token: Used to scrape and collect viral content data - Google OAuth2: Required for Google Sheets API access - Gemini API Key: Used by the AI Agent for content analysis and generation - Video Generation API Key: (Kie.ai, GeminiGen.ai, fal.ai...) Required to generate AI videos - Blotato API Key: Used to automatically publish content to multiple social media platforms ⚠️ All API keys and credentials must be properly set up in n8n Credentials before executing the workflow. 4. High-Level Architecture The system is divided into two main workflows: 1. Get Content Viral: Collects and stores viral content ideas automatically 2. Create Video and Auto Post - Transforms ideas into AI-generated videos and publishes them automatically - Google Sheets as the Central Database Google Sheets serves as the central data layer to: - Act as the main content database - Prevent duplicate content processing - Track content status throughout the entire pipeline 5. Workflow 1 – Get Content Viral Purpose This workflow is responsible for automatically discovering and collecting viral content ideas, then storing them in Google Sheets for further processing. It acts as the idea intake layer of the entire AI Content Factory. Workflow Steps 1. Scheduled content execution The workflow is triggered automatically based on a predefined schedule (e.g. daily or multiple times per day). This allows the system to continuously collect fresh viral content ideas without manual intervention. 2. Run Apify Actor & Get Dataset - Executes an Apify Actor to scrape viral content data from selected sources - Retrieves a dataset containing raw content ideas, links, and metadata - This step is responsible for data collection and crawling. 3. Normalize scraped content data - Cleans and normalizes the scraped data - Removes unnecessary fields - Formats the content into a standardized structure suitable for storage This ensures consistency and data quality. 4. Save to Google Sheets (Viral Content) - Appends the processed content ideas into a dedicated Google Sheet - Each row represents a single viral content idea Google Sheets serves as the central idea repository for downstream workflows. Output: - After the workflow completes, you will have: - A continuously updated list of viral content ideas - Structured data ready for video generation - A centralized idea database accessible by other workflows 6. Workflow 2 – Create Video and Auto Post Purpose This workflow is responsible for transforming viral content ideas into AI-generated videos and automatically publishing them to social media platforms. It acts as the production and distribution layer of the AI Content Factory. Workflow Steps 1. Scheduled video generation The workflow runs automatically based on a pred