sheets_find_replace
Find and replace text across a Google Sheet or within a specified range, with options for regex, case matching, and whole-cell matches.
Instructions
Finds and replaces text across a spreadsheet or within a specific range
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| find | Yes | The text to find | |
| range | No | Optional A1 notation range to limit the search | |
| use_regex | No | Whether to treat the find string as a regex | |
| match_case | No | Whether the search is case-sensitive | |
| replacement | Yes | The text to replace with | |
| spreadsheet_id | Yes | The ID of the spreadsheet | |
| search_formulas | No | Whether to search within formulas | |
| match_entire_cell | No | Whether to match the entire cell content |