Integromat
  • Back to website
Articles in this section
  • Formstack
  • Magento 2
  • Google Cloud Vision
  • ManyChat
  • Airtable
  • Bubble
  • Email (legacy)
  • Facebook Groups
  • Google Sheets (legacy)
  • HTTP
See more
  1. Integromat Support
  2. Apps
  3. Docs

Google Forms (legacy)

Integromat Support Team Integromat Support Team Updated August 31, 2020 15:20
This is a documentation of the legacy Google Forms (legacy) app.
Here is a documentation of the new Google Forms app.

Getting Started with Google Forms

The Google Forms modules allow you to monitor, select, add, update or delete responses on your Google Forms.

  • See the changelog for the Google Forms App
To upgrade to a new version of the Google Forms app, you need to upgrade all modules manually by Replacing Legacy Modules with New Modules.

Prerequisites

  • A Google account
  • A Google Spreadsheet from the corresponding form created

In order to use Google Forms with Integromat, it is necessary to have a Google account. If you do not have one, you can create a Google account at docs.google.com/forms/.

Module dialog fields that are displayed in bold (in the Integromat scenario, not in this documentation article) are mandatory!

Connecting Google Forms to Integromat

To connect your Google account to Integromat follow the general instructions for Connecting to services.

After you click the Continue button, Integromat will redirect you to the Google Forms website where you will be prompted to grant Integromat access to your account.

2019-03-19_16_13_12-Window.png

Confirm the dialog by clicking the Allow button.

In order to work with your form responses, the spreadsheet from your responses must be created.

Creating a Spreadsheet from the Form

1. Open your form.

2. Go to the Responses tab.

3. Click on the Create Spreadsheet button. 2019-03-20_11_48_49-My_First_Form_-_Google_Forms.png

kpjg4eWxay.gif

4. The spreadsheet from the form is created and you can now proceed to work with your form responses in Integromat.

Triggers

Watch Responses

Watches the form for new responses.

Connection Establish a connection to your Google account.
File Select the form you want to watch for new responses.
Worksheet Select the sheet that contains the form responses.
Maximum number of returned rows Set the maximum number of responses that Integromat will work with during one cycle (the number of repetitions per one scenario run).

Actions

Select Responses

Retrieves a list of the responses by the specified parameters.

Connection Establish a connection to your Google account.
File Select the form you want to select responses from.
Worksheet Select the sheet that contains the form responses.
Order By Select the sort order.
Sort Direction Select the sort order.
Continue the execution of the route even if the module returns no results If enabled, the scenario will not be stopped by this module.
Filtering

Define a filter. Filters are written in the Google Spreadsheet API syntax. You can use standard comparison operators (>, >=, =, !=, <, <=), logical operators (and, or), and enclose filter expressions in parentheses.

Example: Suppose, you have at your disposal a form containing age (column howoldareyou). Let's say you want to select all people who are 19 - 30 years old, The filter below selects only data that meet these criteria.

howoldareyou = "19 - 30"

To specify the name of the column that is to be filtered, use the name that is displayed in Integromat in parenthesis. For example, suppose you have a column named How old are you? (howoldareyou). The filter will look like:howoldareyou = "19 - 30" 2019-03-20_12_26_23-Integration_Google_Forms___Integromat.png
Maximum number of returned rows Set the maximum number of responses that Integromat will work with during one cycle (the number of repetitions per one scenario run).

Add a Response

Adds a form response to the sheet.

Connection Establish a connection to your Google account.
File Select the form you want to add a response to.
Worksheet Select the sheet that contains the form responses.
Sheet columns

Enter the desired values to the sheet columns.

For the Timestamp column in the correct format, use the following value:

formatDate(now;DD/MM/YYYY HH:mm;UTC)

2019-03-20_12_43_17-Integration_Google_Forms___Integromat.png

Update a Response

Changes the selected response.

Connection Establish a connection to your Google account.
File Select the form you want to update the response for.
Worksheet Select the sheet that contains the form responses.
Sheet columns

Enter the new values to the desired columns.

Row ID

Enter the row ID. You can use the Google Forms > Select Responses module for mapping the Row ID (add it to the flow before this module), or you can insert the Row ID manually.

2019-03-20_13_38_36-Integration_Google_Forms___Integromat.png

Delete a Response

Deletes a selected response.

Connection Establish a connection to your Google account.
File Select the form you want to delete a response from.
Worksheet Select the sheet that contains the form responses.
Row ID Enter the row ID of the row (response) you want to delete. You can use the Google Forms > Select Responses module for mapping the Row ID (add it to the flow before this module), or you can insert the Row ID manually.

Changelog for Google Forms App

last update: 2020-08-31

New modules:

  • Search Responses
  • Search Responses (Advanced)

Deprecated modules:

  • Select Responses
Was this article helpful?
4 out of 9 found this helpful
Menu
  • Features
  • Apps & Services
  • Templates
  • Pricing
  • What's new
  • Use cases
Information
  • Terms,  Privacy
  • FAQ
  • Help & Tutorials
  • Community
  • Affiliate Program
  • Blog
Developers
  • Developer Platform
Company
  • About the company
  • Join our team
  • Contact
Follow us
© 2020 Integromat by Celonis. All rights reserved. Integromat® is a registered trademark.
  • English