Applying filters Version 5 (Net)

Action group: Google services

Description

The action applies filters to a specified range.

Action icon

Settings of parameters 

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextIndentifier of session for actionRobin.SpreadShee tsSpreadSheets contextYes
Document IDIndentifier of document for actionRobin.String
Yes
SheetName of working sheet. По умолчанию первый лист документа.Robin.String
No
From сellAddress of starting сell to apply filter in format «XY», where «X» - column name and «Y» - row index.Robin.String
No
To cellAddress of last сell to apply filter in format «XY», where «X» - column name and «Y» - row index.Robin.String
No
ColumnName of column to apply filter. By default «A»Robin.String
No
CriteriaFilter criteria in the format «={value}», «<{value}», «>{value}», «>={value}», «<={value}» or «!={Value}». If the field value is not filled in, then filtering will be set by the value «(Empty)».Robin.String
No

Special conditions of use

The Google Sheets API has a limit of up to 60 read-requests per user per minute. To ensure that the action does not immediately generate an error when the limit on the number of requests is reached, the action includes a loop operation that will resend requests within a minute.

Example of use

Task

There is a Google spreadsheet:

Set a filter on the values in the "B" column with the condition "<200".

Solution

Use the "Context Google tables", "Applying filter" actions.

Implementation

  1. Assemble a robot scheme with the actions:
  2. Set the "Context Google tables" action parameters.
    image2024-1-23_17-32-1.png
    Fill in the "The file path" and "Application name" fields (more about filling in these fields in section Instructions for setting up a connection to Google Sheets/Docs/Drive).
  3. Set the "Applying filter" action parameters.

    In the ID field specify the part of the table's link.
    image2024-1-23_17-35-12.png
  4. Click "Start" in the top panel to start the robot.

Result

The program robot completed successfully.

The filters are applied successfully.