Automate Video Creation with Pabbly Connect and Google AI

Learn how to automate video creation using Pabbly Connect, Google Sheets, and Google AI. Follow this step-by-step tutorial for seamless integration. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To start automating video creation, access Pabbly Connect by visiting the official website. If you don’t have an account, click on ‘Sign Up for Free’ to create one. This process only takes a few minutes and grants you 100 free tasks each month.

Once logged in, navigate to the dashboard. Here, you will create a new workflow that connects Google Sheets, Google AI Studio, and Creator Mate. Start by clicking on the ‘Create Workflow’ button, which will prompt you to name your workflow. Select the folder where you want to save it, and then click ‘Create’ to proceed.

2. Setting Up the Trigger with Google Sheets

The first step in your workflow is to set up a trigger using Google Sheets. In Pabbly Connect, select Google Sheets as your trigger application. You will then need to choose the trigger event, which should be ‘New or Updated Spreadsheet Row’. This action will initiate the workflow every time a new title is added to your Google Sheet.

• Search for Google Sheets in the trigger application.
• Select the trigger event as ‘New or Updated Spreadsheet Row’.
• Connect Google Sheets with Pabbly Connect using the provided webhook URL.

After setting up your trigger, ensure that you copy the webhook URL provided by Pabbly Connect. This URL will bridge the connection between Google Sheets and Pabbly Connect, allowing data to flow seamlessly.

3. Generating Content Using Google AI

Next, you will set up an action step to generate content for your video using Google AI Studio. In Pabbly Connect, select Google AI as your action application. Choose the action event as ‘Generate Content’. This step will leverage the title from your Google Sheet to create motivational content automatically.

• Connect Google AI with Pabbly Connect by entering your API key.
• Map the title from Google Sheets as the prompt for content generation.
• Select the AI model you wish to use for generating content.

Once you have configured the connection and mapped the necessary fields, click on ‘Save and Test’ to ensure that the content is generated correctly. This content will be used in your Creator Mate video template.

4. Creating Videos with Creator Mate

The final action in your workflow involves creating the video using Creator Mate. In Pabbly Connect, select Creator Mate as your action application. Choose the action event ‘Get Specific Template’ to retrieve your video template.

Connect Creator Mate with Pabbly Connect by entering your API key. This key can be obtained from your Creator Mate account under Project Settings. After connecting, select the appropriate template ID that you will use for your video creation.

Next, you will set up another action step to create a single render using the selected template. Map the content generated by Google AI into the template. Once all details are configured, click ‘Save and Test’ to generate the video. This video will be created automatically based on the content and template you specified.

5. Updating Google Sheets with Video Links

After generating the video, the last step is to update your Google Sheet with the video link. In Pabbly Connect, select Google Sheets again as your action application. Choose the action event ‘Update Row’ to modify the existing row with the new video link.

Connect Google Sheets with Pabbly Connect and map the relevant fields, including the row index and the video URL. Once you have configured this action, click ‘Save and Send Test Request’ to ensure the update is successful.

After completing this step, check your Google Sheet to confirm that the new video link and status have been updated correctly. This integration allows you to automate the entire video creation process, ensuring efficiency and timely content delivery.

Conclusion

In this tutorial, you learned how to automate video creation using Pabbly Connect, Google Sheets, and Google AI. By following these steps, you can streamline your content production process, enabling you to generate personalized videos effortlessly.