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

# Read Range

> Read a Google Sheets range as rows or columns.

The **Read Range** action reads cell values from an A1 range. Choose whether
the outer output list represents rows or columns and whether values use their
display formatting.

## Inputs

| Input                       | Type                | Required | Description                                                    |
| --------------------------- | ------------------- | -------- | -------------------------------------------------------------- |
| **Third-party account**     | Google account      | Yes      | Account with read access.                                      |
| **Spreadsheet ID or URL**   | String              | Yes      | Spreadsheet to read.                                           |
| **Range**                   | String              | Yes      | A1 range, such as `Sheet1!A1:B20`.                             |
| **Major Dimension**         | `Rows` or `Columns` | No       | Structure of the outer list. Defaults to **Rows**.             |
| **Return Formatted Values** | Boolean             | No       | Return display strings instead of raw values. Default `false`. |

## Outputs

| Output                  | Type          | Description                                          |
| ----------------------- | ------------- | ---------------------------------------------------- |
| **Rows** or **Columns** | List of lists | Cell values grouped by the selected major dimension. |

Formatted values preserve display text such as `$1,234.00` or a rendered date.
Raw values are better for numeric comparisons and calculations.

<Note>
  Sheets can omit trailing empty cells and rows from returned arrays. Do not
  assume every inner list has the full requested width.
</Note>

## Example

```text theme={null}
Google Sheets: Read Range (Sheet1!A2:D)
  → Repeat over Rows
  → Process each row's cells
```