Aident Loadout を通じて Google Sheets Tools の Googlesheets Lookup Spreadsheet Row を使用します。実行前に入力、出力、設定、料金、リスクを確認できます。
Finds the first row in a Google Spreadsheet where a cell's entire content exactly matches the query string, searching within a specified A1 notation range or the first sheet by default.
query必須stringExact text value to find; matches the entire content of a cell in a row.
rangestringA1 notation range to search within. Supports cell ranges (e.g., 'Sheet1!A1:D5'), column-only ranges (e.g., 'Sheet1!A:Z'), and row-only ranges (e.g., 'Sheet1!1:1'). Defaults to the first sheet if omitted. IMPORTANT: Sheet names with spaces must be single-quoted (e.g., "'My Sheet'…
case_sensitivebooleanIf `True`, the query string search is case-sensitive.
spreadsheet_id必須stringIdentifier of the Google Spreadsheet to search.
value_render_optionstringHow cell values are rendered in the returned row data. unformatted: raw values without display formatting — dates appear as serial numbers, e.g. 46009.47 (default, keeps consistency with UPSERT). formatted: display-formatted values — dates appear as strings, e.g. '2025-12-18'. f…
normalize_whitespacebooleanIf `True`, strips leading and trailing whitespace from cell values before matching. This helps match cells like ' TOTAL ' or 'TOTAL ' when searching for 'TOTAL'.
date_time_render_optionstringHow dates and times are represented. FORMATTED_STRING: human-readable strings (e.g. '2025-12-18 11:17'). SERIAL_NUMBER: Excel-style serial numbers. Works with all value_render_option settings.
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 はまだありません。