Watch Step By Step Video Tutorial Below
1. Accessing Pabbly Connect for Video Creation
To start creating animated videos, you first need to access Pabbly Connect. This powerful automation tool allows you to integrate various applications seamlessly.
Once logged into your Pabbly Connect account, you can create a new workflow. This will serve as the foundation for connecting Google Sheets and Google AI Studio for video generation.
2. Setting Up Google Sheets Integration with Pabbly Connect
In this step, we will set up Google Sheets to work with Pabbly Connect. Start by selecting the trigger event as “New or Updated Spreadsheet Row” in your workflow.
- Select Google Sheets as the app.
- Choose the trigger event.
- Connect your Google account.
- Select the spreadsheet you want to monitor.
After setting this up, you need to copy the Webhook URL provided by Pabbly Connect and paste it into the Google Sheets add-on for the Pabbly Connect Webhooks.
3. Configuring the Webhook URL in Google Sheets
Once you have the Webhook URL, go to your Google Sheets, navigate to Extensions, and select Pabbly Connect Webhooks. Here, you will set up the Webhook URL.
Make sure to specify the trigger column where you will enter your prompts. For example, if you enter your prompts in column B, set this as your trigger column. After submitting, ensure you enable the “Send on Event” option to capture new entries automatically.
4. Generating Video Using Google AI Studio
After configuring Google Sheets, you will need to set up an action step in Pabbly Connect to generate videos using Google AI Studio. Select “Google AI Studio” as the action app and choose the text-to-video generation action.
To connect to Google AI Studio, you will need to provide an API key. You can obtain this key from the Google AI Studio playground. Once you have the API key, paste it into the connection field in Pabbly Connect.
5. Updating Google Sheets with the Video Link
After the video is generated, you need to update your Google Sheets with the video link. In Pabbly Connect, add another action step for Google Sheets, selecting “Update Cell Value” as the action.
Specify the spreadsheet and the cell where the video link should be updated. Use the mapping feature to dynamically insert the video link generated by Google AI Studio into your specified cell.
Once you complete this step and test the connection, your Google Sheets will automatically update with the video link every time you enter a new prompt. This automated workflow demonstrates the power of Pabbly Connect in simplifying video creation.
Conclusion
In this tutorial, we explored how to use Pabbly Connect to integrate Google Sheets with Google AI Studio for automated video creation. By following these steps, you can easily generate engaging animated videos with minimal effort.



