Returns one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges.
Path parameters
The ID of the spreadsheet to retrieve data from.
Query parameters
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.
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]].
The A1 notation or R1C1 notation of the range to retrieve values from.
How values should be represented in the output. The default render option is ValueRenderOption.FORMATTED_VALUE.
Response
Successful response