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.

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.

2019-03-19_16_13_12-Window.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. 2019-03-20_11_48_49-My_First_Form_-_Google_Forms.png

kpjg4eWxay.gif

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.

ConnectionEstablish a connection to your Google account.
SpreadsheetSelect the form you want to watch for new responses.
SheetSelect the sheet that contains the form responses.
Row with headersSpecify the header row of the table. Default is A1:Z1.
Value render option

Select how values should be represented in the output.

Formatted valueValues 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 valueValues 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 .
FormulaValues 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.

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

ConnectionEstablish a connection to your Google account.
SpreadsheetSelect the form that contains the sheet you want to add a response to.
SheetSelect 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)

2020-08-31_12_49_33-Window.png

Value input option

Specify how input data should be interpreted.

RawThe values the user has entered will not be parsed and will be stored as-is.
User enteredThe 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.

OverwriteThe 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 rowsRows are inserted for the new data.

Update a Response

Changes a selected response.

ConnectionEstablish a connection to your Google account.
SpreadsheetSelect the form you want to update the response for.
SheetSelect the sheet that contains the form responses.
Row numberEnter 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.

RawThe values the user has entered will not be parsed and will be stored as-is.
User enteredThe 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.

ConnectionEstablish a connection to your Google account.
SpreadsheetSelect the form you want to delete a response from.
SheetSelect the sheet that contains the form responses.
Row numberEnter 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.

ConnectionEstablish a connection to your Google account.
SpreadsheetSelect the form you want to search in.
SheetSelect the sheet that contains the form responses.
Order BySelect the sort order.
Column rangeSelect the column range you want to search.
Filter

Define the filter to filter returned responses by.

Sort OrderSelect whether to sort returned responses in ascending or descending order.
Order BySelect the column you want to order returned responses by.
Value render option

Select how values should be represented in the output.

Formatted valueValues 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 valueValues 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 .
FormulaValues 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 optionSpecifies 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 responsesSet the maximum number of responses Integromat will return during one execution cycle.

Search Responses (advanced)

Performs a search using the Google Charts Query Language.

ConnectionEstablish a connection to your Google account.
SpreadsheetSelect the form you want to search in.
SheetSelect 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 rowsSet the maximum number of responses Integromat 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

Popular use cases from our blog

slack-automation-illustration

Slack Automation: 20 Free Templates to Get You Inspired

google-sheets-automation-alt

Google Sheets Automation for Ecommerce: 23 Free Templates

tweet-automation-illustration

How to Get Someone's Tweets Before Anyone Else Does

onboarding-automation-with-integromat-alt

How to Automate Employee Onboarding in Minutes with Integromat

shopify-order-to-manufacturer-illustration-alt

How to Auto Send Shopify Orders to Dropshipping Suppliers [Guide]

strava-exercise-to-google-sheets-illustration

Like a Champ: How to Save Strava Activities to Google Sheets

Didn’t find what you were looking for?

Ticket

Create a ticket

Contact our world-class support team and tell us what’s happening.

Create a ticket
Expert

Find an expert

We feature a network of 450+ certified partners across the globe who are ready to help

Find an expert

Automate any workflow in your business

Sign up for a free account today. No credit card required, no time limits on free plan.