{"command":{"effect":"write","timeoutSeconds":30,"inputSchema":{"type":"object","description":"Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges. Only values are cleared -- all other properties of the cell (such as formatting and data validation) are kept.","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"}},"required":[],"additionalProperties":false},"path":{"type":"object","properties":{"spreadsheetId":{"description":"The ID of the spreadsheet to update.","type":"string"}},"required":["spreadsheetId"],"additionalProperties":false},"body":{"$ref":"#/definitions/BatchClearValuesRequest"}},"required":["path","body"],"additionalProperties":false,"definitions":{"BatchClearValuesRequest":{"description":"The request for clearing more than one range of values in a spreadsheet.","properties":{"ranges":{"description":"The ranges to clear, in [A1 notation or R1C1 notation](https://developers.google.com/workspace/sheets/api/guides/concepts#cell).","items":{"type":"string"},"type":"array"}},"type":"object"}}},"name":"Clears one or more ranges of values from a spreadsheet","id":"google-sheets.sheets.spreadsheets.values.batchclear","example":{"path":{"spreadsheetId":"example"},"body":{}},"maxRequests":1,"summary":false}}