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 That Generates Videos Automatically 🤯

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating Pabbly, Pabk, and Google Sheets, you need to access Pabbly Connect. Open your web browser and go to the Pabbly website. If you are a new user, sign up for a free account.

Once logged in, you will find the dashboard where you can create new workflows. This is where you will set up the integration process for your video automation.

2. Setting Up Google Sheets for Automation

In this section, we will connect Google Sheets to Pabbly Connect. Open your Google Sheets and create a new spreadsheet. This spreadsheet will hold your video ideas and styles.

Create a new spreadsheet.
Add columns for video ideas and styles.
Install the Pabinet WBX add-on from the Google Workspace Marketplace.

After setting up the spreadsheet, refresh it to see the new options under the Extensions menu. This will allow you to configure the necessary settings for the integration.

3. Configuring Pabbly Connect for Google Sheets

Now, let’s configure Pabbly Connect to connect with Google Sheets. Go to the Pabbly Connect dashboard and create a new workflow. Set the trigger to “New Updated Spreadsheet Row” from Google Sheets.

Copy the webhook URL provided by Pabbly Connect and paste it into the initial setup of the Pabinet WBX add-on in Google Sheets. Specify the trigger column where your video ideas will be entered.

Paste the webhook URL in the Pabinet WBX settings.
Set the trigger column to the one where you enter your video ideas.
Submit the settings to configure successfully.

Once configured, you will see a success message indicating that the setup is complete. This allows your Google Sheets to communicate with Pabbly Connect.

4. Generating Video Ideas Using Pabbly Connect

Next, we will generate video ideas using Pabbly Connect and Gemini AI. Enter your video idea and style in the designated columns of your Google Sheet. This will trigger the automation.

When you enter a new idea, Pabbly Connect captures this data and sends it to Gemini AI for video creation. You will receive a response with the video URL in your Google Sheet.

Enter a video idea in the spreadsheet.
Specify the style for the video.
Wait for the video URL to appear in the spreadsheet.

Once the video is generated, you can click on the URL to access and download the video directly from your Google Sheet.

5. Updating Google Sheets with Video Links

Finally, we will update Google Sheets with the video links generated by Pabbly Connect. Use the “Update Cell Value” step in your workflow to send the video URL back to the designated column in your spreadsheet.

Select the appropriate Google Sheet and specify the range where the video link will be updated. This ensures that all team members can access the video without needing direct access to your account.

Select the Google Sheet for updates.
Specify the column for the video URL.
Click “Save and Send Test Request” to finalize the update.

After completing these steps, the video link will automatically appear in your Google Sheet, making the entire process seamless and efficient.

Conclusion

In this tutorial, we demonstrated how to integrate Pabbly, Pabk, and Google Sheets using Pabbly Connect. This setup allows for automatic video generation and updating directly within your spreadsheet, streamlining your workflow effectively.