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

Google Sheets is a tool widely used by many companies for easy data management and sharing.
By integrating Google Sheets with Google Chat, you can enable real-time information sharing and smooth communication within your team.
This article not only discusses the benefits of integrating Google Sheets and Google Chat but also introduces the flow of app integration using Yoom, which allows for centralized app management without any coding!

Please read to the end.

Recommended for

Those who utilize Google Sheets and Google Chat
Those considering integrating Google Sheets and Google Chat to improve daily work efficiency
Those who want to streamline information sharing related to management data by integrating Google Sheets and Google Chat
Those who want to achieve a speedy sharing process by integrating Google Sheets and Google Chat

For those who want to try it immediately

This article introduces the integration method using the no-code tool "Yoom".
No complicated settings or operations are required, and even non-engineers can easily achieve it.
You can also start immediately using the template below, so please give it a try!

[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 "+ Add".

‍

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

Click "Try it" on a template to copy it!

Now, let's get started with the setup.

③ 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.

‍

‍

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/update when posted on Google Chat

This saves you the trouble of transcribing Google Chat messages, saving you time.

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!