find_and_replace
Locate and substitute text in Google Sheets cells using search patterns and replacement values within specified ranges or entire spreadsheets.
Instructions
Find and replace text in a range or entire sheet
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet_id | Yes | The ID of the spreadsheet | |
| find | Yes | Text to find | |
| replacement | Yes | Text to replace with | |
| range | No | Optional A1 range to search in | |
| match_case | No | Whether to match case (default: false) |