> ## Documentation Index
> Fetch the complete documentation index at: https://learn.workflow.dog/llms.txt
> Use this file to discover all available pages before exploring further.

# Get Table Row Range(s)

> Read one or more inclusive row ranges as table objects.

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.

## Outputs

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

## Troubleshooting

<AccordionGroup>
  <Accordion title="End row must be greater than or equal to start row">
    Reverse the bounds for the affected range. Both endpoints are inclusive.
  </Accordion>
</AccordionGroup>