Get Table Row Range(s)

The Get Table Row Range(s) action reads inclusive row-number ranges and maps their cells to table headers.

Inputs

Input	Type	Required	Description
Third-party account	Google account	Yes	Account with read access.
Spreadsheet ID or URL	String	Yes	Spreadsheet containing the table.
Sheet Name	String	Yes	Sheet tab to read.
Row Ranges	List of ranges	Yes	Start Row and inclusive End Row for each range.
Header Row Number	Number	No	One-based header position. Defaults to `1`.
Return Formatted Values	Boolean	No	Return display text instead of raw values. Default `false`.

Every row number is one-based and absolute within the sheet. An end row smaller than its start row is rejected.

Output	Type	Description
Row Count	Number	Number of rows actually returned.
Rows	List of row objects	Rows keyed by header text, flattened across ranges.

The result can contain fewer rows than requested when the sheet has no values for some positions.

End row must be greater than or equal to start row

Reverse the bounds for the affected range. Both endpoints are inclusive.