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

# Get Sheet

> Retrieve data from Google Sheets

# Get Sheet

The Get Sheet node allows you to retrieve data from Google Sheets documents.

## Overview

This node enables you to:

* Read entire sheets
* Get specific ranges
* Retrieve formatted or raw values
* Access multiple ranges at once
* Get sheet metadata

## Configuration

| Parameter           | Type    | Description                                            |
| ------------------- | ------- | ------------------------------------------------------ |
| Spreadsheet ID      | String  | The ID of the Google Sheet                             |
| Range               | String  | Range to read (e.g., 'Sheet1!A1:D10')                  |
| Include Headers     | Boolean | Whether to include header row                          |
| Value Render Option | String  | How to render values (FORMATTED/UNFORMATTED)           |
| Date Time Option    | String  | How to render dates (SERIAL\_NUMBER/FORMATTED\_STRING) |

## Authentication

This node requires:

* Google Cloud Project
* Google Sheets API enabled
* Service account or OAuth2 credentials
* Read access to the spreadsheet

## Output

The node returns:

* Retrieved data as array
* Range information
* Sheet metadata
* Error messages if operation fails

## Example Usage

```json theme={null}
{
  "spreadsheet_id": "1234567890abcdef",
  "range": "Sheet1!A1:D10",
  "include_headers": true,
  "value_render_option": "FORMATTED_VALUE",
  "date_time_option": "FORMATTED_STRING"
}
```

## Response Format

```json theme={null}
{
  "values": [
    ["Header1", "Header2", "Header3"],
    ["Value1", "Value2", "Value3"]
    // ... more rows
  ],
  "range": "Sheet1!A1:D10",
  "majorDimension": "ROWS"
}
```