■Overview
When a Google Form submission is sent, the response content is automatically registered in a specified Excel file and notified to a specified Slack channel.
It can be applied to various purposes such as surveys and inquiry forms.
■Recommended for
1. Those who use Google Forms, Excel, and Slack
2. Those who manage information submitted via Google Forms
3. Those who link Google Form information to Excel
4. Those who want to improve efficiency with Google Forms and Excel
■Benefits of using this template
・Since information submitted via Google Forms can be automatically registered in Excel, centralized management becomes possible.
・Automatic linking reduces work time and transcription errors.
・As soon as there is a response to the Google Form, you will be notified on Slack, allowing you to quickly catch the information.
■How to set up
Link each of the apps Google Forms, Microsoft Excel, and Slack with Yoom. (My App Integration)
Set the form ID with the trigger "When a response is submitted to the form" and run a test.
If the test is successful, you can obtain the form response information, so select the information you want to obtain from the response information with the [+] mark button and store it in the output.
※ For how to obtain response content with the Google Form trigger, please refer to the following.
In the "Operate Database" operation, add the obtained information to the Excel file with the action to add a record to Microsoft Excel. Set the columns set in the Excel file to correspond with the read items.
In the Slack "Send a message to a channel" operation, set it to send the extracted information to a specified channel.
■Notes
・Account linking for Google Forms, Microsoft Excel, and Slack is required.
・Please change the question content of Google Forms and the format of the notification message as needed.



When a form response is submitted
When a message is posted to a channel
When a file is posted to a channel
When a message is posted to a channel (Webhook)
When a reaction is added to a message (Webhook)
When a user is mentioned in a channel
When a message containing specified text is posted to a channel
When your Slack app is mentioned (Webhook)
When mentioned in a channel (multiple users)
When a message containing specified text is posted to a channel (Regular expression)
When a new channel is created (Webhook)
When a message is posted in a thread (Webhook)
When mentioned in a channel (multiple users & user groups)
Get List of Answers
Get Specific Answer Information
Get List of Responses (Specify Response Period)
Get Form Questions
Update Form Title and Description
Update Question Titles and Descriptions
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add Sheet
Change Sheet Name
Retrieve Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Get Item ID
Delete Sheet
When a form response is submitted
Get List of Answers
Get Specific Answer Information
Get List of Responses (Specify Response Period)
Get Form Questions
Update Form Title and Description
Update Question Titles and Descriptions
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add Sheet
Change Sheet Name
Retrieve Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Get Item ID
Delete Sheet
Sort a specified range in ascending or descending order
Unprotect Worksheet
Get Drive Item ID from Sharing URL
Create Excel Session
When a message is posted to a channel
When a file is posted to a channel
When a message is posted to a channel (Webhook)
When a reaction is added to a message (Webhook)
When a user is mentioned in a channel
When a message containing specified text is posted to a channel
When your Slack app is mentioned (Webhook)
When mentioned in a channel (multiple users)
When a message containing specified text is posted to a channel (Regular expression)
When a new channel is created (Webhook)
When a message is posted in a thread (Webhook)
When mentioned in a channel (multiple users & user groups)
Send a message to a channel
Send a direct message
Send a file (Support ends on 11/12)
Get user IDs in a channel
Create a channel
Invite members to a channel
List user groups
Send a message to a thread
Archive a channel
Get messages in a thread
Get a List of Public Channels
Remove a Member from a Private Channel
Search User by Email
Retrieve user information
Get a Specific Message
Get Message Permalink
Delete Message
List users in a user group
Get reactions for a specific message
Create User Group
Send a file to a thread (support ended on 11/12)
Get channel message history
Send a message to a channel with attachments