Google Sheets Search With Filtering

This action is used search for rows that contain a given value.

Inputs

NameTypeDescription
Spreadsheet IDStringThe id of the spreadsheet.
Get the file id (Step 5)
Credentials JSONObjectService account credentials.
Get the credentials
Spreadsheet Tab NameStringThe tab name of the sheet.
Get the tab name (Step 6)
Spreadsheet ColumStringColumn name. A, B, C...
ValueStringValue to search for
Case SensitiveBooleanWhether to match the case.
True / False
Comparison OperatorStringHow to compare the values.
equals,
not equals,
includes,
not includes,
bigger,
smaller,
not bigger,
not smaller

Outputs

NameTypeDescription
SuccessBooleanWhether found any matching rows
Matching rowsListMatching rows

πŸ“˜

Comparison Operation

The equals, not equals, includes, not includes are used to compare string values.

The bigger, smaller, not bigger, not smaller are used to compare number values.

Example

1086

πŸ‘

Searching for cell 1 in the A column with equals as comparison operation will return the result below

Result

[["cell 1","cell 2", "cell 3", "cell 4"]]

🚧

Extracting data from the matching rows

The action returns two dimensional array.

To extract the cell 1 from the list above, you will have to specify the path /0/0($.0.0).