Sign in

v1

latestOpenAPI 3.0.0Creative Commons Attribution 3.02026-07-1317262210.9 KB
spreadsheets

Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.

get/v4/spreadsheets/{spreadsheetId}/values/{range}

Path parameters

spreadsheetIdstring required

The ID of the spreadsheet to retrieve data from.

rangestring required

The A1 notation or R1C1 notation of the range to retrieve values from.

Query parameters

dateTimeRenderOption'SERIAL_NUMBER' | 'FORMATTED_STRING'

How dates, times, and durations should be represented in the output. This is ignored if value_render_option is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER.

majorDimension'DIMENSION_UNSPECIFIED' | 'ROWS' | 'COLUMNS'

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'FORMATTED_VALUE' | 'UNFORMATTED_VALUE' | 'FORMULA'

How values should be represented in the output. The default render option is FORMATTED_VALUE.

Response

Successful response