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 one…

料金

無料 Action

統合支払い

現在未対応

• findstring

  必須
  The text to find. Can be a literal string or a regular expression pattern.
• rangestring
  A1 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…
• replacestring

  必須
  The text to replace the found instances with.
• sheetIdinteger
  The 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…
• allSheetsboolean
  Whether to search across all sheets in the spreadsheet. Mutually exclusive with sheet_id and range parameters.
• matchCaseboolean
  Whether the search should be case-sensitive.
• sheetNamestring
  The 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.
• endRowIndexinteger
  The end row (0-indexed, exclusive) of the range. Only used when range_sheet_id is provided without a 'range' parameter.
• rangeSheetIdinteger
  The 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.
• searchByRegexboolean
  Whether to treat the find text as a regular expression.
• spreadsheetIdstring

  必須
  The ID of the spreadsheet to update.
• startRowIndexinteger
  The start row (0-indexed, inclusive) of the range. Only used when range_sheet_id is provided without a 'range' parameter.

• data

  必須
  Data from the action execution
• errorstring
  Error if any occurred during the execution of the action
• successfulboolean

  必須
  Whether or not the action execution was successful or not

検証済みの関連ユースケースはまだリンクされていません。