mcp-gsheetsTools Reference
sheets_clear_values
Clear cell contents
sheets_clear_values
Clear the contents of cells in a specified range.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The spreadsheet ID |
range | string | Yes | A1 notation range to clear |
Example
{
"tool": "sheets_clear_values",
"arguments": {
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"range": "Sheet1!A1:Z100"
}
}Notes
- Only clears cell values, not formatting
- Use formatting tools to clear cell styles