How to Add Content Posted in a Specific Room on Google Chat to Google Sheets

[What is Yoom]

How to Create a Workflow Integrating Google Chat and Google Sheets

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

① My App Integration

After logging into Yoom, select "My Apps" from the left menu.

After the screen transition, please click "+ Add".

‍

‍

Enter the name of the app you want to integrate in the search box, and follow the on-screen instructions to log in or sign in to complete the integration.
This time, we will register "Google Chat" and "Google Sheets".
Once registration is complete, icons will appear in the list of My Apps.

② Copy an Existing Template

This completes the template copy. A popup will appear, so press OK.
From here, proceed with the settings mainly on the "!" part on the screen as guided.

‍

‍

‍

③ Setting the Trigger

First, select "When a message is sent to the space" and check the settings.

Enter the account information to be linked and press "Next".

‍

‍

Then, you will transition to the following screen, so please read the precautions carefully and proceed with the settings.

‍

‍

Scroll down to find the output section.

This output can be used in the subsequent Google Sheets settings, but it will not be used in this explanation.

Press "Save" to return to the initial screen.

‍

‍

④ Setting the Integration App

The middle flow "Extract Data from Text" is already set, so skip it.

For the settings of "Data Extraction (2 Tasks)" using AI, please check this page.

Next, select "Add Record" and enter the account information to be linked.

‍

‍

Scroll down to find the
"Database Integration" section, and enter the information referring to the notes below the input field.

‍

‍

‍

Press "Next" to transition to the following screen,
and enter all the information referring to the input example in the image.
* You can use the output by clicking on the input field.

‍

‍

In the detailed settings, you can set errors and intervals.
Set them as needed.
If there are no issues, press "Save" to return to the initial screen.

‍

‍

Then, the following popup will appear, so press "Turn on Trigger".

If the trigger ON at the top of the initial screen looks like the image, it's OK!

‍

‍

‍

This completes the setup for "Add content posted to a specific room in Google Chat to Google Sheets".

Good job!

Examples of Other Automations Using Google Chat and Google Sheets

There are many examples of automation using Google Chat and Google Sheets available on Yoom, so here are a few introductions.
All of them can be used with simple settings, so if you find something interesting, please give it a try!

Examples of Automation Using Google Chat and Google Sheets

Integrate with AI tools to notify chat tools of data reading and storage

This is a flow bot that uses AI to read information and notifies when data is stored using OCR.

Automation Example Using Google Chat

Notify Chat Tool When Posted on Google Chat

By notifying messages posted on Google Chat to another communication tool, it is expected to enhance team collaboration.

Notify Google Chat when a task is added

By receiving notifications in a Google Chat space, it is expected that stakeholders will find it easier to keep track of the tasks created.

‍

Automation Example Using Google Sheets

Retrieve Information from Google Sheets and Add Events to a Calendar App

This is a flow bot that retrieves information from Google Sheets and adds events to a calendar app.

Add a record to Google Sheets when an event is registered

When an event is registered, the registration information can be automatically added to Google Sheets, which should help streamline manual tasks.

Create a Folder When a Row is Added in Google Sheets

This is a flow bot that automatically creates a folder by integrating with a storage service.

Benefits of Integrating Google Chat with Google Sheets

Here are two benefits of integrating Google Chat with Google Sheets.

Benefit 1: Data Analysis and Visualization

By setting up Google Chat to add posts from specific rooms to Google Sheets, data analysis and visualization become easier. For example, if a sales team shares daily activity reports on Google Chat, the content can be automatically aggregated into Google Sheets, allowing centralized data management.

Based on this data, you can use Google Sheets' pivot tables and chart features to visually analyze each sales representative's performance or understand sales trends, enabling quick feedback and guidance. The ability to visualize data makes it easier to create specific action plans, which is a key advantage of this integration.

Benefit 2: Improved Work Efficiency

For example, in project management, you can set it up so that when members report progress or task completion in Google Chat, the information is automatically reflected in Google Sheets.

This allows managers to quickly grasp project progress and prevent missed or delayed progress reports. Additionally, centralizing information reduces redundant work and verification tasks among members, leading to improved overall work efficiency.

Conclusion

This article explained, with images, how to automatically add content posted in specific rooms to Google Sheets by integrating Google Chat with Google Sheets. This integration allows for centralized management of sales team activity reports and project progress, as data is automatically aggregated. Furthermore, the collected data can be used for analysis and visualization, making performance reviews and feedback more efficient. By using Yoom, you can easily integrate apps without any coding, enabling anyone to effortlessly automate their tasks.

Use this article as a reference and try integrating Google Chat with Google Sheets!