find_replace
Find and replace text in a Google Sheet, with options to match case, search formulas, or match entire cell content.
Instructions
Find and replace text in a sheet
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"spreadsheet_id": "<spreadsheet_id>",
"find": "<find>",
"replace": "<replace>"
},
"name": "find_replace"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| find | Yes | Text to find | |
| replace | Yes | Text to replace with | |
| sheet_id | No | The ID of the sheet (optional, searches all sheets if not provided) | |
| match_case | No | Whether to match case | |
| spreadsheet_id | Yes | The ID of the spreadsheet | |
| search_formulas | No | Whether to search in formulas | |
| match_entire_cell | No | Whether to match entire cell content |