# Let's Build a Sora AI Influencer with Zapier Source: https://www.youtube.com/watch?v=7BQqjIH5aJQ Recap page: https://rapidrecap.app/video/7BQqjIH5aJQ Generated: 2025-11-10T19:06:39.435+00:00 --- ## Quick Overview The tutorial successfully demonstrates how to automate OpenAI's Sora video generation using Zapier by scheduling hourly prompts via ChatGPT's API request endpoint and saving the resulting video download links to a Google Sheet, ensuring content is created automatically without watermarks. **Key Points:** - The core automation workflow triggers hourly using Zapier's Schedule by Zapier tool to initiate content creation. - ChatGPT (OpenAI) is used in the workflow to generate dynamic, niche-specific prompts for Sora video creation via an API Request (Beta) action. - The API request uses the POST method to OpenAI's v1/videos endpoint, specifying the 'sora-2-pro' model for higher quality output. - A filter step ensures the automation only proceeds if the webhook event type is 'video.completed', ignoring failures. - The final step uses Google Sheets' 'Create Spreadsheet Row' action to log the resulting video download URL from the API response into a designated spreadsheet column. - The generated Sora videos are confirmed to be watermark-free, and the final output link is successfully logged in the Google Sheet upon completion. ![Screenshot at 00:12: The presenter displays the OpenAI documentation overview for the Sora API, highlighting the ability to create, iterate on, and manage videos using the API.](https://ss.rapidrecap.app/screens/7BQqjIH5aJQ/00-00-12.png) **Context:** This video provides a practical, step-by-step tutorial on integrating OpenAI's cutting-edge Sora video generation model with Zapier to create an automated content pipeline. The presenter builds a 'Zap' that runs hourly, uses ChatGPT to create varied prompts, calls the Sora API directly, and then logs the final download link into a Google Sheet, effectively creating an automated social media content generation system. ## Detailed Analysis The tutorial outlines the creation of an automated workflow using Zapier to generate videos with OpenAI's Sora model on an hourly basis. The process begins by setting up a trigger using Schedule by Zapier to run 'Every Hour' (01:27). The first action utilizes ChatGPT (OpenAI) via an 'API Request (Beta)' (01:40) set to POST to the 'https://api.openai.com/v1/videos' endpoint. The payload specifies the 'sora-2-pro' model, a dynamically generated prompt from the previous step, a 720x1280 size, and a 4-second duration (02:37-03:53). Following the API call, a Filter by Zapier step (07:28) is added to ensure the workflow only continues if the webhook event 'Type' is exactly 'video.completed' (07:45), thus preventing failed video attempts from proceeding. If the video completes successfully, the final action uses Google Sheets 'Create Spreadsheet Row' (08:55) to log the video download URL, which is dynamically mapped from the 'Data Id' field within the webhook response (08:21). The demonstration confirms that the resulting video files lack watermarks (10:25) and the entire system successfully generates content hourly, placing the download link in the Google Sheet for subsequent publishing across social media platforms. ### Zap Setup and Scheduling - Creating a new Zap folder named 'Sora Influencer' (00:45) - Setting the trigger as 'Schedule by Zapier' to run 'Every Hour' (01:28) - Adding a subsequent ChatGPT step for prompt generation (04:17) ### Sora API Request Configuration - Using ChatGPT's 'API Request (Beta)' action with HTTP Method POST to the v1/videos endpoint (01:51-02:25) - Setting the body to include model='sora-2-pro', dynamic prompt input from ChatGPT, size='720x1280', and seconds='4' (02:56-03:53) ### Webhook Trigger Setup - Adding a Webhooks by Zapier 'Catch Hook' trigger (06:33) to listen for completion or failure events from OpenAI (07:06-07:13) - Copying the generated webhook URL (06:41) ### Filtering Logic - Implementing a Filter by Zapier step to only continue if the webhook event 'Type' exactly matches 'video.completed' (07:41-07:51) - Testing the filter shows that 'video.completed' passes while 'video.failed' is blocked (07:47) ### Final Action - Google Sheets Logging - Adding a Google Sheets 'Create Spreadsheet Row' action (08:55) - Mapping the video download URL dynamically from the webhook's 'Data Id' field into the 'Download Video' column in the Google Sheet (09:05-09:08) ### Results and Verification - Testing the final step confirms the URL is correctly passed (09:09) and the resulting video file plays without watermarks (10:25) ![Screenshot at 00:00: Presenter holding up an iPhone showing a dark social media profile screen.](https://ss.rapidrecap.app/screens/7BQqjIH5aJQ/00-00-00.png) ![Screenshot at 00:12: The OpenAI Webcafe interface displaying examples of Sora-generated videos and the 'Video generation with Sora' title.](https://ss.rapidrecap.app/screens/7BQqjIH5aJQ/00-00-12.png) ![Screenshot at 00:20: The Zapier landing page promoting its AI agents and orchestration platform, which sponsors the video.](https://ss.rapidrecap.app/screens/7BQqjIH5aJQ/00-00-20.png) ![Screenshot at 00:38: The Zapier interface showing the 'Zaps' section where the user creates a new folder named 'Sora Influencer'.](https://ss.rapidrecap.app/screens/7BQqjIH5aJQ/00-00-38.png) ![Screenshot at 01:04: The initial Zap workflow structure showing the Schedule trigger followed by an Action step.](https://ss.rapidrecap.app/screens/7BQqjIH5aJQ/00-01-04.png) ![Screenshot at 01:17: The Zapier app selection menu, where the user searches for and selects 'Schedule by Zapier' for the trigger step.](https://ss.rapidrecap.app/screens/7BQqjIH5aJQ/00-01-17.png) ![Screenshot at 02:24: The API Request configuration in Zapier, showing the specific URL endpoint for video retrieval: 'https://api.openai.com/v1/videos/{data\_id}/content'.](https://ss.rapidrecap.app/screens/7BQqjIH5aJQ/00-02-24.png) ![Screenshot at 03:03: A screenshot of the OpenAI API Pricing page detailing costs for 'sora-2' models, with 'sora-2-pro' costing $0.50 per second for 1024x1024 resolution.](https://ss.rapidrecap.app/screens/7BQqjIH5aJQ/00-03-03.png) ![Screenshot at 04:13: The Zap workflow after adding the ChatGPT Conversation step to generate the dynamic prompt for Sora.](https://ss.rapidrecap.app/screens/7BQqjIH5aJQ/00-04-13.png) ![Screenshot at 07:32: The Webhook Endpoint configuration in the OpenAI Dev Portal, showing that the webhook is subscribed to 'video.completed' and 'video.failed' events for the Zapier URL.](https://ss.rapidrecap.app/screens/7BQqjIH5aJQ/00-07-32.png)