■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.
.avif)
.avif)
.png)
