What this workflow does
Auto-collect viral content ideas
My workflow fetches viral content data from Google Sheets and preprocesses it inside n8n.
Gemini 3.0 AI Agent → Structured Output
Gemini returns:
-
title -
description -
video_prompt
All in a strict JSON schema using the Structured Output Parser.
Send the prompt to Sora 2
Sora 2 generates 1080×1920 home-camera style videos through their API (Key.ai).
Wait + Retrieve video
A dynamic Wait node handles rendering time (150–400s depending on load).
Auto-post using Blotato
Blotato’s API is connected via verified community node →
It automatically posts the generated video to platforms like:
-
TikTok
-
YouTube Shorts
-
Instagram Reels
All with title + description from Gemini.
(YouTube supports contains_synthetic_media; TikTok currently does not.)
Update Google Sheet
The workflow updates the row with:
-
video link
-
status
-
metadata
Why Blotato?
Blotato uses fully verified social-media APIs → meaning:
-
No shadowbans
-
Stable posting
-
Supports up to 20 social accounts
-
Perfect for automation tools like n8n
The whole system works hands-free once configured.
What I’m sharing
If anyone wants:
-
workflow JSON
-
Gemini 3.0 prompts
-
Sora 2 API setup guide
Just let me know — happy to share with the community.
Questions for the community
-
What’s your best practice for handling long Sora render times dynamically?
-
Any suggestion for improving the retry logic for failed video posts?
-
Anyone integrating Blotato + Gemini + Sora in a different setup?
Thanks n8n community — this automation stack is getting insanely powerful.
Happy to exchange ideas with anyone working on AI video workflows! 