When there is a response to the survey in the form, add the response content to the Google Spreadsheet.

No items found.

■Overview

‍When a survey response is submitted on Yoom's form, the information is added to a Google Spreadsheet.

You can centralize the collection of form responses and data.

‍

■Preparation

・It is necessary to register (link) your app with the app you will use in advance. Below is a reference guide for linking.

※There may not be a detailed guide available for apps that can be linked in a simplified manner. https://intercom.help/yoom/ja/collections/3041779

・Prepare a spreadsheet in advance to accumulate application information.

※The spreadsheet used for accumulation (view-only access. Please copy if you wish to use it.) https://docs.google.com/spreadsheets/d/1S-ENG6XntHgcwsNeUh6wJ5OVML8Sy_ZPYZTkH-PzMDQ/edit#gid=0

‍

■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 here. https://intercom.help/yoom/ja/articles/8009267

‍② Press the + mark under the trigger, select Google Spreadsheet from the operations to manipulate the database, configure the following settings, and test/save.

・Execution action: Add a record.

・Spreadsheet ID: Click the field and select the pre-prepared spreadsheet from the options.

・Spreadsheet tab name: Click the field and select the target sheet from the options.

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

・Values of the record to be added: Embed the output obtained in ① corresponding to the displayed column names. (Embedding the output)

※For embedding the output, please refer here. https://intercom.help/yoom/ja/articles/8223528

‍※For the definition of the table range in Google Spreadsheet, please refer here. https://intercom.help/yoom/ja/articles/8703465

このテンプレートを試してみる

How to request materials and apply for a demo

Here

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.‍

See details

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.‍

See details

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.

See details

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.‍

See details

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.‍

See details

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 details

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.

Learn more about Yoom

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