How to Send Messages on Google Chat from Google Sheets Using Pabbly Connect

Learn how to automate sending messages on Google Chat from Google Sheets using Pabbly Connect. Follow this step-by-step tutorial for seamless integration. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To send messages on Google Chat from Google Sheets, we will utilize Pabbly Connect. First, visit the Pabbly Connect website and sign in to your account. If you are a new user, you can sign up for free and receive 100 tasks every month.

Once signed in, you will be directed to the Pabbly Connect dashboard. Here, you can create your automation workflow by clicking on the ‘Create Workflow’ button. This is where the integration process begins, enabling seamless communication between Google Sheets and Google Chat.

2. Creating a Workflow in Pabbly Connect

After accessing the dashboard, it’s time to create a new workflow in Pabbly Connect. Name your workflow, for example, ‘Send Message on Google Chat from Google Sheets’. Select a folder to save this workflow, such as ‘Google Chat Automation’.

• Click on the ‘Create’ button to finalize your workflow setup.
• You will see two sections: Trigger and Action.

In this workflow, Google Sheets will act as the trigger application, while Google Chat will be the action application. Setting up these components is essential for the automation to function correctly.

3. Setting Up the Trigger in Pabbly Connect

The next step is to configure the trigger for your workflow using Pabbly Connect. Click on the trigger application and select Google Sheets. Choose the trigger event as ‘New or Updated Spreadsheet Row’. This event will monitor your Google Sheets for any new entries.

After selecting the trigger, Pabbly Connect will provide you with a unique webhook URL. Copy this URL as you will need it to connect Google Sheets to Pabbly Connect. Open your Google Sheet and navigate to Extensions > Add-ons > Get Add-ons to install the Pabbly Connect Webhooks add-on.

• Search for Pabbly Connect Webhooks and install it.
• After installation, go back to Extensions and select Pabbly Connect Webhooks > Initial Setup.

Paste the copied webhook URL into the designated field and set the trigger column to the final data column, which is typically column E. Click ‘Submit’ to complete the setup.

4. Setting Up the Action in Pabbly Connect

Now that the trigger is set, we need to configure the action using Pabbly Connect. Select Google Chat as the action application and choose the action event as ‘Create Message’. This setup will enable Pabbly Connect to send messages to your specified Google Chat space.

To connect Google Chat with Pabbly Connect, you will need the Chat Webhook URL. To obtain this URL, open your Google Chat space, click on the down arrow next to the space name, and select ‘Space Settings’. Navigate to ‘Apps and Integrations’, then click on ‘Webhooks’.

Click on ‘Add Webhook’ and provide a name for the webhook. Copy the generated webhook URL and paste it into Pabbly Connect.

Now, compose the message you want to send. For example, you can write: ‘Welcome our new team member, [First Name] [Last Name].’ Map the fields from Google Sheets to dynamically insert the new employee’s details into the message.

5. Testing the Integration

With both the trigger and action set up in Pabbly Connect, it’s time to test the integration. Fill in the details of a new employee in your Google Sheets, and ensure that the final data column is populated.

After entering the details, return to your Pabbly Connect workflow. If everything is configured correctly, you should see the captured response from Google Sheets. This indicates that the automation is working as intended, and the message should be sent to your Google Chat space.

Open your Google Chat space to verify that the message has been successfully forwarded. If you see the message with the new employee’s details, congratulations! You have successfully set up the integration between Google Sheets and Google Chat using Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to send messages on Google Chat from Google Sheets using Pabbly Connect. By following these steps, you can automate notifications for new employees seamlessly. This integration enhances communication efficiency within your team.