Google Sheets Nexviahub icon

Google Sheets Nexviahub

Read, update and write data to Google Sheets

Actions10

Sheet Within Document → Get Row(s)

AI-generated

Summary

Reads rows from a selected Google Sheets tab, optionally filtering rows by column values. Configure the document and sheet, then set filters and read options such as the data range, value formatting, and whether to return one or all matches.

Inputs

  • Authentication (required) — Choose Service Account or OAuth2. OAuth2 requires Client ID, Client Secret, Refresh Token, and Access Token; the credential fields are marked required in the UI.
  • Document (required) — Select a spreadsheet from the list, provide its Google Sheets URL, or enter its ID.
  • Sheet (required) — Select the tab from the chosen document by list, URL, ID, or name.
  • Filters — Add column/value conditions; each matching row must meet the selected filter-combination rule. The default is OR for node versions below 7 and AND for version 7 or later.
  • Options — Choose automatic range detection or specify a range in A1 notation or by rows; row-based ranges also let you set the header and first data row. Set general value output to unformatted values, formatted values, or formulas, and dates to formatted text or serial numbers. Choose whether to return only the first matching row or all matches; the UI uses a boolean for version 9 or later and a first/all selector for earlier versions.

Output shape

A list of items, typically one per returned row.

Returned cell values follow the selected output formatting. The UI describes first-match and all-match behavior, but the supplied source pack only exposes the read operation signatures, not their implementation, so it does not establish additional output details.

Links

Discussion