◼️Overview
We will build a system that adds inquiry details entered in a form to a Google Spreadsheet and simultaneously notifies Google Chat.
You can automate information management by adding the form contents to a specified Google Spreadsheet that you regularly use.
Additionally, by notifying Google Chat of the form responses and the addition to the Google Spreadsheet, it is possible to consistently accumulate and share information.
◼️Notes
・Integration with Google Chat, Google Spreadsheet, and Yoom is required.
・Feel free to change the settings of the integrated Google Spreadsheet as needed.
・Integration with Google Chat is only possible with Google Workspace. For details, please refer to here.


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
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy 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
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Information
Get Sheet Names
Repeat Formula
Input Values into Range
Embed Image in Cell
Sort by Specific Column
Hide Sheet
Add Note to Specified Cell
Add Column
Delete Columns