Create and publish AI YouTube videos from Google Sheets with GPT-4o and JSON2Video
Ready for 3.0What this workflow does
This AI workflow has 21 nodes and runs on a schedule (every day) (plus 2 other triggers). Along the way it connects Google Sheets, OpenAI Chat Model and YouTube.
How it runs
Trigger: On a schedule (every day) (plus 2 other triggers).
- Read from Sheets (Google Sheets): uses Google Sheets
- Read Approved Video (Google Sheets): uses Google Sheets
- Chain LLM Prompts (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI GPT-4 Chat; output parser: Parse Structured Output
- Ready to Publish? (If): checks a condition and branches into true / false
- Fetch Music from Sheets (Google Sheets): uses Google Sheets
- Fetch Approved Video (HTTP Request): calls an HTTP API
- Post to Json2Video API (HTTP Request): calls an HTTP API
- Publish to YouTube (YouTube): uses YouTube
- Wait: pauses before continuing
- Update YouTube Compliance (HTTP Request): calls an HTTP API
…plus 6 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - HTTP Request
n8n-nodes-base.httpRequest - Wait
n8n-nodes-base.wait - Switch
n8n-nodes-base.switch - YouTube
n8n-nodes-base.youTube - Manual Trigger
n8n-nodes-base.manualTrigger - If
n8n-nodes-base.if
From the author
Quick overview This workflow pulls “to create” YouTube ideas from Google Sheets, uses OpenAI to generate a 14-scene script with voice and image prompts, renders a video via JSON2Video with selected music assets, saves the output URL back to Sheets, and only…