Is the workflow free to use?

n8n is free to self-host; you only pay for the OpenAI API calls and any Google service usage.

What credentials do I need?

Google Sheets and Google Drive OAuth plus an OpenAI API key.

Download the JSON file and use the Import button in n8n.

Generate AI Videos with Sora2 Pro, Save to Google Drive and Upload to YouTube

Verified

Automates AI video creation with OpenAI and file management via Google Sheets and Drive.

n8nAI & LLMBeginner👁 17 views

Open template

Updated 2026-06-15

What this workflow does

This automation manages video generation from spreadsheet prompts using OpenAI models and stores outputs in Google Drive.

It is designed for users who need a spreadsheet-controlled pipeline for AI content creation and cloud file handling.

Who is this for?

YouTubers, content creators, and small marketing teams who manage video production through spreadsheets and want hands-off AI video publishing.

What problem it solves

Creating AI videos from text prompts, saving files, and publishing them requires repetitive manual work across multiple tools and APIs.

Live workflow preview

Interactive canvas of every node and connection — scroll and click to explore. Powered by n8n's preview.

Open the template on n8n to import and run it. View source template →

What it automates

Weekly YouTube series

A creator adds 5 new prompts to a Google Sheet each Monday; the workflow generates videos overnight and uploads them without further input.

Product demo automation

A marketing team logs short product prompts in a shared sheet; videos are produced and stored in Drive for review before publishing.

Batch content testing

A solo creator tests multiple prompt variations by filling rows in the sheet and lets the workflow handle generation and storage.

How the workflow works

The 4 nodes in this automation, in order.

1Google SheetsgoogleSheets
2HTTP RequesthttpRequest
3Google DrivegoogleDrive
4OpenAI@n8n/n8n-nodes-langchain.openAi

Apps & integrations used

Google SheetsHTTP RequestGoogle DriveOpenAI

How to set up Generate AI Videos with Sora2 Pro, Save to Google Drive and Upload to YouTube

1Import the workflow JSON into n8n and open the editor.
2Create a Google Sheet with columns PROMPT, DURATION, VIDEO and connect it via the Google Sheets node.
3Add your OpenAI API key to the HTTP Request node that calls Sora2 Pro.
4Configure the Google Drive node with the folder where generated videos should be saved.
5Set the trigger to Manual or Schedule and test with one row of sample data.
6Add the conditional check node to update the VIDEO column once generation completes.

How to customize this workflow

→Change the trigger from Manual to Schedule for daily or weekly runs.
→Swap the OpenAI HTTP call for another video model endpoint if needed.
→Add a notification step after Drive upload to alert a Slack channel.
→Extend the sheet with extra columns for title or tags and pass them downstream.