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 one…
findRequiredstringThe text to find. Can be a literal string or a regular expression pattern.
rangestringA1 notation range string to search within (e.g., 'A1:B10', 'Sheet1!A1:B10'). When using A1 notation with a sheet name, you must also provide range_sheet_id to specify the numeric sheet ID (the API requires numeric IDs). Alternatively, use the GridRange parameters (range_sheet_id…
replaceRequiredstringThe text to replace the found instances with.
sheetIdintegerThe numeric ID of the sheet to search the entire sheet (e.g., 0 for the first sheet). Mutually exclusive with sheet_name, range/range_sheet_id parameters, and all_sheets. You must specify exactly one scope: either sheet_id (entire sheet), sheet_name, range/range_sheet_id (specif…
allSheetsbooleanWhether to search across all sheets in the spreadsheet. Mutually exclusive with sheet_id and range parameters.
matchCasebooleanWhether the search should be case-sensitive.
sheetNamestringThe name/title of the sheet (tab) to search within (e.g., 'Sheet1', 'Sales Data'). The sheet name will be resolved to its numeric sheet ID. Mutually exclusive with sheet_id, range/range_sheet_id parameters, and all_sheets.
endRowIndexintegerThe end row (0-indexed, exclusive) of the range. Only used when range_sheet_id is provided without a 'range' parameter.
rangeSheetIdintegerThe numeric sheet ID for a GridRange-based search. Required when using the 'range' parameter with A1 notation. Can also be used alone or with row/column index parameters to define a specific range. Mutually exclusive with sheet_id and all_sheets.
searchByRegexbooleanWhether to treat the find text as a regular expression.
spreadsheetIdRequiredstringThe ID of the spreadsheet to update.
startRowIndexintegerThe start row (0-indexed, inclusive) of the range. Only used when range_sheet_id is provided without a 'range' parameter.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
OAuth connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.