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