The Google Forms modules allow you to monitor, select, add, update or delete responses on your Google Forms.
Prerequisites
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/.
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.
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.
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). |
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). |
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:
|
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. |
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. |
last update: 2020-08-31
New modules:
Deprecated modules: