No-Code Automated AI Video Creation Using Google Sheets and HeyGen

Learn how to automate AI video creation using Google Sheets and Pabbly Connect in this detailed step-by-step tutorial. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect to Start Automation

To begin automating AI video creation, first access Pabbly Connect by visiting pabby.com. This platform is essential for integrating Google Sheets with HeyGen for video generation.

Upon reaching the Pabbly Connect website, you can either sign in or sign up for a free account. Existing users should click on the ‘Sign In’ button, while new users can opt for the ‘Sign Up for Free’ option to get started. This allows you to utilize the platform’s features and explore automation capabilities.

2. Creating a Workflow for Video Automation

Once logged into Pabbly Connect, navigate to the dashboard where you can create a new workflow. Click on the ‘Create Workflow’ button, select the option to build from scratch, and then name your workflow as ‘No-Code Automated AI Video Creation Using Google Sheets and HeyGen’.

After naming your workflow, you will be prompted to select a folder. Choose an appropriate folder for your workflow and click on ‘Create’. This sets up the foundation for your automation process.

3. Setting Up Google Sheets as the Trigger Application

In this step, you will set Google Sheets as the trigger application in Pabbly Connect. This means that any new data added to your Google Sheets will initiate the workflow. Select Google Sheets as your trigger app and choose the event ‘New or Update Spreadsheet Row’.

Next, connect Pabbly Connect to your Google Sheets account. A webhook URL will be generated, which acts as a bridge between Google Sheets and Pabbly Connect. You will need to copy this webhook URL for later use in your Google Sheets.

• Open your Google Sheets and navigate to Extensions > Add-ons > Get Add-ons.
• Search for Pabbly Connect Webhooks and install it.
• Refresh your Google Sheets after installation.

After setting up the Pabbly Connect Webhooks add-on, go back to Extensions, select Pabbly Webhooks, and click on Initial Setup. Here, paste the webhook URL you copied earlier and specify the trigger column as the final data column. This ensures that when data is added to that column, the entire row data will be sent to Pabbly Connect.

4. Configuring HeyGen as the Action Application

Now that Google Sheets is set up, it’s time to configure HeyGen as the action application in Pabbly Connect. This means that once a new row is added to Google Sheets, HeyGen will automatically generate a video based on the provided data.

First, click on ‘Add New Action Step’ and select HeyGen. Choose the action event as ‘Create Avatar Video’. Connect your HeyGen account by entering the API token, which you can find in your HeyGen account settings under API.

• Enter the avatar ID, avatar style, input text, voice ID, caption, width, and height.
• Map the fields to ensure dynamic input from Google Sheets.

After entering all necessary details, click on ‘Save and Send Test Request’. This will initiate the video creation process in HeyGen, facilitated by Pabbly Connect.

5. Adding Delay and Retrieving the Generated Video

Since video generation takes time, you need to add a delay in your workflow using Pabbly Connect. Click on ‘Add New Action Step’ and select Delay as the action application. Set the delay duration to 15 minutes to allow the video to be generated.

After setting the delay, add another action step to retrieve the video from HeyGen. Select HeyGen again and choose the action event as ‘Retrieve Video’. Connect your account and map the video ID received from the previous step.

Click ‘Save and Send Test Request’ to check the status of the video. Once the status indicates ‘Completed’, you will receive a video URL that you can use to view the generated video. This entire process is seamlessly managed through Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to automate AI video creation using Google Sheets and HeyGen through Pabbly Connect. By following these steps, you can efficiently generate personalized videos based on spreadsheet data, showcasing the power of automation in your workflows.