Google Forms

Version Latest

This is the documentation for the new Google Forms app.
Here is the documentation for the legacy Google Forms (legacy) app.

Getting Started with Google Forms

The Google Forms modules allow you to monitor, search, 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.

To work with your form responses, there must be a spreadsheet created from your responses.

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 is created from the form and you can now proceed to work with your form responses in Integromat.

Triggers

Watch Responses

Watches a form for new responses.

Connection Establish a connection to your Google account.

Spreadsheet Select the form you want to watch for new responses.

Sheet Select the sheet that contains the form responses.

Row with headers Specify the header row of the table. Default is A1:Z1.

Value render option

Select how values should be represented in the output.

Formatted value	Values will be calculated & formatted in the reply according to the cell's formatting. Formatting is based on the spreadsheet's locale, not the requesting user's locale. For example, if `A1` is `1. 23` and `A2` is `=A1` and formatted as currency, then `A2` will return `"$1. 23"` .
Unformatted value	Values will be calculated, but not formatted in the reply. For example, if `A1` is `1. 23` and `A2` is `=A1` and formatted as currency, then `A2` will return the number `1. 23` .
Formula	Values will not be calculated. The reply will include the formulas. For example, if `A1` is `1. 23` and `A2` is `=A1` and formatted as currency, then A2 will return `"=A1"`.

Date and time render option

Specifies how dates, times, and duration should be represented in the output. This is ignored if Value render option (above) is set to Formatted value. The default Serial number.

Limit Set the maximum number of responses that Integromat will return during one cycle.

Actions

Add a Response

Adds a form response to the bottom of the sheet's table.

Connection Establish a connection to your Google account.

Spreadsheet Select the form that contains the sheet you want to add a response to.

Sheet Select the sheet with form responses you want to append a new response to.

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)

Value input option

Specify how input data should be interpreted.

Raw	The values the user has entered will not be parsed and will be stored as-is.
User entered	The values will be parsed as if the user typed them into the UI. Numbers will remain numbers, but strings may be converted to numbers, dates, etc. following the same rules that are applied when entering text into a cell via the Google Sheets UI.

Insert data option

Specify how existing data is changed when new data is input.

Overwrite	The new data overwrites existing data in the areas where it is written. (Note: adding data to the end of the sheet will still insert new rows or columns so the data can be written.)
Insert rows	Rows are inserted for the new data.

Update a Response

Changes a selected response.

Connection

Establish a connection to your Google account.

Spreadsheet

Select the form you want to update the response for.

Sheet

Select the sheet that contains the form responses.

Row number

Enter the number of the row that contains the response you want to change.

Values

Enter the new values to the desired columns.

Value input option

Specify how existing data is changed when new data is input.

Raw	The values the user has entered will not be parsed and will be stored as-is.
User entered	The values will be parsed as if the user typed them into the UI. Numbers will remain numbers, but strings may be converted to numbers, dates, etc. following the same rules that are applied when entering text into a cell via the Google Sheets UI.

Delete a Response

Deletes a selected response.

Connection	Establish a connection to your Google account.
Spreadsheet	Select the form you want to delete a response from.
Sheet	Select the sheet that contains the form responses.
Row number	Enter the number of the row that contains the response you want to change.

Searches

Search Responses

Retrieves a list of the responses by specified filter settings.

Connection Establish a connection to your Google account.

Spreadsheet Select the form you want to search in.

Sheet Select the sheet that contains the form responses.

Order By Select the sort order.

Column range Select the column range you want to search.

Filter

Define the filter to filter returned responses by.

Sort Order Select whether to sort returned responses in ascending or descending order.

Order By Select the column you want to order returned responses by.

Value render option

Select how values should be represented in the output.

Formatted value	Values will be calculated & formatted in the reply according to the cell's formatting. Formatting is based on the spreadsheet's locale, not the requesting user's locale. For example, if `A1` is `1. 23` and `A2` is `=A1` and formatted as currency, then `A2` will return `"$1. 23"` .
Unformatted value	Values will be calculated, but not formatted in the reply. For example, if `A1` is `1. 23` and `A2` is `=A1` and formatted as currency, then `A2` will return the number `1. 23` .
Formula	Values will not be calculated. The reply will include the formulas. For example, if `A1` is `1. 23` and `A2` is `=A1` and formatted as currency, then A2 will return `"=A1"`.

Date and time render option Specifies how dates, times, and duration should be represented in the output. This is ignored if Value render option (above) is set to Formatted value. The default Serial number.

Maximum number of returned responses Set the maximum number of responses Integromat will return during one execution cycle.

Search Responses (advanced)

Performs a search using the Google Charts Query Language.

Connection	Establish a connection to your Google account.
Spreadsheet	Select the form you want to search in.
Sheet	Select the sheet that contains the form responses.
Filter	Define the search query using the Google Charts Query Language. E.g. `select * where C = "John"` to retrieve all values for the row where the C column is "John".
Maximum number of returned rows	Set the maximum number of responses Integromat will return during one execution cycle.