Contact person: Business Client

Phone:Show

Email:Show

Location: Seongdong-gu, Korea, Republic of

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Subject: Request for Development of n8n Workflow for Automated Sora2 / Sora2 Pro Video Generation

Hello,
I would like to request the development of an automated n8n workflow that generates videos using the Sora2 or Sora2 Pro API based on data stored in Google Sheets.
Below is the full specification for the workflow.

1. Objective

Build an n8n workflow that reads product data from Google Sheets, generates videos via the Sora2/Sora2 Pro API, supports full parallel execution for multiple rows, and stores the resulting videos into Google Drive under product-specific folders.

2. Google Sheets Structure

The workflow should read the following columns:

Column Description
product Product name (used to create folders in Google Drive)
photolink Image URL (used as the reference image)
description Product description (to be used directly in the prompt)
Ideal Customer Target customer profile (used directly in the prompt)
ratio Determines aspect ratio + model (Sora2 vs Sora2 Pro)
general prompt Additional styling or guidance (used exactly as provided)
status ready → generating → completed
Status Logic

When status = ready → workflow automatically starts

When video generation begins → update to generating

When video is finished → update to completed

3. Workflow Requirements
3.1 Trigger

The workflow should trigger automatically when a row’s status field becomes ready.

3.2 Prompt Construction

The workflow must pass the following fields exactly as written, without modification:

description

Ideal Customer

general prompt

These fields should be concatenated into a single prompt string for the Sora2 API request.

3.3 Reference Image Handling (Updated Version)

The workflow must fetch the image from the photolink URL, convert it into a base64-encoded format, and pass this base64 image directly into the reference_image field of the Sora2 API request. The image must be used exactly as provided, without any alterations or transformations.

3.4 Aspect Ratio → Model / Resolution Mapping
ratio Resolution Model
9:16 (Sora2) 720×1280 sora-2
16:9 (Sora2) 1280×720 sora-2
9:16 (Sora2 Pro) 1024×1792 sora-2-pro
16:9 (Sora2 Pro) 1792×1024 sora-2-pro

The workflow must automatically map the ratio value to the correct resolution and model.

4. Parallel Video Generation (Important)

A key requirement:
If multiple rows in Google Sheets are marked as ready (e.g., 10 items),
the workflow must start 10 independent executions simultaneously,
each generating a separate video in parallel.

No queueing unless required by n8n constraints

Each row must run as its own isolated execution

Include retry logic and error handling per row

5. Sora2 API Execution Flow

Update row status → generating

Build the full prompt

Determine model and resolution from ratio

Send the Sora2 API request

Poll for completion until video is ready

Download the final video file

Create a product-named folder in Google Drive (if not existing)

Upload the video to the correct folder

Update row status → completed

If an error occurs, optionally write error to the status field.

6. Google Drive Output Structure
/n8n_sora2_output/
└── {product_name}/
└── {generated_video_files}


Folder must be created automatically if it does not exist.

7. Cost Optimization Requirements

Please implement the workflow with efficiency in mind:

Strategy Explanation
Short video duration (3–6 sec) Minimizes cost per generation
Use reference image Reduces token usage and improves consistency
No rewriting of prompt text Prevents unnecessary token consumption
Full concurrency Reduces wait time and API retry costs
8. Additional Technical Requirements

Include retry logic (minimum 3 attempts)

Configurable polling interval (e.g., every 3 seconds)

Error handling with clear status updates

All API keys and base URLs must be set as environment variables

Workflow should be modular to allow future model/api replacement

Optional: log workflow results into another Google Sheet tab

9. Notes

The initial data was provided in Excel format, but the workflow must be fully implemented using Google Sheets, not Excel.

Please review the above specification and share your development timeline, cost estimate, and any additional information you may need.
I’m open to further adjustments if necessary.

Thank you" (client-provided description)