Google Sheets
GOOGLESHEETS_FIND_REPLACE
Tool to find and replace text in a Google Spreadsheet. Use when you need to fix formula errors, update values, or perform bulk text replacements across cells. Common use cases: - Fix #ERROR! cells by replacing with empty string or correct formula - Update old values with new ones across multiple cells - Fix formula references or patterns - Clean up data formatting issues
Remote googlesheets
Other tools also called GOOGLESHEETS_FIND_REPLACE?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"find": {
"type": "string",
"description": "The text to find. Can be a literal string or a regular expression pattern.\nExamples:\n \"#ERROR!\"\n \"=SUM(A1:A10)\"\n \"old_value\""
},
"range": {
"type": [
"string",
"null"
],
"default": null,
"description": "The A1 notation range to search in. If not specified, searches the entire sheet(s).\nExamples:\n \"A1:Z100\"\n \"Sheet1!A:C\"\n \"B2:D10\""
},
"sheetId": {
"anyOf": [
{
"type": "integer"
},
{
"type": "null"
}
],
"default": null,
"description": "The ID of the sheet to search in. If not specified, searches all sheets.\nExamples:\n 0\n 123456789"
},
"allSheets": {
"type": [
"boolean",
"null"
],
"default": false,
"description": "Whether to search across all sheets in the spreadsheet.\nExamples:\n true\n false"
},
"matchCase": {
"type": [
"boolean",
"null"
],
"default": false,
"description": "Whether the search should be case-sensitive.\nExamples:\n true\n false"
},
"replacement": {
"type": "string",
"description": "The text to replace the found instances with.\nExamples:\n \"\"\n \"=SUM(A1:A5)\"\n \"new_value\""
},
"searchByRegex": {
"type": [
"boolean",
"null"
],
"default": false,
"description": "Whether to treat the find text as a regular expression.\nExamples:\n true\n false"
},
"spreadsheetId": {
"type": "string",
"description": "The ID of the spreadsheet to update.\nExample: \"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms\""
},
"matchEntireCell": {
"type": [
"boolean",
"null"
],
"default": false,
"description": "Whether to match only cells that contain the entire search term.\nExamples:\n true\n false"
}
}
}