{"command":{"effect":"read","timeoutSeconds":30,"inputSchema":{"type":"object","description":"Returns one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges.","properties":{"query":{"type":"object","properties":{"$.xgafv":{"description":"V1 error format.","enum":["1","2"],"type":"string"},"fields":{"description":"Selector specifying which fields to include in a partial response.","type":"string"},"prettyPrint":{"default":true,"description":"Returns response with indentations and line breaks.","type":"boolean"},"dateTimeRenderOption":{"description":"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.","enum":["SERIAL_NUMBER","FORMATTED_STRING"],"type":"string"},"majorDimension":{"description":"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]]`.","enum":["DIMENSION_UNSPECIFIED","ROWS","COLUMNS"],"type":"string"},"ranges":{"type":"array","items":{"description":"The [A1 notation or R1C1 notation](https://developers.google.com/workspace/sheets/api/guides/concepts#cell) of the range to retrieve values from.","type":"string"}},"valueRenderOption":{"description":"How values should be represented in the output. The default render option is ValueRenderOption.FORMATTED_VALUE.","enum":["FORMATTED_VALUE","UNFORMATTED_VALUE","FORMULA"],"type":"string"}},"required":[],"additionalProperties":false},"path":{"type":"object","properties":{"spreadsheetId":{"description":"The ID of the spreadsheet to retrieve data from.","type":"string"}},"required":["spreadsheetId"],"additionalProperties":false}},"required":["path"],"additionalProperties":false},"name":"Returns one or more ranges of values from a spreadsheet","id":"google-sheets.sheets.spreadsheets.values.batchget","example":{"path":{"spreadsheetId":"example"}},"maxRequests":1,"summary":false}}