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.

61d5b4eda1dc6.png

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. 61d5b4eedca48.png

61d5b4efbe23e.gif

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

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 Make 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)
                        
61d5b4f312361.png

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 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. 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 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