Send Notification in Microsoft Teams When New Row Added in Shared Google Sheets Using Pabbly Connect

Learn how to send notifications in Microsoft Teams when a new row is added in a shared Google Sheet using Pabbly Connect. Step-by-step tutorial included.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Integration

To send notifications in Microsoft Teams when a new row is added in a shared Google Sheet, we will use Pabbly Connect. First, sign in to your Pabbly Connect account and click on the ‘Create Workflow’ button. Name your workflow, such as ‘Send Notifications in Microsoft Teams for New Row in Google Sheets’. This initial setup is crucial for integrating the two applications.

Once you create the workflow, you will see two major modules: Trigger and Action. The trigger will be set to Google Sheets because it will activate when a new row is added or updated. The action will be configured to send a message in Microsoft Teams. This setup establishes the foundation for the automation process using Pabbly Connect.

2. Configuring Google Sheets Trigger in Pabbly Connect

Next, we need to configure the Google Sheets trigger in Pabbly Connect. Select the event ‘New or Updated Spreadsheet Row’. This action will provide a webhook URL, which acts as a bridge between Google Sheets and Pabbly Connect. Copy this URL as it will be used later to connect Google Sheets.

• Go to Google Sheets and click on ‘Extensions’.
• Select ‘Add-ons’, then ‘Get Add-ons’ to find Pabbly Connect Webhooks.
• Install the Pabbly Connect Webhooks add-on.

After installing, go to ‘Extensions’ again, select ‘Pabbly Connect Webhooks’, and choose ‘Initial Setup’. Here, paste the copied webhook URL and specify the trigger column, which is the last updated column in your Google Sheet. Click ‘Submit’ to save the settings. This step ensures that whenever a new row is added, the data will be sent to Pabbly Connect.

3. Sending Notifications to Microsoft Teams via Pabbly Connect

With the Google Sheets trigger configured, it’s time to set up the action to send notifications to Microsoft Teams using Pabbly Connect. Select the action event ‘Send Message in a Channel’. This action will allow you to send a notification to your desired Teams channel whenever a new row is added.

Next, connect your Microsoft Teams account to Pabbly Connect. The connection type will automatically detect your account. After granting access, select the team name and the channel where you want to send the message. Customize your message by including details from the Google Sheet, such as the title of the task and the editor’s name.

• Choose the team name from Microsoft Teams.
• Select the channel, typically ‘General’.
• Draft a message that includes task title and editor’s name.

Once your message is ready, click ‘Save and Send Test Request’. This will send a test notification to your Microsoft Teams channel, confirming that the integration works correctly. Check your Teams channel to verify the message was sent successfully.

4. Testing the Integration Between Google Sheets and Microsoft Teams

After setting up the integration in Pabbly Connect, it’s essential to test that everything works as expected. Go back to your shared Google Sheet and add a new row with the required details, including the title, editor’s name, and any other relevant information. Once you press enter, this action should trigger the workflow.

Head to your Microsoft Teams channel and check for the notification. You should see a message indicating that the spreadsheet has been updated, along with the title and the editor’s name. This confirms that the integration is functioning correctly and that Pabbly Connect is successfully relaying the information from Google Sheets to Microsoft Teams.

5. Conclusion

In this tutorial, we demonstrated how to send notifications in Microsoft Teams when a new row is added in a shared Google Sheet using Pabbly Connect. By following the steps outlined, users can automate their workflow efficiently, ensuring timely updates and communication within their teams.

With Pabbly Connect, integrating various applications like Google Sheets and Microsoft Teams becomes seamless, allowing for enhanced productivity and collaboration.