Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to search for values in a Google Sheet.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Find in sheet function searches for a value across a sheet or within a specified range and returns the matching cell references and values.
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Connector | Yes | Select | - | Select the Google Workspace connector to use |
| Spreadsheet ID | Yes | Text | - | Google Sheets spreadsheet ID |
| Range | No | Text | Entire sheet | A1 notation range to search within |
| Search value | Yes | Text | - | The value to search for |
| Match case | No | Boolean | false | Whether the search is case-sensitive |
| Match entire cell | No | Boolean | false | Whether the value must match the entire cell content |
| Variable | Yes | Text | - | Variable to store the results |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Array | Array of matches, each containing cell (A1 reference), row, column, and value |
Errors
- Spreadsheet not found – the spreadsheet ID is invalid
Tips
- Use Match entire cell when searching for exact values like IDs
- The result array is empty if no matches are found
Related functions
- Find and replace – Find and replace values
- Read sheet range – Read a specific range