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
अभी कोई प्रकाशित Skills इस Action को स्पष्ट रूप से संदर्भित नहीं करती है।