Run Sora2 on Google Sheets! Streamline Video Production with Sora2Gen

Run Sora2 on Google Sheets! Management Tool [Sora2Gen] for Streamlining Video Production - Early Release!

OpenAI's groundbreaking video generation AI "Sora2" API has been released, allowing anyone to generate high-quality videos from programs. However, using the API directly can be a bit challenging for those unfamiliar with programming, as it involves waiting for asynchronous processing to complete and managing numerous generated video files.

Therefore, we at AICU AIDX Lab have developed a tool that allows you to operate the Sora2 API using Google Sheets as the command center, which many people are familiar with on a daily basis, to make this video generation process more accessible and efficient. This time, we will introduce its detailed functions and usage.

Your Spreadsheet Becomes Your Video Generation Studio

This tool allows you to manage video generation jobs intuitively from your spreadsheet by simply installing Google Apps Script in your Google Sheet, without the need for complex command-line operations or specialized development environments.

Let's take a closer look at the main features and how they can benefit you.

Centralized Prompt Management and Idea Accumulation:
1. Simply write prompts in the job queue sheet, and your idea book becomes a video generation instruction manual. Parameters such as model (sora-2 / sora-2-pro), size, and video length can also be managed in a list, making it ideal for team brainstorming and sharing past success patterns.
Generate Videos While You Sleep, Fully Automated Batch Processing:
1. The biggest feature is the ability to execute multiple prompts entered in the job queue sheet in batch with a single click from the menu. You can queue 10 prompts before going to bed, and have 10 videos completed in the morning.
Liberation from File Management, Automatic Saving to Google Drive:
1. The generated videos (MP4), as well as thumbnail images and sprite sheets for easy preview, are automatically organized and saved in the specified Google Drive folder. Furthermore, shareable links are automatically recorded in the execution log sheet, so you no longer have to search for "Where did I save that video?"
Progress at a Glance, Status Management with Automatic Updates:
1. The status of executed jobs (pending, processing, completed, failed) is managed with color-coding in the execution log sheet. Furthermore, if you enable the schedule function, the progress will be automatically updated every minute while you are working on other tasks, and completed jobs will be marked in green.
Full Support for Advanced API Functions:
1. In addition to generating videos from text, it also supports image2video (specifying image URL) to give instructions like "Make a video from this image" and remix (specifying existing video ID) to make fine adjustments like "I want to change only the color of the previous video" with simple input on the sheet.

Detailed Usage Guide

We will explain in detail the steps from tool installation to the completion of your first video in 4 steps.

Step 1: Initial Setup (approx. 3 minutes, only once)

First, install the script in your spreadsheet and configure it to use the API.

Script Installation:
1. First, open a new Google Spreadsheet. Select "Apps Script" from the "Extensions" menu at the top.
2. Copy and paste all of the script code we provide into the displayed editor and save it.
Executing the Settings Menu:
1. Return to the spreadsheet and reload the page to display the 🎬 Sora2 Video Generation Tool custom menu. Click ⚙️ Settings & API Test from the menu.
Entering API Key and Folder ID:
1. Follow the instructions in the displayed dialog box and enter the OpenAI API key and the Google Drive folder ID where the videos will be saved in order. The folder ID is the end part of the URL when you open the corresponding folder in Google Drive.
Final Confirmation:
1. The setup is complete when "API connection test successful" is displayed. Reload the spreadsheet once to display the menu with all the functions available.

Step 2: Job Input (Create a Video "Order Form")

Enter the information for the video you want to generate in the job queue sheet.

Column A (Request Type): Select one of text2video (from text), image2video (from image), or remix (from existing video).
Column B (Prompt): Enter a specific description of the video you want to create. This is where your creativity comes into play!
Column C (Input Image URL): For image2video, paste the image URL here.
Columns E～G: Select the model, size, and video length from the drop-down menu.
Background color of column A: Make sure that the background color of newly added rows is white (no color). This is the marker for "unprocessed".

Step 3: Execution (Place a Video Generation "Order")

Click ▶️ Batch Execute Job Queue from the menu.

If successful: The rows in the job queue sheet that were being processed (rows with a white background) disappear, and the job ID and queued status are recorded in the execution log sheet.
If failed: The row does not disappear and column A turns red, and the reason such as "Drive folder ID is invalid" is displayed in the final error column. Correct the error and return the background color of column A to "white (none)", and it will be subject to execution again.

Step 4: Confirmation (Receive the Completed Video)

Check the progress of the job in the execution log sheet.

It takes several minutes to generate the video. Manually execute 🔄 Refresh Execution Log from the menu, or enable 🕒 Run update check every minute to wait for it to be updated automatically.

When the status becomes completed, the background of the row turns green, and the link to the completed video is written in the "Video URL" column. Click to enjoy the moment when your idea takes shape!

Recommended for:

Marketers and creators who want to efficiently create many short videos for SNS posts, etc.
Developers and researchers who want to try various expressions using the Sora2 API.
Those who are not good at command-line operations but want to experience the power of the Sora2 API.
Teams who want to share video generation ideas and results while progressing with projects.

AI Halloween Contest is also being held!

Tool (Google Apps Script) and Installation Instructions

The installation of the "Sora2 API x Google Sheets Collaboration Tool" introduced this time is completed in the following 2 steps.

Step 1: Copy the script

First, copy the entire Google Apps Script code from the following link.

⭐️AICU AIDX Lab - Sora2 API Google Sheets Tool (Script v3.0) [Insert GitHub Gist URL here]

Step 2: Installation to Spreadsheet

Create a new Google Spreadsheet with your Google account. (It is convenient to enter sheets.new in the browser's address bar)
Select "Apps Script" from "Extensions" in the top menu to open the script editor.
Delete all the code initially written in the editor, such as function myFunction() { ... }.
Paste the entire script code you copied earlier into the empty editor.
Click the floppy disk icon (Save project) at the top to save the script.
Return to the spreadsheet tab and reload (refresh) the browser.

Installation is now complete!

You should see a custom menu called 🎬 Sora2 Video Generation Tool on the sheet.

Then, start setting up from step 1 of the "Detailed Usage Guide" section of this article.

We hope this tool will help you further accelerate your creativity. Please use it and send us your feedback.

AICU AIDX Lab is engaged in research and development of image generation systems, video generation systems, content development, character IP development, interactive systems, and copyright resolution technology. Currently, we are looking for researchers and partner companies due to business expansion. Please feel free to contact us.

AI Halloween Contest is being held!

Deadline is October 13, 2025!

Use it to help you produce music videos!!

Tools and Installation Instructions are here

The Google Apps Script code and detailed installation instructions introduced this time can be found at the following link.