{"command":{"effect":"read","timeoutSeconds":30,"inputSchema":{"type":"object","description":"Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within grids is not returned. You can include grid data in one of 2 ways: * Specify a [field mask](https://developers.google.com/workspace/sheets/api/guides/field-masks) listing your desired fields using the `fields` URL parameter in HTTP * Set the includeGridData URL parameter to true. If a field mask is set, the `includeGridData` parameter is ignored For large spreadsheets, as a best practice, retrieve only the specific spreadsheet fields that you want. To retrieve only subsets of spreadsheet data, use the ranges URL parameter. Ranges are specified using [A1 notation](https://developers.google.com/workspace/sheets/api/guides/concepts#cell). You can define a single cell (for example, `A1`) or multiple cells (for example, `A1:D5`). You can also get cells from other sheets within the same spreadsheet (for example, `Sheet2!A1:C4`) or retrieve multiple ranges at once (for example, `?ranges=A1:D5&ranges=Sheet2!A1:C4`). Limiting the range returns only the portions of the spreadsheet that intersect the requested 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"},"commentsViewMode":{"description":"The comments view mode to apply to the spreadsheet. This allows viewing the spreadsheet with comments omitted or included. If one is not specified, COMMENTS_VIEW_MODE_OMITTED is used.","enum":["COMMENTS_VIEW_MODE_UNSPECIFIED","COMMENTS_VIEW_MODE_DEFAULT_FOR_CURRENT_ACCESS","COMMENTS_VIEW_MODE_OMITTED","COMMENTS_VIEW_MODE_INCLUDED"],"type":"string"},"excludeTablesInBandedRanges":{"description":"True if tables should be excluded in the banded ranges. False if not set.","type":"boolean"},"includeGridData":{"description":"True if grid data should be returned. This parameter is ignored if a field mask was set in the request.","type":"boolean"},"ranges":{"type":"array","items":{"description":"The ranges to retrieve from the spreadsheet.","type":"string"}}},"required":[],"additionalProperties":false},"path":{"type":"object","properties":{"spreadsheetId":{"description":"The spreadsheet to request.","type":"string"}},"required":["spreadsheetId"],"additionalProperties":false}},"required":["path"],"additionalProperties":false},"name":"Returns the spreadsheet at the given ID","id":"google-sheets.sheets.spreadsheets.get","example":{"path":{"spreadsheetId":"example"}},"maxRequests":1,"summary":false}}