Utilisez Googlesheets Lookup Spreadsheet Row avec Google Sheets Tools via Aident Loadout. Vérifiez les entrées, sorties, la configuration, le tarif et le risque avant exécution.
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.
queryObligatoirestringExact 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_idObligatoirestringIdentifier 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.
dataObligatoireData from the action execution
errorstringError if any occurred during the execution of the action
successfulObligatoirebooleanWhether or not the action execution was successful or not
Connexion OAuth. Niveau de risque 2 sur 5.
Action gratuite
Aucune Skill publiée ne référence encore explicitement cette Action.