Sign in

v1

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

Returns one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges.

get/v4/spreadsheets/{spreadsheetId}/values:batchGet

Path parameters

spreadsheetIdstring required

The ID of the spreadsheet to retrieve data 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 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]].

rangesstring[]

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

valueRenderOption'FORMATTED_VALUE' | 'UNFORMATTED_VALUE' | 'FORMULA'

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

Response

Successful response