Automate Personalized Video Creation with Pabbly Connect and AI Agents

Learn how to automate personalized video creation using Pabbly Connect, AI Agent, and Google Sheets to streamline your video production process. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Video Automation

To start automating personalized video creation, you need to access Pabbly Connect. First, create your free account by signing up through the provided link. Once you log in, you will be directed to the Pabbly Connect dashboard.

On the dashboard, click on the ‘Create Workflow’ button. You will need to name your workflow; for example, ‘AI Agent for Video Creation’. Select the appropriate folder in your Pabbly account where you want this workflow to be saved and click ‘Create’. This sets the stage for integrating various applications through Pabbly Connect.

2. Setting Up Google Sheets Integration with Pabbly Connect

The first step in your workflow is to connect Google Sheets with Pabbly Connect. In the trigger step, select Google Sheets and choose the trigger event as ‘New or Updated Spreadsheet Row’. This allows the workflow to respond whenever a new row is added or updated.

• Select your Google Sheet containing video topics.
• Copy the webhook URL provided by Pabbly Connect.
• Install the Pabbly Connect Webhooks add-on in Google Sheets.

After installing, go to Extensions > Pabbly Connect Webhooks > Initial Setup. Paste the webhook URL and select the trigger column. This setup ensures that any new data added to your Google Sheet triggers the workflow in Pabbly Connect.

3. Creating the AI Agent to Generate Video Scripts

With the Google Sheets integration complete, the next step is to create an AI agent using Pabbly Connect. After the trigger, add a filter to check the status of the entry. If the status is set to ‘Generate’, the workflow will continue; otherwise, it will halt.

Next, add an action step to connect to OpenAI. Choose OpenAI and set the action event as ‘Chat GPT’. Enter your OpenAI API key to connect your account. Specify the AI model you want to use, for instance, GPT-4 mini, and create a prompt that instructs OpenAI to generate a script based on the topic from your Google Sheet.

4. Generating and Uploading the Video with Hijen

After generating the script using OpenAI, the next step is to send this script to Hijen to create the video. In Pabbly Connect, add an action step for Hijen and select ‘Create an Avatar Video’. Connect your Hijen account by entering the API token.

In this step, you’ll also map the video attributes such as avatar ID, style, and dimensions. After configuring these settings, click ‘Save and Send Test Request’ to generate the video. Following this, add a delay of 10 minutes to allow Hijen to process the video creation.

5. Finalizing the Workflow and Updating Google Sheets

Once the video is generated, you will retrieve the video ID and URL from Hijen within Pabbly Connect. Add another action step for Google Drive to upload the video file. Ensure to map the video URL and specify the folder ID where the video should be uploaded.

Finally, update your Google Sheet with the video link. Add another action step for Google Sheets, selecting ‘Update Row’ or ‘Update Cell Value’. Map the row index and the video link to ensure the correct entry is updated with the video URL.

Conclusion

By following this detailed tutorial, you can effectively automate personalized video creation using Pabbly Connect. This integration streamlines the entire process from generating video scripts to uploading the final product, enhancing your productivity and creativity.