Google Forms (legacy)

Version Legacy

This is a documentation of the legacy Google Forms (legacy) app.
Here is a documentation of the new Google Forms app.

Getting Started with Google Forms

The Google Forms modules allow you to monitor, select, 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.

In order to work with your form responses, the spreadsheet from your responses must be created.

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 from the form is created and you can now proceed to work with your form responses in Integromat.

Triggers

Watch Responses

Watches the form for new responses.

ConnectionEstablish a connection to your Google account.
FileSelect the form you want to watch for new responses.
WorksheetSelect the sheet that contains the form responses.
Maximum number of returned rowsSet the maximum number of responses that Integromat will work with during one cycle (the number of repetitions per one scenario run).

Actions

Select Responses

Retrieves a list of the responses by the specified parameters.

ConnectionEstablish a connection to your Google account.
FileSelect the form you want to select responses from.
WorksheetSelect the sheet that contains the form responses.
Order BySelect the sort order.
Sort DirectionSelect the sort order.
Continue the execution of the route even if the module returns no results If enabled, the scenario will not be stopped by this module.
Filtering

Define a filter. Filters are written in the Google Spreadsheet API syntax. You can use standard comparison operators (>, >=, =, !=, <, <=), logical operators (and, or), and enclose filter expressions in parentheses.

Example: Suppose, you have at your disposal a form containing age (column howoldareyou). Let's say you want to select all people who are 19 - 30 years old, The filter below selects only data that meet these criteria.

howoldareyou = "19 - 30"

To specify the name of the column that is to be filtered, use the name that is displayed in Integromat in parenthesis. For example, suppose you have a column named How old are you? (howoldareyou). The filter will look like:howoldareyou = "19 - 30" 2019-03-20_12_26_23-Integration_Google_Forms___Integromat.png
Maximum number of returned rowsSet the maximum number of responses that Integromat will work with during one cycle (the number of repetitions per one scenario run).

Add a Response

Adds a form response to the sheet.

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

2019-03-20_12_43_17-Integration_Google_Forms___Integromat.png

Update a Response

Changes the selected response.

ConnectionEstablish a connection to your Google account.
FileSelect the form you want to update the response for.
WorksheetSelect the sheet that contains the form responses.
Sheet columns

Enter the new values to the desired columns.

Row ID

Enter the row ID. You can use the Google Forms > Select Responses module for mapping the Row ID (add it to the flow before this module), or you can insert the Row ID manually.

2019-03-20_13_38_36-Integration_Google_Forms___Integromat.png

Delete a Response

Deletes a selected response.

ConnectionEstablish a connection to your Google account.
FileSelect the form you want to delete a response from.
WorksheetSelect the sheet that contains the form responses.
Row IDEnter the row ID of the row (response) you want to delete. You can use the Google Forms > Select Responses module for mapping the Row ID (add it to the flow before this module), or you can insert the Row ID manually.

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

automated-data-collection-crm-illustration

How to Automate Data Collection - Part 5: CRM Systems

automated-data-collection-chatbot-marketing-illustration

How to Automate Data Collection - Part 4: Chatbot Marketing

automated-data-collection-paid-ads-illustration

How to Automate Data Collection - Part 3: Paid Ads

automated-data-collection-email-illustration

How to Automate Data Collection - Part 2: Email Marketing Segmentation

personalized-customer-experience-illustration-integromat

5 Automated Solutions to Personalize Customer Experience

data-collection-automation-forms-pt-1

How to Automate Data Collection - Part 1: Online Forms

Didn’t find what you were looking for?

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.