Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Your Automation

To start your automation journey, first access Pabbly Connect by visiting pabbly.com/connect. Here, new users can sign up for free and get 100 tasks every month, while existing users can log in directly.

Once signed in, navigate to the Pabbly Apps window and click on “Access Now” under Pabbly Connect. This will direct you to the dashboard where you can create workflows for your integrations.

2. Setting Up Your Workflow in Pabbly Connect

In Pabbly Connect, click on “Create Workflow” to begin setting up your integration. Choose the quick builder option for a streamlined process. The workflow layout will appear, prompting you to select an app for your trigger.

  • Select Google Sheets as your trigger app.
  • Choose the trigger event, which should be the webhook URL.
  • Copy the webhook URL provided by Pabbly Connect.

After copying the webhook URL, head to your Google Sheets. This is where you will set up the connection between Google Sheets and Pabbly Connect.

3. Integrating Google Sheets with Pabbly Connect

In Google Sheets, you need to install the Pabbly Connect Webhooks add-on. Click on “Extensions”, then “Add-ons”, and select “Get Add-ons”. Search for “Pabbly Connect Webhooks” and install it.

After installation, refresh your Google Sheets, then go back to “Extensions” and select “Pabbly Connect Webhooks”. Choose “Initial Setup” and paste the webhook URL you copied earlier. Set the trigger column to the final data column, which is typically the last column in your sheet.

  • Input the trigger column, for example, Column E.
  • Click on “Submit” to save your settings.
  • Test the connection by clicking “Send Test”.

Once the test is successful, ensure to turn on the “Send on Event” option in the Pabbly Connect Webhooks settings. This allows automatic data transfer to Pabbly Connect whenever new details are added to your Google Sheets.

4. Generating Video Scripts Using Gemini AI

Next, you will create a connection to Gemini AI within Pabbly Connect. Select “Add a New Connection” and input your API key. If you have already set up your API key, you can choose your existing connection.

In the text column, you will enter a relevant prompt for the AI to generate a script. Instead of manually entering details, utilize the mapping feature to dynamically insert data from the previous steps.

  • Select the model as Gemini 2.5 Flash.
  • Choose the method as “Generate Content”.
  • Click on “Save and Send Test Request” to generate the script.

Once you receive a successful response, you will have a complete video script generated by AI, ready for the next step.

5. Downloading Video and Updating Google Sheets

To finalize the process, you will generate a video from the script using Gemini AI. Again, create a connection in Pabbly Connect and map the script generated by AI as the input.

Click on “Save and Send Test Request” to receive the URI for the generated video. Copy this URI and paste it into a new tab to download your video. Once downloaded, you will need to update your Google Sheets with the video URL.

  • Select the spreadsheet and sheet where you want to add the video link.
  • Specify the range using the column name and row index.
  • Click on “Save and Send Request” to update the sheet.

With this, you have successfully integrated Google Sheets, Gemini AI, and Pabbly Connect to automate the creation of product ad videos!

Conclusion

In this tutorial, we demonstrated how to automate the creation of product ad videos using Pabbly Connect by integrating Google Sheets and Gemini AI. This setup allows for efficient video generation and seamless updates.