Automate bulk stock video production with n8n and the Sora 2 API

Cinematic Stock Video Prompt Example

Preparing Google Sheets for Bulk Data

1. Open Google Sheets and create a new file.
2. Set up a header in the first row with the columns: 'Video Name', 'Prompt', and 'Status'.
3. Fill in your list of video ideas and prompts in the subsequent rows.
4. Ensure the 'Status' column is left blank for n8n to update later.

Configuring Trigger and Google Sheets Nodes in n8n

1. Any n8n workflow begins by clicking the '+' button to add a new node.
2. Search for and select the 'Google Sheets' node.
3. Select 'Get Many' under the Operation section.
4. Connect your Google account via the 'Credential' menu.
5. Enter the 'Spreadsheet ID' found in your Google Sheets URL.
6. Click 'Execute Node' to ensure n8n can successfully read your prompt list.

Connecting n8n to the OpenAI Sora 2 API

1. Add an 'HTTP Request' node after the Google Sheets node.
2. Set the Method to 'POST'.
3. Enter the API endpoint URL for Sora 2 (Refer to official OpenAI documentation).
4. In the Authentication section, select 'Header Auth' and enter your API Key as 'Authorization: Bearer YOUR_API_KEY'.
5. In the Body Parameters section, select 'JSON'.
6. Use an 'Expression' to map the 'Prompt' column from Google Sheets to the 'prompt' field in the API request body.
7. Click 'Execute Node' to send the video generation command.

Auto-Download and Save Videos to Google Drive

1. Add a 'Wait' node if the API needs time to process the video, or use a second 'HTTP Request' node to poll the video status.
2. Once the API returns the video URL, add a new 'HTTP Request' node with the 'GET' method to download the video binary file.
3. Add a 'Google Drive' node after the download node.
4. Select the 'Upload' Operation.
5. Choose your destination folder in Google Drive.
6. Map the binary file from the previous step into the 'File Content' input.
7. Click 'Execute Node' to automatically save the video.