Automating Video Creation with Pabbly Connect and Google Generative AI

Learn how to automate video creation using Pabbly Connect, Google Sheets, and Google Generative AI in this detailed step-by-step tutorial. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To start automating video creation, you first need to access Pabbly Connect. Open your browser and search for Pabbly Connect. If you do not have an account, click on the ‘Sign up for Free’ button. This will take only a couple of minutes and provide you with 100 free tasks each month.

If you already have an account, simply click on ‘Sign In’. Once logged in, navigate to the dashboard and select the ‘Create Workflow’ button. Here, you can name your workflow, such as ‘Generate Creator Made Videos Using Google Generative AI’ and choose a folder to save it in.

2. Setting Up the Trigger with Google Sheets

In this section, we will set up the trigger using Google Sheets within Pabbly Connect. The trigger will activate when a new or updated spreadsheet row is detected. Click on the search bar to find Google Sheets and select it as your trigger application.

• Select the trigger event as ‘New or Updated Spreadsheet Row’.
• Copy the webhook URL provided by Pabbly Connect.
• Go to your Google Sheets, and under Extensions, install the Pabbly Connect extension if you haven’t already.

After installation, refresh your sheet and navigate to the Pabbly Connect extension. Open the initial setup and paste the webhook URL. Set your trigger column to the final data column where new video titles will be added. Click on ‘Send Test’ to ensure the setup is working correctly before submitting.

3. Generating Content with Google Generative AI

Next, we will generate video content using Google Generative AI. In Pabbly Connect, add a new action step after your trigger. Search for Google Generative AI and select it as the action application.

• Choose the action event as ‘Generate Content’.
• Connect Google Generative AI with Pabbly Connect by entering the API key you generated from Google AI Studio.
• Set your prompt to create motivational content based on the video title from Google Sheets.

After setting up the action, click on ‘Save and Test’ to generate the content. This will allow you to create tailored motivational quotes for your videos automatically.

4. Creating Video with Creator Mate

Now that we have the content, we will create a video using Creator Mate. In Pabbly Connect, add another action step and select Creator Mate as your application.

Choose the action event as ‘Create Single Render’. Connect Creator Mate with Pabbly Connect using your Creator Mate API key. Select the template ID you want to use for your video.

Fill in the necessary details, including the motivational content generated by Google Generative AI. Click on ‘Save and Test’ to create the video. This step ensures that your video is generated with the correct content and template.

5. Updating Google Sheets with Video Links

Finally, we need to update Google Sheets with the video link generated by Creator Mate. In this last step within Pabbly Connect, add an action step and select Google Sheets again.

Choose the action event as ‘Update Row’. Connect Google Sheets with Pabbly Connect and authenticate your account. Map the row index and the video URL to update the sheet.

After mapping the necessary fields, click ‘Save and Test’. This will ensure that your Google Sheet is updated with the newly created video link and status, completing the automation process.

Conclusion

In this tutorial, we explored how to automate video creation using Pabbly Connect, Google Sheets, and Google Generative AI. By following these steps, you can streamline your video production process and enhance your content marketing strategy.