Automate Video Creation with Pabbly Connect and Google Sheets

Learn how to automate video creation using Pabbly Connect with Google Sheets and Hijen. Follow this step-by-step guide for seamless integration. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Automation

To automate video creation using Pabbly Connect, start by signing up for a free account. This platform will serve as the central hub for integrating Google Sheets with Hijen. Once registered, access the Pabbly Connect dashboard and create a new workflow.

In the dashboard, click on ‘Create Workflow’, name it (e.g., ‘Google Sheets to Hijen’), and select a folder for your automation. This setup is crucial as it allows Pabbly Connect to manage the data flow between the applications.

2. Connecting Google Sheets to Pabbly Connect

Next, you need to connect your Google Sheets to Pabbly Connect. In the trigger window, select Google Sheets as your app and choose the event as ‘New or Updated Spreadsheet Row’. This action will allow Pabbly Connect to detect any new entries made in your Google Sheet.

• Select the specific Google Sheet you want to monitor.
• Copy the webhook URL provided by Pabbly Connect.
• Paste the webhook URL into the Google Sheets add-on for Pabbly Connect.

After setting up the webhook, test the connection by entering a new row in your Google Sheet. This step ensures that data is successfully sent to Pabbly Connect, allowing the automation to proceed.

3. Creating Videos Using Hijen through Pabbly Connect

Once Google Sheets is connected, the next step involves sending the data to Hijen to create the video. In the action window of Pabbly Connect, select Hijen and choose the action event ‘Create Avatar Video’. This action allows the automation to generate a personalized video based on the text input provided in Google Sheets.

To configure this, connect your Hijen account by entering the API token. After connecting, you will need to select the avatar and style for the video. Here’s how:

• Select the avatar you want to use from the dropdown list.
• Map the input text and avatar style from Google Sheets.
• Set any additional parameters like voice ID and captions based on your preferences.

After mapping all necessary fields, click on ‘Save and Send Test Request’ to check if the video is created successfully.

4. Updating Google Sheets with Video URL

After creating the video, the next step is to update the Google Sheet with the video URL. In the action step of Pabbly Connect, select Google Sheets again and choose ‘Update Cell Value’ as the action event. This will allow you to insert the generated video link back into the corresponding row of your Google Sheet.

Connect your Google Sheets account and specify the spreadsheet and sheet where the video URL needs to be updated. Here’s how to do it:

Select the correct spreadsheet from your Google Sheets account. Map the range where the video URL should be placed. Insert the video URL received from Hijen into the designated cell.

Once all details are filled, click ‘Save and Send Test Request’ to ensure the video URL is updated correctly in your Google Sheet.

5. Testing the Automation Workflow

To finalize your setup, it’s essential to test the entire automation process using Pabbly Connect. Enter new text content into your Google Sheet, ensuring to select the status as ‘Generate’. This action will trigger the workflow, sending the data through Pabbly Connect to Hijen, which will create the video.

Monitor the automation in Pabbly Connect’s history section to verify that each step is executed correctly. After approximately 15 minutes (or your set delay), check your Google Sheet for the updated video URL. If successful, the video will be available for download and viewing.

This comprehensive testing ensures that the automation is functioning as intended, allowing you to streamline your video creation process efficiently.

Conclusion

This tutorial demonstrates how to automate video creation using Pabbly Connect with Google Sheets and Hijen. By following the detailed steps, you can streamline your workflow and save time on video production tasks.