When there is a response to the survey in the form, add the response content to a Google Spreadsheet, send a notification to Slack, and send a thank you email.

No items found.

◼️Overview

When a survey response is submitted to the Yoom form, the information is accumulated in a Google Spreadsheet, and notifications and emails are sent to the chat.

With just the form responses, it is possible to accumulate data, share it in chat, and send thank-you emails.

◼️Preparation

・It is necessary to register (link) with the apps you will use in advance.

・The following is a reference guide for linking.

・For apps that can be linked easily, there may not be a detailed guide available. https://intercom.help/yoom/ja/collections/3041779

・Prepare a spreadsheet in advance to accumulate application information.

・The spreadsheet used for accumulation (view-only access). If you want to use it, please copy it from here.

◼️Creation Method

① Select the form trigger, configure the following settings, and save.

・Each question item: Set necessary items such as name, contact information, address, and question content for the survey form.

・Obtained values: You can enter demo values on the next page. Please enter demo values as they will be used in the subsequent test.

※ For details on form settings, please refer to here.

② Press the + mark under the trigger, select Slack from the operations to link with the app, configure the following settings, and test and save.・Action: Send a message to the channel

・Click the field for the channel ID to post to, and select the channel you want to send to from the displayed options.

・Message: Enter any message. You can also embed the values obtained in ① as shown below. (Embed the output)

※ For embedding the output, please refer to here.

-----

A survey response has been received. Name: {{Name}}

NPS: {{Would you recommend this product to your friends or company?}}

Reason: {{Please tell us the reason for the above answer.}}

Request: {{If you have any requests for future services, please let us know.}}

-----

③ Press the + mark, select the operation to send an email, choose any email tool, configure the following settings, and save.

・To: Embed if the address was obtained in ①.・Subject, Body: Enter each. You can also embed the values obtained in ① as shown below.

・Attachment: Select to use the output, and choose the issued document as the value.

※ For details on the operation to send an email, please refer to here.

-----

{{Name}}様

Thank you for responding to the survey.

We will send a thank-you gift to the address you provided below, so please look forward to it.

{{Address}}

-----

④ Press the + mark, select Google Spreadsheet from the operations to manipulate the database, configure the following settings, and test and save.・Execute action: Add a record・

Click the field for Spreadsheet ID, and select the prepared spreadsheet from the options.

・Click the field for the spreadsheet tab name, and select the target sheet from the options.

・Table range: Enter the target range including column names. In this example, it is set to A1:G.

・Values of the record to be added: Use the output obtained in ① to embed corresponding values in the displayed column names.

・If there is a column for a sent email flag, you can enter a fixed value like "Sent" by manually entering predetermined text.

※ For the definition of the table range in Google Spreadsheet, please refer to here.

How to request materials and apply for a demo
Here
More flowbot templates
Here are some Similar Templates!
Record the contents of the inquiry form in a Google Spreadsheet.
The content submitted through the inquiry form will be recorded in a spreadsheet, and a reply email will be sent automatically. The spreadsheet can include not only the inquiry details but also the reception date and time, as well as the sender's information.‍
Read business card data using AI-OCR and store it in Google Sheets.
When you upload business card data to the form, the AI operation automatically extracts the necessary information from the business card, stores it in a Google Spreadsheet, and sets up a workflow to automatically send an email to the specified recipients.‍
When a schedule is added to Google Sheets, register it in Google Calendar as well.
When an event is added to Google Sheets, this flow retrieves that information and registers the event in Google Calendar as well. By adding information to Google Calendar along with the registration in Google Sheets, it reduces manual operations and prevents missing information additions.
When employee information is added to Google Sheets, register it in HRMOS.
This is a flow for registering employee information in HRMOS when it is added to Google Sheets. By using the registered employee information to register in HRMOS, it reduces manual time. Additionally, using the quoted content prevents human error.‍
When there is a response to the form, add the information to a Google Spreadsheet and send a notification on LINE.
When there is a response to the inquiry form, the information will be added to a Google Spreadsheet and a notification will be sent to the LINE chat room.‍
Add a record to kintone when a row is added in Google Sheets.
This is a flow where a record is added to kintone when a row is added in Google Sheets. Once information is added, the registration to kintone can also be automatically completed based on the added content, eliminating the need for manual input and ensuring the accuracy of the content.‍
See all templates
What is Yoom hyperautomation?
Conventional RPA can only automate simple repetitive tasks, and the setup process was very complicated.
With “hyperautomation,” which combines various technologies such as AI, API, RPA, and OCR, it is possible to automate many tasks that could not be realized until now more easily than before.
Don't Just Connect Apps—Automate Everything
Most tools simply connect one app to another, leaving the complex tasks to you. Yoom goes much further: From document creation and browser automation to OCR and generative AI, Yoom handles it all seamlessly in one platform.

Why settle for basic integrations? Streamline your entire workflow with Yoom’s powerful hyperautomation.
Learn more about Yoom
About the Apps You Use
Google Sheets
Google Sheets
 Templates using
Slack
Slack
Templates using
Gmail
Gmail
Templates using
About the apps you use
Google Sheets
At Yoom, you can utilize the Google Sheets API without any coding. By integrating Sheets with Yoom, you can automate data entry into spreadsheets and automatically create documents based on spreadsheet templates. Additionally, you can sync spreadsheet information with Yoom's database for various applications.
see details
templates
Slack
Yoom allows you to utilize Slack's API without any coding. By integrating Yoom with Slack, you can freely connect various SaaS with Slack and receive all kinds of notifications on Slack. Additionally, it is possible to trigger a bot when a message is sent to Slack.
see details
templates
Gmail
Yoom allows you to integrate with Gmail's API without code and automate email sending from Gmail. You can automatically create and send invoices and contracts via Gmail, or automatically reply to inquiries.
see details
templates
API Actions That can be No-Code
Executable API actions
Flowbot triggers
    Flowbot operations
      Flowbot triggers
        Flowbot operations
          Flowbot triggers
            Flowbot operations
              Flowbot triggers
                Flowbot operations
                  Work Smarter 
                  with Yoom
                  Get started in
                  30 sec!
                  Try for free now!
                  Try for free now!
                  How to request materials and apply for a demo
                  Here
                  See Details