n8n Automation: Create Sora 2 Shorts from Google Sheets

Turn Google Sheet ideas into daily vertical shorts automatically with Sora 2 + n8n

This n8n automation finds the next ready video idea in your Google Sheets, uses OpenAI to plan a Sora 2 prompt and metadata, generates a 9:16 short, and then publishes it to TikTok, Instagram Reels, and YouTube Shorts via PostWire—while logging results back to the same row (or emailing fixes if something fails).

What this workflow does

• Runs daily at 9:00 and reads rows from Google Sheets where the status is set to “ready”.
• Selects the first available idea and updates that row to “generating” to prevent duplicate renders.
• Uses OpenAI (text) to output a JSON plan: a Sora 2 video prompt, a caption idea, and a YouTube Shorts title.
• Uses OpenAI Sora 2 (video) to render a vertical 9:16 clip at 720x1280 for the configured duration.
• Uploads and publishes to TikTok, Instagram, and YouTube with PostWire, generating platform-specific captions and applying the YouTube title.
• Aggregates outcomes: updates the Google Sheets row with post links and status “posted”, or writes an error note and sends fix details via Gmail if any platform fails.

Use cases

• SaaS operators who maintain a content backlog in Google Sheets and want hands-off daily short publishing.
• Automation engineers building a repeatable pipeline for Sora 2 vertical short generation and multi-platform distribution.
• Teams testing new short ideas: mark a row as ready, let n8n render and publish, then review links in-sheet.

Technical details

• Google Sheets: read “ready” rows; update status to “generating” and later to “posted” with links/errors.
• OpenAI: chat model for JSON planning; Sora 2 for video generation.
• PostWire: publish to TikTok, Instagram Reels, and YouTube Shorts.
• Gmail: email fix details when publishing fails.
• Logic/nodes include: if, set, gmail, limit, filter, aggregate.

Get this n8n workflow if you want a practical, Google Sheets-driven pipeline for creating and publishing daily Sora 2 Shorts with full status tracking.