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

How to Build Workflows with AI in Pabbly Connect | MCP Tutorial

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To get started with integrating Google Sheets and Google Chat, first, access Pabbly Connect. This platform allows you to automate workflows without the need to manually configure every step.

Once logged in, navigate to the dashboard where you can create a new workflow. This is where you will set up the integration between your applications using Pabbly Connect.

2. Setting Up the Workflow in Pabbly Connect

In the Pabbly Connect dashboard, click on the “Create Workflow” option. Here, you can select the integration type. For this tutorial, we will be using Google Sheets and Google Chat.

Choose Google Sheets as the trigger application.
Set the trigger event to “New Row”.
Select Google Chat as the action application.
Set the action event to “Send Message”.

This configuration allows Pabbly Connect to listen for new entries in Google Sheets and send notifications to Google Chat automatically.

3. Connecting Google Sheets and Google Chat

Next, you need to connect Google Sheets to Pabbly Connect. This is done by copying the Webhook URL provided by Pabbly Connect and pasting it into your Google Sheets add-on.

Ensure that you have installed the Pabbly Connect add-on in Google Sheets. Here are the steps to follow:

Open your Google Sheets and go to Extensions > Pabbly Connect Webhooks.
Paste the copied Webhook URL into the designated field.
Set the trigger column to the last column of your data.

Once this is done, your Google Sheets is now connected to Pabbly Connect, ready to send data whenever a new row is added.

4. Testing the Integration with Pabbly Connect

After setting up the connection, it’s crucial to test the integration. Add a new row in your Google Sheets to see if Pabbly Connect triggers a notification in Google Chat.

In your Google Sheets, enter the necessary lead details like name, email, and inquiry. Once you add the row, Pabbly Connect should send this information to Google Chat automatically.

If everything is set correctly, you will receive a message in your Google Chat confirming that the lead details were sent successfully. This confirms that Pabbly Connect is functioning as intended.

5. Finalizing Your Automation Workflow

Once testing is successful, you can finalize your workflow in Pabbly Connect. Make sure to activate the workflow to ensure it runs continuously.

To do this, go back to the Pabbly Connect dashboard and toggle the workflow to “Active”. This will allow the workflow to run automatically whenever a new row is added in Google Sheets.

With this setup, you can now easily manage leads and notifications without manual intervention. The integration between Google Sheets and Google Chat through Pabbly Connect streamlines your communication and enhances productivity.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to automate workflows between Google Sheets and Google Chat. By following the steps outlined, you can streamline your processes effectively.