Google Sheets

Supported Triggers

Google Sheets

Watch a worksheet

Triggers when a user adds a new row to a selected worksheet.

Supported Actions

Google Sheets

Select rows

Returns rows that match the criteria specified on a selected worksheet.

Google Sheets

Add a worksheet

Google Sheets

Delete a worksheet

Google Sheets

Add a row

Google Sheets

Update a row

Google Sheets

Delete a row

Google Sheets

Update a cell

Getting started with the Google Sheets package

The Google Sheets package lets you monitor a selected Google Sheets file for new rows being added, and add, update or delete rows and lists.

The Google Sheets file format

In order that Integromat can work with your Google Sheet file, the file must comply with several requiremens.

The trigger "Watch a worksheet" retrieves only new rows that were not before filled in. If, for example, the row 23 is newly filled in, the trigger will process it. Afterwards, this row will be deleted and overwritten with a new row. Once this happens, the trigger will not return the row 23 a second time.

The first row of a worksheet is always considered a header row (columns captions) and the trigger does not return it.

The file must not contain a full blank row. An empty row terminates a file. If there are any rows after the blank row, they will not be processed.

Connecting the Google Sheets service to Integromat

For any use of the Google Sheets package, you need to have a Google account which you can create for free.

To connect your Google account to Integromat, follow the general instructions Connecting to services. After you click the Create a connection button, Integromat will redirect you to the Google website where you will be prompted to grant Integromat access to your account:

Here, allow the access by clicking the Allow button. Afterwards, you will be redirected back to the Integromat administration. Now you can create scenarios containing modules from the Google Sheets package.

If any error occurs when establishing the connection, visit the [ Problems creating an account] page (kb://common-problems.html#accounts) for further solution and recommendations on how to proceed.

Setting up the "Select rows" action

Every time the "Select rows" action runs, it goes through all rows in a file according to specified criteria. This distinguishes this trigger from the trigger "Watch a worksheet" that only watches for new rows added since the last run.

In the settings of the "Select rows" action, you can specify the sort order of the returned results and the maximum number of returned rows. You may also 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 file containing among other characteristics, names of people, their age (column age) and height (column height). Let´say you want to select all people who are over 25 years, with a height of maximum 185 cm and named Petr or Karel (column name). The filter below selects only data that meet these criteria.

age > 25 and height < 185 and (name = "Petr" or name = "Karel")

Note: To specify the name of the column to be filtered, use the name displayed in Integromat in parenthesis. Example: Let´s suppose you have a column named Employee age (employeeage). The filter will look like:employeeage> 32.

Rate this article: