- HTTP request
- Path parameters
- Query parameters
- Request body
- Response body
- Authorization scopes
- Try it!
Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.
HTTP request
GET https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}
The URL uses gRPC Transcoding syntax.
Path parameters
| Parameters | |
|---|---|
spreadsheetId
|
The ID of the spreadsheet to retrieve data from. |
range
|
The A1 notation or R1C1 notation of the range to retrieve values from. |
Query parameters
| Parameters | |
|---|---|
majorDimension
|
The major dimension that results should use. For example, if the spreadsheet data in Sheet1 is: |
valueRenderOption
|
How values should be represented in the output. The default render option is |
dateTimeRenderOption
|
How dates, times, and durations should be represented in the output. This is ignored if |
Request body
The request body must be empty.
Response body
If successful, the response body contains an instance of ValueRange
.
Authorization scopes
Requires one of the following OAuth scopes:
-
https://www.googleapis.com/auth/drive -
https://www.googleapis.com/auth/drive.readonly -
https://www.googleapis.com/auth/drive.file -
https://www.googleapis.com/auth/spreadsheets -
https://www.googleapis.com/auth/spreadsheets.readonly
For more information, see the Authorization guide .
