Google Forms (legacy)

Version Legacy

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.

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.

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"`
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.

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.