Google Forms
Getting Started with Google Forms
The Google Forms modules allow you to
search, create, retrieve, and update forms and move forms to trash
watch, list, and retrieve responses
watch, search, add, update, and delete responses in google sheets
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
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/.
Connect Google Forms to Make
To connect Google Forms app:
Log in to your Make account, insert a Google Forms module in your scenario, and click the Add button next to the Connection field.
Optional: In the Connection name field, enter a name for the connection.
Optional: Click Show advanced settings and enter the client credentials of your custom app.
Click Save.
Confirm the permissions dialog by clicking the Allow button.
You have successfully established the connection. You can now edit your scenario and add more Google Form modules. If your connection needs reauthorization at any point, follow the connection renewal steps here.
Obtain client credentials for your custom app
To obtain the client credentials, you must have access to Google Cloud Console and be able to create or edit the project.
Sign in to Google Cloud console using your Google credentials.
Click Select a project > NEW PROJECT. Enter the desired project name, and click the CREATE button.
Select the project you have created.
Go to APIs & Services > Library.
Search and enable the following required APIs:
Cloud Resource Manager API
The desired service option should display as you type. Select the API/service you want to connect to Make.
Click the ENABLE button to enable the selected API.
Navigate to APIs & Services > OAuth consent screen.
Choose the External option, and click the CREATE button.
Note
You will not be charged when selecting this option! For more details, please refer to Google's Exceptions to verification requirements.
Fill in the required fields as follows, and then click Save and Continue:
App name
Enter the name of the app asking for consent. For example,
Make.Authorized domains
make.comintegromat.com
You don't have to set anything in the Scopes and Optional info sections. Click Save and Continue.
In the Test Users section, click ADD USERS and enter the testing user email address to access the app.
Navigate to Credentials. Click the +CREATE CREDENTIALS and select the OAuth Client ID option.
Fill in the required fields as follows, and then click the CREATE button to create the application:
Application type
web applicationName
Name of the application. For example,
Make.Authorized redirect URIs
https://www.integromat.com/oauth/cb/google-restrictedA dialog containing the app's Client ID and Client Secret is displayed. Save them in a safe place for later use.
You have successfully created the client credentials.
Note
If you are using custom apps with publishing state, Testing, then you must set up the access token NOT TO be forced to re-authenticate every week after expiration.
For more information, see on setting up OAuth consent screen.
To set up app token and authentication, see using OAuth 2.0 for Web Server applications.
Form
Retrieves a list of forms filtered by criteria.
Connection | |
Document Title Contains | Enter the entire or partial title of the document you want included in the returned results. |
Order By | Click + Add item to add a criteria to sort your results. You can then choose a criterion from a drop menu and specify if you want your results sorted in ascending or descending order by your selected criterion. |
Show Share Drive Forms | Select whether to include forms in your shared drive in the results. Select Yes to include results from your shared drive. |
Show Trashed Forms | Select whether to include forms in your trash in the results. Select Yes to include results from your trash. |
Limit | Set the maximum number of responses that Make will return during one cycle. |
Creates a new form.
Connection | |||||||
Info | Enter your information or map the following fields:
| ||||||
Items | Add items by clicking + Add item and entering or mapping your information. Details vary based on the question type. | ||||||
Settings | Select whether your form is a quiz or not. If you select Yes, Google will grade each result. |
Retrieves an existing form by its ID.
Connection | |
Form ID | Enter, map, or click Search to insert the ID of the form you want to retrieve. |
Updates an existing form by its ID.
Connection | |||||
Form ID | Enter, map, or click Search to insert the ID of the form you want to update. | ||||
Info | Enter your information or map the following fields:
| ||||
Item Changes | Use the Item action drop menu to select whether you want to create, update, move, or delete an item. Options vary depending on the action selected and item type. Location refers to the item's position on the list of all form items. The very first item is 0, the second item is 1, and so on. To add an item at the very beginning of your form, use 0 as the location. |
Removes a form and moves it to trash.
Connection | |
Form ID | Enter, map, or click Search to insert the ID of the form you want to move to trash. |
Response
Triggers when a new response is received.
Connection | |
Form ID | Enter, map, or click Search to insert the ID of the form you want Make to watch. |
Limit | Set the maximum number of responses that Make will return during one cycle. |
Retrieves a list of responses.
Connection | |
Form ID | Enter, map, or click Search to insert the ID of the form you want a list of responses for. |
Since | Enter a date and time if you only want responses submitted at and after the date and time you specify here. |
Limit | Set the maximum number of responses that Make will return during one cycle. |
Retrieves the details of a response by its ID.
Connection | |
Form ID | Enter, map, or click Search to insert the ID of the form whose response details you want to retrieve. |
Response ID | Enter or map the ID of the response whose details you want. |
Legacy
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. |
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. |
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. |
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.
|
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.
|
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. |
Other
Performs an arbitrary authorized API call.
Connection | |
URL | Enter a path relative to For example For the list of available endpoints, refer to the Google Forms API Documentation. |
Method | Select the HTTP method you want to use:
|
Headers | Enter the desired request headers. You don't have to add authorization headers; we already did that for you. |
Query string | Enter the request query string. |
Body | Enter the body content for your API call. |
Example of use - Get a Form
The following API call returns all tasks from your account.
URL: /v1/forms/{formId}
Method: GET
Matches of the search can be found in the module's Output under Bundle > Body.
In our example, the requested form was returned:
