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

> Returns one or more ranges 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:batchGet"}</code></div>

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

result = await gsheets.spreadsheets_values_batch_get.ainvoke({"spreadsheetId": ..., "ranges": ...})
```

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

## Query parameters

<div className="reference-table">
  | Field                                                          | Type                                                                               | Description                                                                                                                                                                                                                                                                      |
  | -------------------------------------------------------------- | ---------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `ranges` <span className="required" title="required">\*</span> | `string`\[]                                                                        | The A1 notation or R1C1 notation of the range to retrieve values from. <span className="field-constraints">min 1 items</span>                                                                                                                                                    |
  | `majorDimension`                                               | [Dimension](/charter/charter/packs/gsheets/values/objects#dimension)                       | The major dimension that results should use. For example, if the spreadsheet data is: A1=1,B1=2,A2=3,B2=4, then requesting ranges=\["A1:B2"],majorDimension=ROWS returns \[\[1,2],\[3,4]], whereas requesting ranges=\["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>