# find_replace_in_sheet (https://sellersheetai.com/docs/mcp-api/tools/find_replace_in_sheet)

> Find and replace text in a sheet.

Access: **DESTRUCTIVE** · toolset google_workspace · family null

## Call it

MCP tool call:

```json
{
  "name": "find_replace_in_sheet",
  "arguments": {
    "spreadsheet_id": "<spreadsheet_id>",
    "find": "<find>",
    "replace": "<replace>"
  }
}
```

Tool API (early access — contact us):

```bash
curl -X POST https://api.sellersheetai.com/api/v1/tools/find_replace_in_sheet \
  -H "Authorization: Bearer $SELLERSHEET_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"spreadsheet_id":"<spreadsheet_id>","find":"<find>","replace":"<replace>"}'
```

## Arguments

| Name | Type | Required | Description |
|---|---|---|---|
| `spreadsheet_id` | string | yes | the spreadsheet ID (from its URL or get_sheet_metadata). |
| `find` | string | yes | Text to find. |
| `replace` | string | yes | Replacement text. |
| `sheet_name` | string |  | the tab name. Omit it to search every tab. |
| `match_case` | boolean |  | Match case (default: False). |
| `match_entire` | boolean |  | Match entire cell (default: False). |
| `regex` | boolean |  | Use regex (default: False). |
| `include_formulas` | boolean |  | Also search and replace inside formula strings (default: False). Use this to update IMPORTRANGE spreadsheet IDs in formula cells. |

## Result

- `data.occurrencesChanged` — the number of replacements (0 = nothing matched).
- `data.valuesChanged / data.formulasChanged / data.rowsChanged / data.sheetsChanged` — Google's per-kind counts.

## Example

- find_replace_in_sheet("1ABC...", "old", "new", "Sheet1", match_case=True) find_replace_in_sheet("1ABC...", "oldSheetId", "newSheetId", include_formulas=True)