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

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

Unknown

by giangxai ✓ · 488 views · created 2025-12-11 · Content Creation, Multimodal AI

Unknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 18 nodes and runs on a schedule (every 6 hours) (plus 1 other trigger). Along the way it connects Google Gemini Chat Model, Google Gemini, Google Sheets and Blotato (community) and 1 more. It also calls api.geminigen.ai over HTTP.

How it runs

Trigger: On a schedule (every 6 hours) (plus 1 other trigger).

Run an Actor and get dataset (Apify): run actor and get dataset
Get ViralContent (Google Sheets): uses Google Sheets
Normalize scraped content data (Edit Fields (Set)): sets 11 fields: Caption, Date Post, Username…
Analyze video (Google Gemini): analyze (video)
Viral Content (Google Sheets): append
Analyze idea and generate video metadata (AI Agent): runs an AI agent, with model: Google Gemini Chat Model; 1 tool (Think); output parser: Structured Output Parser
Format AI output for video generation (Edit Fields (Set)): sets 3 fields: Title, Description, Prompt
Create Video (HTTP Request): calls api.geminigen.ai (POST)
Wait: pauses before continuing
Get Video (HTTP Request): calls an HTTP API

…plus 3 more steps. See the full node list below.

Services it uses

Google Gemini Chat Model Google Gemini Google SheetsBlotato (community)Apify (community)

HTTP calls to: api.geminigen.ai

Before you upgrade to n8n 3.0

We can't fully verify this one: it relies on 2 community packages, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).

Check that @blotato/n8n-nodes-blotato is verified or supports 3.0 (used in Create post).
Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Run an Actor and get dataset).

Nodes used (13)

Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
Think Tool@n8n/n8n-nodes-langchain.toolThink
Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
Blotato@blotato/n8n-nodes-blotato.blotato
Switchn8n-nodes-base.switch
Google Gemini@n8n/n8n-nodes-langchain.googleGemini
Apify@apify/n8n-nodes-apify.apify
Google Sheetsn8n-nodes-base.googleSheets
HTTP Requestn8n-nodes-base.httpRequest
Schedule Triggern8n-nodes-base.scheduleTrigger
AI Agent@n8n/n8n-nodes-langchain.agent
Waitn8n-nodes-base.wait
Edit Fields (Set)n8n-nodes-base.set

From the author

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…
Excerpt from giangxai's description on n8n.io.

View the original on n8n.io → Check your own copy

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

What this workflow does

How it runs

Services it uses

Before you upgrade to n8n 3.0

Nodes used (13)

From the author

Get the weekly “what broke” email