When an application is submitted via Google Forms, it is automatically recorded in a Google Spreadsheet and a notification is sent to Slack.

■Overview

When a Google Form submission is sent, the response content is automatically registered in any Google Spreadsheet and notified to any Slack channel.

It can be applied to various uses such as surveys and inquiry forms.

‍

■Setup Method

1. Connect each of the Google Form, Google Spreadsheet, and Slack apps with Yoom. (My App Connections)

2. Set the form ID with the trigger "When a form response is submitted" and run the test.

3. Once the test is successful, you can obtain the form response information. Select the information you want to retrieve from the response information using the [＋] button and store it in the output.

* For how to retrieve response content with the Google Form trigger, please refer to the link below.

https://intercom.help/yoom/ja/articles/6807133-google%E3%83%95%E3%82%A9%E3%83%BC%E3%83%A0%E3%83%88%E3%83%AA%E3%82%AC%E3%83%BC%E3%81%A7-%E5%9B%9E%E7%AD%94%E5%86%85%E5%AE%B9%E3%82%92%E5%8F%96%E5%BE%97%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95

4. Use the "Operate Database" operation to add the retrieved information to the spreadsheet with the action to add a record to the Google Spreadsheet. Set it by matching the columns set in the spreadsheet with the read items.

5. Use the Slack "Send a message to a channel" operation to set the extracted information to be sent to the specified channel.

‍‍

■Notes

・Account linking for Google Form, Google Spreadsheet, and Slack is required.

・Please modify the question content of the Google Form and the format of the notification message as needed.