Automate Video Creation Using Pabbly Connect and Google Sheets

Learn how to automate video creation using Pabbly Connect with Google Sheets. Step-by-step tutorial for seamless integration and video generation. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

Setting Up Pabbly Connect for Video Automation

To start using Pabbly Connect for automating video creation, you first need to create a free account. Once your account is set up, navigate to the Pabbly Connect dashboard and click on ‘Create Workflow’. Here, you will name your workflow, for example, ‘Google Sheets to Hijen’.

After naming your workflow, select the folder where you want to store it and click on ‘Create’. This action opens a new window with two sections: the trigger and action windows. The trigger will be your Google Sheets integration, and the action will be to create a video using Hijen.

Integrating Google Sheets with Pabbly Connect

The next step involves setting up the Google Sheets integration within Pabbly Connect. In the trigger step, search for ‘Google Sheets’ and select it. Choose the trigger event as ‘New or Updated Spreadsheet Row’. This setup allows Pabbly Connect to monitor your Google Sheets for any new entries.

• Select the appropriate Google Sheet where you will input your video content.
• Copy the webhook URL provided by Pabbly Connect.
• Go to Google Sheets, navigate to Extensions > Add-ons > Get Add-ons, and search for ‘Pabbly Connect Webhooks’.

After installing the add-on, refresh your Google Sheets. Go to Extensions > Pabbly Connect Webhooks and click on ‘Initial Setup’. Here, you will enter the webhook URL, select the sheet, and define the trigger column. After completing these steps, click on ‘Send Test Request’ to ensure everything is configured correctly.

Setting Up Filter Conditions in Pabbly Connect

Next, you will set up filter conditions in Pabbly Connect to control when videos are generated. Scroll down to the action step and select ‘Filter’. Set the filter condition to check if the status of the entry is ‘Generate’. This ensures that only entries marked for video generation will proceed through the workflow.

After setting the filter, click on ‘Send Test Request’ to confirm that the filter is correctly identifying entries with the status ‘Generate’. If the condition is true, you can proceed to the next step, which is sending the data to Hijen to create the video.

Creating Video Using Hijen Through Pabbly Connect

In this step, you will connect Hijen to Pabbly Connect to generate the video. Click on ‘Add Action Step’ and search for Hijen. Select the action event as ‘Create Avatar Video’. You will need to connect your Hijen account by entering the API token, which can be found in your Hijen account settings.

Once connected, map the required fields such as Avatar ID, Avatar Style, and Input Text from the previous steps. Make sure to enable the mapping feature to pull data directly from your Google Sheets. After setting up all fields, click on ‘Save and Send Test Request’ to initiate video creation.

Updating Google Sheets with the Video URL

After the video is generated, you need to update your Google Sheets with the video URL. In Pabbly Connect, add another action step and select Google Sheets again. This time, choose the action event as ‘Update Cell Value’. Connect your Google Sheets account if you haven’t already done so.

Select the spreadsheet and the specific sheet where you want to update the video URL. Map the cell range to the column where the video link will be stored. Finally, map the video URL received from Hijen and click on ‘Save and Send Test Request’ to complete the process. Your Google Sheet will now display the link to the generated video.

Conclusion

Using Pabbly Connect, you can automate the process of video creation from Google Sheets seamlessly. This integration allows you to save time and effort while generating personalized video messages for your clients. By following the steps outlined, you can set up this automation easily and efficiently.