Skip to main content

Generate Sora videos from Google Sheets and save results to Google Drive

Workflow preview

Workflow preview
100%
Generate Sora videos from Google Sheets and save results to Google Drive preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

Generate Sora AI videos, save to Google Drive, and update Google Sheets This workflow automates video generation using OpenAI's Sora model: How it works: 1. Reads video prompts from a Google Sheet ...

Best for

  • Content Creation automation workflows
  • Multimodal AI automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.googlesheets, @n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmchatopenai, n8n-nodes-base.httprequest, n8n-nodes-base.wait, n8n-nodes-base.googledrive, n8n-nodes-base.stickynote, @n8n/n8n-nodes-langchain.outputparserstructured

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Sona Labs.

Original n8n.io source

1.1 Workflow description

Title
Generate Sora videos from Google Sheets and save results to Google Drive
Workflow name
Generate Sora videos from Google Sheets and save results to Google Drive

Generate Sora AI videos, save to Google Drive, and update Google Sheets

This workflow automates video generation using OpenAI's Sora model:

How it works:

  1. Reads video prompts from a Google Sheet
  2. Submits each prompt to Sora API for video generation
  3. Monitors video creation status with automatic retry logic
  4. Generates SEO-optimized titles using GPT-4
  5. Downloads completed videos and uploads to Google Drive
  6. Updates the sheet with video URLs and status

Setup Steps:

  1. Create a Google Sheet with columns: PROMPT, DURATION (In Seconds), VIDEO RESOLUTION, VIDEO TITLE, VIDEO URL, STATUS
  2. Add your OpenAI API key (with Sora access) to credentials
  3. Connect your Google Sheets and Google Drive accounts
  4. Update the sheet ID in all Google Sheets nodes
  5. Run the workflow manually to process all unprocessed rows

Requirements:

  • OpenAI API key with Sora access
  • Google Sheets OAuth2 credentials
  • Google Drive OAuth2 credentials#Header 4

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Get Video Prompts from Sheet

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 2 - Generate SEO Title with AI

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 2.1

Block 3 - GPT-4 Model

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenAi - lmChatOpenAi
Config choices
Version 1.2

Block 4 - Create Sora Video Job

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 5 - Wait 60s for Rendering

Type / Role
n8n-nodes-base.wait - wait
Config choices
Version 1.1

Block 6 - Check Video Status

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 7 - Download Completed Video

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 8 - Upload to Google Drive

Type / Role
n8n-nodes-base.googleDrive - googleDrive
Config choices
Version 3

Block 9 - Update video status to failed

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 10 - Add video URL and update video status

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 11 - Sticky Note1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 12 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 13 - Sticky Note3

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 14 - Structured Output Parser

Type / Role
@n8n/n8n-nodes-langchain.outputParserStructured - outputParserStructured
Config choices
Version 1.3

Block 15 - Filter Unprocessed Videos

Type / Role
n8n-nodes-base.filter - filter
Config choices
Version 2.2

Block 16 - Normalize Video Parameters

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 17 - Route by Video Status

Type / Role
n8n-nodes-base.switch - switch
Config choices
Version 3.2

Block 18 - Manual Trigger

Type / Role
n8n-nodes-base.manualTrigger - manualTrigger
Config choices
Version 1

Block 19 - Sticky Note5

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 20 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

3. Summary Table

Workflow Generate Sora videos from Google Sheets and save results to Google Drive
Complexity advanced
Nodes 20
Categories Content Creation, Multimodal AI
Author Sona Labs
Published 29 Dec 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/12287/12287.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Generate Sora videos from Google Sheets and save results to Google Drive do?

Generate Sora AI videos, save to Google Drive, and update Google Sheets This workflow automates video generation using OpenAI's Sora model: How it works: 1. Reads video prompts from a Google Sheet ...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Content Creation, Multimodal AI use case.