Aident Loadout を通じて Google Sheets Tools の 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…
find必須stringThe 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…
replace必須stringThe 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.
spreadsheetId必須stringThe 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.
data必須Data from the action execution
errorstringError if any occurred during the execution of the action
successful必須booleanWhether or not the action execution was successful or not
OAuth 接続。リスクレベル 2/5。
無料 Action
この Action を明示的に参照する公開 Skills はまだありません。