Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to find and replace values in a Google Sheet.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Find and replace function searches for a value across the spreadsheet or a specific sheet and replaces all occurrences with a new value.
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 |
| Sheet ID | No | Text | All sheets | Limit search to a specific sheet tab (numeric ID) |
| Find | Yes | Text | - | The value to find |
| Replace | Yes | Text | - | The replacement value |
| 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 |
| Search formulas | No | Boolean | false | Whether to search within formulas |
| Variable | Yes | Text | - | Variable to store the result |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Object | Object containing occurrencesChanged, rowsChanged, and sheetsChanged counts |
Errors
- Spreadsheet not found – the spreadsheet ID is invalid
Tips
- Test with Find in sheet first to confirm the correct matches before replacing
- Use Search formulas to replace references within formulas
Related functions
- Find in sheet – Search without replacing
- Write sheet range – Write specific values