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

# spreadsheets_values_get

> Returns a range of values from a spreadsheet.

<div className="tool-route"><span className="tool-row-method" data-method="GET">GET</span><code>{"https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}"}</code></div>

```python gsheets_spreadsheets_values_get.py theme={null}
from charter.packs import gsheets

result = await gsheets.spreadsheets_values_get.ainvoke({"spreadsheetId": ..., "range": ...})
```

<Note>
  Requires `https://www.googleapis.com/auth/spreadsheets`. Costs 1 against the provider's own quota.
</Note>

## Path parameters

<div className="reference-table">
  | Field                                                                 | Type     | Description                                                            |
  | --------------------------------------------------------------------- | -------- | ---------------------------------------------------------------------- |
  | `spreadsheetId` <span className="required" title="required">\*</span> | `string` | The ID of the spreadsheet to retrieve data from.                       |
  | `range` <span className="required" title="required">\*</span>         | `string` | The A1 notation or R1C1 notation of the range to retrieve values from. |
</div>

## Query parameters

<div className="reference-table">
  | Field                  | Type                                                                               | Description                                                                                                                                                                                                                                                                                  |
  | ---------------------- | ---------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `majorDimension`       | [Dimension](/charter/charter/packs/gsheets/values/objects#dimension)                       | The major dimension that results should use. For example, if the spreadsheet data in Sheet1 is: A1=1,B1=2,A2=3,B2=4, then requesting range=Sheet1!A1:B2?majorDimension=ROWS returns \[\[1,2],\[3,4]], whereas requesting range=Sheet1!A1:B2?majorDimension=COLUMNS returns \[\[1,3],\[2,4]]. |
  | `valueRenderOption`    | [ValueRenderOption](/charter/charter/packs/gsheets/values/objects#valuerenderoption)       | How values should be represented in the output. The default render option is FORMATTED\_VALUE.                                                                                                                                                                                               |
  | `dateTimeRenderOption` | [DateTimeRenderOption](/charter/charter/packs/gsheets/values/objects#datetimerenderoption) | How dates, times, and durations should be represented in the output. This is ignored if valueRenderOption is FORMATTED\_VALUE. The default dateTime render option is SERIAL\_NUMBER.                                                                                                         |
</div>