How to Notify Google Chat When a Row is Added in Google Sheets

[What is Yoom]

How to Create a Workflow Integrating Google Sheets and Google Chat

From here, we will introduce the flow of app integration using Yoom with images!

① My App Integration

First, log in to Yoom and select "My Apps" from the left menu.
After the screen transitions, please click "+ 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 Google Chat when a row is added in Google Sheets

By using the above template, you can easily automate the process.
First, open My Projects in Yoom and click "+ New Connection".

Next, click "Create from Template Gallery".

In the search box at the top right, enter the template title (Notify Google Chat when a row is added in Google Sheets) and search. On the right side of the displayed template, there is a blue text "Create Template", so please select it.

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 eliminate this error mark.

③ Trigger Settings

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

[How to Set]

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

• The flow bot will be activated when a row is added to the table (spreadsheet) in the spreadsheet.
• Please 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, set up "Send a message to space".
Enter the necessary information as before, enter the account information (email address) to be linked, and press "Next".

When the screen transitions, the following screen will be displayed, so fill in all the required fields: "Space ID", "Key", "Token", "Message Content". Additional information about each item is provided directly below the input fields, so please proceed while checking.

Space ID
→The string after "/space/" in the Google Chat URL is the Space ID. Example) AAAA3b8XTvw

Key
→Please enter the string after "key=" in the Webhook URL obtained from "Space Name > Manage Webhooks".

Token
→Please enter the string after "token=" in the Webhook URL obtained from "Space Name > Manage Webhooks". In doing so, please remove the trailing "%3D".

Message Content
→Please set the message content you want to send as desired.

Once you have completed entering the required fields, you can test the output by pressing "Test". If there are no issues with the results, scroll to the bottom of the screen and press "Save" to return to the initial screen.

[Notes]

・You can send messages to a specific space.
・For information on how to set it up, please refer to this manual.
・For information on how to set up mentions, please refer to this manual.

‍

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

This completes all the settings for the "Notify Google Chat when a row is added in Google Sheets" template.
Well done!

Other Automation Examples Using Google Sheets and Google Chat

In addition to the flow introduced this time, you can achieve various business automations by utilizing the APIs of Google Sheets and Google Chat.
All of these can be used with simple settings, so if you find anything interesting, please give it a try!

Other Automation Examples with Google Sheets and Google Chat

You can update Google Sheets after posting on Google Chat or add the content posted in a specific room to Google Sheets.
It is also possible to convert an uploaded CSV into a new Google Sheet and notify Google Chat.

Automation Example Using Google Sheets

Add Content Posted in a Specific Room to Google Sheets

By automating the task of transcribing messages, you can prevent human errors and improve work efficiency.

Extract received information with AI and add it to Google Sheets

By extracting the received content and adding it to Google Sheets, it becomes possible to centrally manage important information from emails.

Delete Registration Information When a Row is Updated in Google Sheets

This is a flow bot that allows you to delete registered information when a row is updated in Google Sheets.

Example of Automation Using Google Chat

Add Post Content When a Message is Sent in Google Chat

By automating the transcription and summarization of messages, manual work becomes unnecessary, allowing for more efficient accumulation of information.

Receive a notification in Google Chat when information is added

When new information is registered, you should be able to perform subsequent tasks smoothly by receiving a notification in Google Chat.

Benefits of Integrating Google Sheets with Google Chat

Benefit 1: Archiving Data Updates

By automatically archiving the update history of data, you can keep a record on Google Chat of when data was added, making it easy to refer back to later.
This is particularly useful for projects involving multiple members.
It allows for clear tracking of project progress and data change history, enabling accurate decisions based on past data and enhancing transparency in operations.
Additionally, in the event of any issues or errors, quick problem resolution is possible by referring to past records.

Benefit 2: Automation of Notifications

Automating notifications not only saves the effort of sending notifications manually but also prevents missed notifications and time lags, reducing human error.
Furthermore, notifications can be customized, allowing you to set them based on specific conditions so that you only receive the necessary information.
This ensures that important information is not missed, enabling quick responses and contributing to overall speed and productivity improvement in operations.
Automating notifications also helps reduce daily work burdens, creating an environment where you can focus on more strategic tasks!

Conclusion

This article provided a detailed explanation with images on how to set up notifications in Google Chat when a row is added in Google Sheets.
With this automated integration, updates in Google Sheets can be instantly shared on Google Chat, preventing delays and omissions in information sharing.
It is easy to set up using Yoom, making it an ideal option for those who want to try automating tasks without coding.
We encourage you to use this article as a reference and challenge yourself to integrate Google Sheets with Google Chat!