Create Sora 2 short videos from Google Sheets and post with PostWire
UnknownWhat this workflow does
This AI workflow has 15 nodes and runs on a schedule (every day at 09:00). Along the way it connects Google Sheets, OpenAI, Gmail and Postwire (community).
How it runs
Trigger: On a schedule (every day at 09:00).
- Channel settings (Edit Fields (Set)): sets 3 fields: style, seconds, email
- Read the video ideas (Google Sheets): read
- Has an idea (Filter): keeps only the items that match a condition
- Take the next idea (Limit): keeps the first few items
- Mark the idea as generating (Google Sheets): update
- Write the Sora 2 prompt (OpenAI): response (text)
- Read the plan (Edit Fields (Set)): sets 3 fields: plan, idea, row_number
- Sora 2 render (OpenAI): generate (video)
- Post to TikTok, Reels and Shorts (Post Wire): publish (post)
- Collect the results (Aggregate): combines items into one
…plus 4 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-postwire is verified or supports 3.0 (used in Post to TikTok, Reels and Shorts).
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Limit
n8n-nodes-base.limit - OpenAI
@n8n/n8n-nodes-langchain.openAi - Post Wire
n8n-nodes-postwire.postWire - Aggregate
n8n-nodes-base.aggregate - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail
From the author
Quick Overview This workflow runs daily, pulls the next “ready” video idea from Google Sheets, uses OpenAI to draft a Sora 2 prompt and metadata, generates a vertical short with Sora 2, and publishes it to TikTok, Instagram Reels, and YouTube Shorts via…