How to Send Channel Messages in Microsoft Teams when Row is Added in Google Sheets Using Pabbly Connect

Learn how to automate sending channel messages in Microsoft Teams when a new row is added in Google Sheets using Pabbly Connect. Follow our step-by-step guide.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start the integration process using Pabbly Connect, first visit the Pabbly website by navigating to Pabbly.com. This platform will enable you to automate sending messages in Microsoft Teams whenever a new row is added in Google Sheets.

Once on the Pabbly homepage, you will see options for signing in or signing up. If you don’t have an account, you can sign up for free, which includes 100 tasks per month. After logging in, locate the ‘Create Workflow’ button to begin your automation setup.

2. Setting Up the Workflow in Pabbly Connect

After clicking on the ‘Create Workflow’ button in Pabbly Connect, name your workflow something descriptive like ‘Google Sheets to Microsoft Teams’. This will help you identify the workflow later. Pabbly Connect will present you with two sections: Trigger and Action.

• Select Google Sheets as the Trigger Application.
• Choose the Trigger Event as ‘New or Updated Spreadsheet Row’.
• Copy the provided Webhook URL for later use.

These steps will set up the trigger that activates whenever a new row is added or updated in Google Sheets. After copying the Webhook URL, proceed to configure Google Sheets.

3. Configuring Google Sheets with Pabbly Connect

To connect Google Sheets with Pabbly Connect, open your Google Sheets document where you want to track customer issues. Click on the ‘Extensions’ menu, then navigate to Pabbly Connect Webhooks and select ‘Initial Setup’. Paste the previously copied Webhook URL here.

For the Trigger Column, select column D, as this will be the column that triggers the message when updated. After pasting the URL and selecting the trigger column, send a test to confirm the connection. You should see a success message indicating that the test data has been sent successfully to Pabbly Connect.

4. Sending Messages to Microsoft Teams

Now that Google Sheets is configured, return to Pabbly Connect to set up the action step. Select Microsoft Teams as the Action Application and choose the action event ‘Send Message in a Channel’. This will allow you to send a message to a specific channel in Teams whenever a new row is added.

Connect your Microsoft account to Pabbly Connect. Once connected, you will see a list of your Teams. Choose the appropriate team and channel where you want to send the notifications. For the message, you can customize it as follows:

• ‘Hello team, our customer [Customer Name] has reported an issue. Kindly look into it. Further details are as follows: Contact Number: [Contact Number], Email: [Email]’

This message will dynamically pull the customer’s details from Google Sheets and send them to the specified Microsoft Teams channel. After framing your message, save and send a test request to ensure everything is working correctly.

5. Finalizing the Integration

Once you have successfully sent a test message to Microsoft Teams, your integration using Pabbly Connect is complete. Make sure to return to Google Sheets and click on ‘Send on Event’ under Pabbly Connect Webhooks to ensure that it captures all future data.

After this setup, every time a new row is added or updated in your Google Sheets, a message will automatically be sent to your selected Microsoft Teams channel. This automation saves time and ensures that your team is always informed about customer issues.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to send channel messages in Microsoft Teams whenever a new row is added in Google Sheets. By following these steps, you can automate notifications and streamline your workflow efficiently.