Google Forms (legacy)
Version Legacy
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.
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/.
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.
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.
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:
|
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. |
Changelog for Google Forms App
last update: 2020-08-31
New modules:
- Search Responses
- Search Responses (Advanced)
Deprecated modules:
- Select Responses