Look up spreadsheet row

TOOL

Slug

GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW

Version

20261001_00

Toolkit

googlesheets

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.

queryrequired

STRING

Exact text value to find; matches the entire content of a cell in a row.

range

STRING

A1 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'!A1:Z"). Bare sheet names without ranges (e.g., 'Sheet1') are not supported - always specify a range.

case_sensitive

BOOLEAN

If `True`, the query string search is case-sensitive.

Default: false

spreadsheet_idrequired

STRING

Identifier of the Google Spreadsheet to search.

value_render_option

STRING

How 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'. formula: raw formulas instead of computed values.

Options: FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA

Default: "UNFORMATTED_VALUE"

normalize_whitespace

BOOLEAN

If `True`, strips leading and trailing whitespace from cell values before matching. This helps match cells like ' TOTAL ' or 'TOTAL ' when searching for 'TOTAL'.

Default: true

date_time_render_option

STRING

How 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.