{"command":{"effect":"read","timeoutSeconds":30,"inputSchema":{"type":"object","description":"Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.","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 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]]`.","enum":["DIMENSION_UNSPECIFIED","ROWS","COLUMNS"],"type":"string"},"valueRenderOption":{"description":"How values should be represented in the output. The default render option is FORMATTED_VALUE.","enum":["FORMATTED_VALUE","UNFORMATTED_VALUE","FORMULA"],"type":"string"}},"required":[],"additionalProperties":false},"path":{"type":"object","properties":{"range":{"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"},"spreadsheetId":{"description":"The ID of the spreadsheet to retrieve data from.","type":"string"}},"required":["range","spreadsheetId"],"additionalProperties":false}},"required":["path"],"additionalProperties":false},"name":"Returns a range of values from a spreadsheet","id":"google-sheets.sheets.spreadsheets.values.get","example":{"path":{"range":"example","spreadsheetId":"example"}},"maxRequests":1,"summary":false}}