■Overview
This is a flow to update the Google Sheets database with messages posted on Google Chat.
■Recommended for
1. Teams using both Google Chat and Google Sheets
・Those who want to automatically record discussions and decisions made on Google Chat in Google Sheets
・Those managing project progress and tasks using Google Chat and Google Sheets
・Those who want to reduce manual data entry and improve efficiency
2. Those collecting information on Google Chat and analyzing data on Google Sheets
・Those who want to conduct surveys and gather opinions on Google Chat and automatically compile the results in Sheets
・Those who want to visualize collected data in real-time to aid in analysis
■Benefits of using this template
・It eliminates the need to manually transcribe Google Chat messages into Google Sheets, significantly saving time.
・Since posts on Google Chat are reflected in Google Sheets in real-time, you can always keep track of the latest information.
■Notes
・Please link both Google Chat and Google Sheets with Yoom.
・Integration with Google Chat is only possible with Google Workspace. For more details, please refer here. https://intercom.help/yoom/ja/articles/6647336


When a message is sent to a space
When a message with a mention to the bot is sent
When a file is posted to a space
When a row is added
When a row is updated
Send a message
Delete a space
Create a space
Invite a member to a space
Remove member from space
Invite a group to a space
Change a member's role in a space
Send a message to a thread
Reply quoting a message
Update space
Create a direct message space
Send a message with an attachment
Upload an attachment
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
When a message is sent to a space
When a message with a mention to the bot is sent
When a file is posted to a space
Send a message
Delete a space
Create a space
Invite a member to a space
Remove member from space
Invite a group to a space
Change a member's role in a space
Send a message to a thread
Reply quoting a message
Update space
Create a direct message space
Send a message with an attachment
Upload an attachment
When a row is added
When a row is updated
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get sheet names
Apply a formula to a range
Write values to a range
Insert image into a cell
Sort by a specific column
Hide a sheet
Add a note to the specified cells
Insert columns
Delete columns
Write values to multiple columns