find_replace
Find and replace text in Google Sheets across the entire spreadsheet or a specific sheet, with options for case-sensitive and exact-cell matching. Returns the number of occurrences changed.
Instructions
Find and replace text across the spreadsheet or a specific sheet.
Args: spreadsheet_id: The ID of the spreadsheet. find: Text to search for. replace: Text to replace with. sheet_id: Limit to specific sheet (-1 for all sheets). match_case: Case-sensitive matching. match_entire_cell: Only match if cell equals find text exactly.
Returns: JSON with number of occurrences changed.
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 | ||
| replace | Yes | ||
| sheet_id | No | ||
| match_case | No | ||
| spreadsheet_id | Yes | ||
| match_entire_cell | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |