Google Super
GOOGLESUPER_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 googlesuper
Other tools also called GOOGLESUPER_FIND_REPLACE?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"find": {
"type": "string",
"title": "Find",
"examples": [
"#ERROR!",
"=SUM(A1:A10)",
"old_value"
],
"description": "The text to find. Can be a literal string or a regular expression pattern."
},
"range": {
"type": "string",
"title": "Range",
"default": null,
"examples": [
"A1:Z100",
"Sheet1!A:C",
"B2:D10"
],
"nullable": true,
"description": "The A1 notation range to search in. If not specified, searches the entire sheet(s)."
},
"sheetId": {
"type": "integer",
"title": "Sheet Id",
"default": null,
"examples": [
0,
123456789
],
"nullable": true,
"description": "The ID of the sheet to search in. If not specified, searches all sheets."
},
"allSheets": {
"type": "boolean",
"title": "All Sheets",
"default": false,
"examples": [
true,
false
],
"nullable": true,
"description": "Whether to search across all sheets in the spreadsheet."
},
"matchCase": {
"type": "boolean",
"title": "Match Case",
"default": false,
"examples": [
true,
false
],
"nullable": true,
"description": "Whether the search should be case-sensitive."
},
"replacement": {
"type": "string",
"title": "Replacement",
"examples": [
"",
"=SUM(A1:A5)",
"new_value"
],
"description": "The text to replace the found instances with."
},
"searchByRegex": {
"type": "boolean",
"title": "Search By Regex",
"default": false,
"examples": [
true,
false
],
"nullable": true,
"description": "Whether to treat the find text as a regular expression."
},
"spreadsheetId": {
"type": "string",
"title": "Spreadsheet Id",
"examples": [
"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
],
"description": "The ID of the spreadsheet to update."
},
"matchEntireCell": {
"type": "boolean",
"title": "Match Entire Cell",
"default": false,
"examples": [
true,
false
],
"nullable": true,
"description": "Whether to match only cells that contain the entire search term."
}
}
}