Find and replace
find_replaceReplace text across a Google Sheets tab or whole spreadsheet, with regex, case, and formula options. Not undoable; inspect cells first.
Instructions
Find and replace text across a tab or the whole spreadsheet. Not undoable - consider read_range first.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| find | Yes | ||
| sheet | No | Limit to this tab (default: all tabs) | |
| account | No | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. | |
| use_regex | No | ||
| match_case | No | ||
| replacement | Yes | ||
| spreadsheet | Yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works | |
| include_formulas | No | ||
| match_entire_cell | No |