Integromat
  • Back to website
Articles in this section
  • Formstack
  • Magento 2
  • Google Cloud Vision
  • ManyChat
  • Airtable
  • Bubble
  • Email (legacy)
  • Facebook Groups
  • Google Sheets (legacy)
  • HTTP
See more
  1. Integromat Support
  2. Apps
  3. Docs

Google Forms

Integromat Support Team Integromat Support Team Updated February 19, 2021 22:03
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.

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.

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)

2020-08-31_12_49_33-Window.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 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.

Changelog for Google Forms App

last update: 2020-08-31

New modules:

  • Search Responses
  • Search Responses (Advanced)

Deprecated modules:

  • Select Responses
Was this article helpful?
1 out of 5 found this helpful
Menu
  • Features
  • Apps & Services
  • Templates
  • Pricing
  • What's new
  • Use cases
Information
  • Terms,  Privacy
  • FAQ
  • Help & Tutorials
  • Community
  • Affiliate Program
  • Blog
Developers
  • Developer Platform
Company
  • About the company
  • Join our team
  • Contact
Follow us
© 2020 Integromat by Celonis. All rights reserved. Integromat® is a registered trademark.
  • English