Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Automation

To start integrating Google Sheets with Google Chat, you need to access Pabbly Connect. Open your browser and navigate to pabby.com/connect. If you are a new user, click on “Sign Up for Free” to create an account. This allows you to explore the software with 100 free tasks each month.

If you already have an account, simply sign in. Once logged in, you will see the Pabbly Apps window. Here, click on “Access Now” under Pabbly Connect to reach the dashboard where you can create your automation workflows.

2. Creating a Workflow with Pabbly Connect

After accessing Pabbly Connect, you need to create a new workflow. Click on the “Create New Workflow” button. You can select the Quick Builder method for ease of use. This method allows you to set up your automation quickly.

  • Choose a Trigger App: Select Google Sheets as your trigger application.
  • Set the Trigger Event: Choose the event that will initiate the workflow, such as “New Row Added”.
  • Copy the Webhook URL: This URL will connect Google Sheets to Pabbly Connect.

Once you have completed these steps, you will be ready to set up the connection between Google Sheets and Pabbly Connect.

3. Setting Up Google Sheets with Pabbly Connect

Now, log into your Google Sheets account and open the spreadsheet where you want to track data. To connect this sheet with Pabbly Connect, you need to install the Pabbly Connect Webhooks add-on. Go to “Extensions”, select “Add-ons”, and then click on “Get Add-ons”.

Search for “Pabbly Connect Webhooks” in the Google Workspace Marketplace and install it. After installation, refresh your Google Sheets window. You will now see the Pabbly Connect Webhooks option under Extensions. Click on it and select “Initial Setup”.

  • Paste the Webhook URL copied from Pabbly Connect.
  • Set the Trigger Column: Choose the column that will trigger the webhook when new data is added.
  • Click on Submit to finish the setup.

Once you see a success message, your Google Sheets is now connected to Pabbly Connect.

4. Sending Data to Google Chat via Pabbly Connect

Next, to send notifications to Google Chat when new data is added to Google Sheets, you need to set up the action step in Pabbly Connect. Choose Google Chat as the action app and select the appropriate action event, such as “Send Message”.

To get the Google Chat Webhook URL, navigate to your Google Chat space, click on the space name, and select “Space Settings”. Here, go to “Apps and Integrations” and add a new webhook. Name it and copy the generated URL.

  • Paste the Google Chat Webhook URL in Pabbly Connect.
  • Map the fields: Use data from the trigger step to populate the message fields.
  • Click on “Save and Send Request” to send the test message.

After completing these steps, you will receive a notification in your Google Chat space confirming that the integration is successful.

5. Conclusion: Automating Notifications with Pabbly Connect

In this tutorial, we successfully demonstrated how to integrate Google Sheets with Google Chat using Pabbly Connect. By following the steps outlined, you can automate notifications for any new data added to your Google Sheets.

This integration not only saves time but also ensures that your team is instantly informed about updates. With Pabbly Connect, you can easily create various automations tailored to your business needs.

Start using Pabbly Connect today to streamline your workflows and enhance communication within your team!