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.
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 |