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).
Updated 12 months ago