Definition and Usage
This command searches for matching cells in a Google spreadsheet and returns their coordinates. It allows you to find specific values within a Google Sheet and obtain the cell references where these values are located.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Google Sheet | Select the Google sheet to read |
| Yes | Must be a valid Google Sheet connection |
Value to find | Enter the value you want to search for in the Google Sheet |
| Yes | Can be text, number, or formula result |
Ignore case | Ignore letter case when searching (case-insensitive) | True/False | No | When enabled, "TEXT" will match "text" |
Match entire cell | Find only cells that exactly match the search value | True/False | No | When disabled, partial matches will be included |
Use Regular Expression | Enable pattern matching with regular expressions | True/False | No | Allows for complex search patterns |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This command produces an output variable that stores the coordinate list of matching cells in the format: [["A1"], ["B3"], ["C10"]]
Using Variables in Conditions
You can use the {x} icon to insert previously created variables into parameter fields. This is particularly useful when you want to search for dynamic values that may change during workflow execution. The output variable containing cell coordinates can be used in subsequent actions to manipulate or read specific cells.
Notes
Before using this command, ensure you have properly connected to the Google Sheet.
The search operation may take longer on large spreadsheets with many cells.
When using Regular Expressions, make sure your pattern syntax is correct to avoid unexpected results.
The returned coordinates can be used with other Google Sheet commands to read or modify the found cells.
If no matching cells are found, the command will return an empty array.