Usa Googlesheets Lookup Spreadsheet Row con Google Sheets Tools mediante Aident Loadout. Revisa sus entradas, salidas, configuración, precio y riesgo antes de ejecutarla.
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.
queryObligatoriostringExact 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_idObligatoriostringIdentifier 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.
dataObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulObligatoriobooleanWhether or not the action execution was successful or not
Conexión OAuth. Nivel de riesgo 2 de 5.
Action gratuita
Aún no hay Skills publicadas que hagan referencia explícita a esta Action.