Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

Build a Gemini AI Agent to Create Videos from Google Sheets 🤯

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start using Pabbly Connect, visit pabbly.com/connect. This platform facilitates the integration of various applications like Google Sheets and Gemini for video generation.

Once on the site, log in or sign up for a free account. You’ll receive 100 free tasks each month, allowing you to test the integration process. This is a great way to explore how Pabbly Connect can streamline your workflow.

2. Setting Up Google Sheets with Pabbly Connect

After logging into Pabbly Connect, you’ll need to set up a trigger with Google Sheets. This step is crucial as it will capture new video ideas entered into your spreadsheet.

Follow these steps to set up Google Sheets:

Open Google Sheets and create a new spreadsheet.
In the extension menu, go to Add-ons and search for Pabbly Connect Webhooks.
Install the Pabbly Connect Webhooks add-on.

Once installed, refresh the spreadsheet and navigate to the Pabbly Connect Webhooks option to begin the initial setup. This ensures that your Google Sheets can communicate with Pabbly Connect.

3. Configuring the Webhook in Google Sheets

Now that you have set up Google Sheets, you need to configure the webhook URL provided by Pabbly Connect. This step is essential for sending data from Google Sheets to Gemini.

Here’s how to configure the webhook:

Copy the webhook URL from your Pabbly Connect dashboard.
In the Google Sheets add-on, paste the webhook URL into the designated field.
Specify the trigger column where you will enter your video ideas.

After completing these steps, click the submit button to finalize the setup. You should see a confirmation message indicating that the setup was successful. This means your Google Sheets is now linked to Pabbly Connect.

4. Generating Video Using Gemini via Pabbly Connect

With your Google Sheets now connected to Pabbly Connect, it’s time to generate your video using Gemini. This step involves mapping the data from Google Sheets to Gemini.

To generate a video, follow these steps:

In Pabbly Connect, select the Gemini application and add a new connection.
Enter your API key from your Gemini account.
Map the video prompt and style from your Google Sheets data.

Once everything is set, click on the ‘Save and Send Test Request’ button. Within seconds, Gemini will generate the video based on your input, and you will receive a video URL.

5. Updating Video URL in Google Sheets

After generating the video, you will want to update your Google Sheets with the video URL. This final step ensures that anyone with access to the spreadsheet can view the generated video.

To update the video URL:

In Pabbly Connect, select Google Sheets and choose the option to update cell value.
Select the spreadsheet and specify the column and row where the video URL should be added.
Map the video URL received from Gemini into the appropriate field.

After completing these steps, click the ‘Save and Send Test Request’ button. The video URL will now be updated in your Google Sheets automatically, making it easy for you to access your generated videos.

Conclusion

In this tutorial, we explored how to integrate Google Sheets with Gemini using Pabbly Connect. This powerful automation tool allows you to generate videos automatically from text prompts, streamlining your workflow significantly.