How to Notify Microsoft Teams When a Row is Added in Google Sheets

① My App Integration

First, log in to Yoom and select "My Apps" from the left menu.
After the screen transitions, please press "+ New Connection".

Select the app you want to integrate, and by logging in/signing in according to the screen, the integration will be completed. Once registration is complete, an icon will be displayed in the list of My Apps.

② Copy an Existing Template

Notify Microsoft Teams when a row is added in Google Sheets

You can easily automate using the above template.
First, open My Projects in Yoom and press "+ New Connection".

Next, press "Create from Template Gallery".

In the search box at the top right, enter and search for the template title (Notify Microsoft Teams when a row is added in Google Sheets).
Select "Create Template" in blue text on the right side of the displayed template.

This completes the template copy. If you look closely, you might notice a red "!" displayed on the screen.
Next, proceed with setting each trigger to remove this error mark.

③ Setting the Trigger

First, select "When a row is added" and enter the necessary information to configure the settings.
Please enter the account information (email address) to be linked.

[How to Set]

Please enter the required fields and run the test.
*Supplementary information about the input content is provided below the input field.

• The flowbot will be activated when a row is added to the table (spreadsheet) in the spreadsheet.
• Make sure to enter values from the first row of the sheet.
• If the data size of the sheet exceeds 4MB, an error may occur.
• Do not include empty rows or columns in the table.
• There is a limit to the range of tables that can be set for each plan.

- Free: 500 rows
- Mini: 2,500 rows
- Team: 5,000 rows
- Success: 10,000 rows
- Standard: 5,000 rows
- Pro: 5,000 rows

If there are no issues with the test results, scroll to the bottom of the screen and press "Save".
Then, return to the initial integration flow screen and confirm that the error mark next to "When a row is added" has disappeared.
If the error mark has not disappeared, the settings have not been configured correctly.

Next, configure the settings for "Send a message to chat".
As before, enter the necessary information and configure the settings. Enter the account information (email address) to be linked and press "Next".

[How to Set]

Please enter the required fields and, if necessary, mention information or attachment information.

Chat ID
→ It can be obtained from the target chat page in Teams. For details on how to obtain it, please check here.

Message
→ Please enter any message content with reference to the supplement at the bottom of the input field.

• [Line Break] Please enter <br>.
• [Mention] Please include <at id='{mention ID}'>{mention display text}</at> in the message. Please enter any text for the mention ID and mention display text, and make sure it matches the values entered in the "Mention ID" and "Mention Display Text" forms. Example: <at id='0'>Yoom</at>

• [File Attachment] Please include the file GUID in the message as <attachment id='{file GUID}'></attachment>. You need to upload it to OneDrive in advance and obtain the GUID inside the eTag {}. Example: <attachment id='153fa47d-18c9-4179-be08-9879815a9f90'></attachment>

‍
‍

If you include a mention in the message,
it must match the values entered in the "Mention ID" and "Mention Display Text" forms.
Please configure the following forms as needed.

Once you have completed the input, you can press "Test" to check if it operates correctly.
If there are no issues with the test results, please press "Save" at the bottom of the screen.

Finally, please turn on the trigger setting next to "When a row is added".

This completes the setup for "Notify Microsoft Teams when a row is added in Google Sheets".
Good job!

Summary

Up to this point, we have provided a detailed explanation with images on how to integrate Google Sheets with Microsoft Teams. By setting up automatic notifications to be sent to Microsoft Teams whenever a new row is added to Google Sheets, you can share information with the entire team in real-time, enabling smooth decision-making. Additionally, by customizing the notification content, the notifications themselves can function as a backup of the data, reducing the risk of data loss, which is a great advantage. Even without programming knowledge, you can easily automate integration using Yoom, so please refer to this article and try integrating Google Sheets with Microsoft Teams!

Yoom can also integrate with various other apps, so by exploring the template list below, you might find integration methods that are beneficial for your work.

[Template List by App]
→Google Sheets
→Microsoft Teams