How to Generate Creatomate Videos from Google Sheets Using Pabbly Connect

Learn how to automate video creation with Creatomate and Google Sheets through Pabbly Connect in this step-by-step tutorial. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Google Sheets Integration

To begin generating Creatomate videos from Google Sheets, the first step is to access Pabbly Connect. Sign in to your Pabbly Connect account, where you will find a dashboard that displays all available applications. This platform will facilitate the automation process between Google Sheets and Creatomate.

Once logged in, click on the big blue button labeled ‘Create Workflow’. Name your workflow, for instance, ‘Generate Creatomate Videos from New Google Sheet Rows’. After creating the workflow, you will see two sections: Trigger and Action, where you can set the steps for your automation.

2. Configuring Google Sheets Trigger in Pabbly Connect

In the Trigger section of Pabbly Connect, select Google Sheets as your trigger application. The event you want to choose is ‘New or Updated Spreadsheet Row’. This will ensure that every time a new row is added or an existing row is updated in your Google Sheet, it will trigger the workflow.

• Select Google Sheets as your trigger application.
• Choose the event: New or Updated Spreadsheet Row.
• Copy the webhook URL provided by Pabbly Connect.

Next, go back to your Google Sheet, click on Extensions, then Add-ons, and install the ‘Pabbly Connect Webhooks’ add-on if you haven’t already. Once installed, go to the Pabbly Connect Webhooks option in the Extensions menu, select Initial Setup, and paste the webhook URL there. Set the trigger column to the last column you want to track data from.

3. Creating Videos with Creatomate via Pabbly Connect

After configuring the trigger in Pabbly Connect, the next step is to add an action to create a video using Creatomate. Select Creatomate as your action application and choose the event ‘Create Single Render’. This action will render a video based on the details provided in your Google Sheet.

Before creating the video, you will need to get the template details. Choose the action event ‘Get Specific Template’ and connect it to your Creatomate account using your API key. You can find this key in your Creatomate account settings under Project Settings.

• Select the template you want to use for rendering the video.
• Map the text fields from your Google Sheet to the corresponding keys in the template.
• Click on Save and Send Test Request to generate the video.

Once the video is generated, you will receive a URL link to the created video. This link can be used to view or share your video.

4. Updating Google Sheets with Video Links

The final step in this automation process involves updating your Google Sheet with the URL of the newly created video. In Pabbly Connect, add another action step and select Google Sheets again. Choose the action event ‘Update Row’ to map the video link back to your Google Sheet.

In this step, you will select the spreadsheet and the specific sheet you are working on. Map the necessary fields, including the row index and the video link you received from the previous step. After mapping these details, click on Save and Send Test Request to complete the update.

Upon successful execution, your Google Sheet will now contain the link to the Creatomate video, allowing you to access it directly from the sheet. This automation saves time and ensures that your video links are always updated in real-time.

5. Conclusion: Automate Video Creation with Pabbly Connect

In this tutorial, we have explored how to generate Creatomate videos from Google Sheets using Pabbly Connect. By following the steps outlined, you can automate video creation efficiently and effectively. This integration not only streamlines your workflow but also enhances productivity by eliminating manual processes.

With Pabbly Connect, you can easily connect various applications and create powerful automations tailored to your needs. Start leveraging the capabilities of Pabbly Connect today and transform your data into engaging videos effortlessly.