Google Forms
Getting Started with Google Forms
The Google Forms modules allow you to monitor, search, add, update, or delete responses on your Google Forms.
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 Make, 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 Make , not in this documentation article) are mandatory!
Connecting Google Forms to Make
To connect your Google account to Make follow the general instructions for Connecting to services.
After you click the Continue button, Make will redirect you to the Google Forms website where you will be prompted to grant Make 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 Make.
Triggers
Watch Responses
Watches a form for new responses.
Connection | |||||||
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 | ||||||
Value render option | Select how values should be represented in the output.
| ||||||
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 | ||||||
Limit | Set the maximum number of responses that Make will return during one cycle. |
Actions
Add a Response
Adds a form response to the bottom of the sheet's table.
Connection | |||||
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:
| ||||
Value input option | Specify how input data should be interpreted.
| ||||
Insert data option | Specify how existing data is changed when new data is input.
|
Update a Response
Changes a selected response.
Connection | |||||
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.
|
Delete a Response
Deletes a selected response.
Connection | |
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 | |||||||
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.
| ||||||
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 | ||||||
Maximum number of returned responses | Set the maximum number of responses Make 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. |
Maximum number of returned rows | Set the maximum number of responses Make will return during one execution cycle. |
Changelog for Google Forms App
last update: 2020-08-31
New modules:
Search Responses
Search Responses (Advanced)
Deprecated modules:
Select Responses