Google Sheets Search With Filtering

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

Inputs

Name	Type	Description
Spreadsheet ID	String	The id of the spreadsheet. Get the file id (Step 5)
Credentials JSON	Object	Service account credentials. Get the credentials
Spreadsheet Tab Name	String	The tab name of the sheet. Get the tab name (Step 6)
Spreadsheet Colum	String	Column name. A, B, C...
Value	String	Value to search for
Case Sensitive	Boolean	Whether to match the case. True / False
Comparison Operator	String	How to compare the values. equals, not equals, includes, not includes, bigger, smaller, not bigger, not smaller

Outputs

Name	Type	Description
Success	Boolean	Whether found any matching rows
Matching rows	List	Matching 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

👍
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).

Comparison Operation

Example

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

Extracting data from the matching rows