Google Sheets

GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR

Tool to clear one or more ranges of values from a spreadsheet. Use when you need to remove data from specific cells or ranges while keeping formatting and other properties intact.

Remote googlesheets

Other tools also called GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR? See providers with this name

Input Schema


            {
  "type": "object",
  "properties": {
    "ranges": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "The ranges to clear, in A1 notation or R1C1 notation.\nExample: [\"Sheet1!A1:B2\",\"Sheet1!C3:D4\"]"
    },
    "spreadsheet_id": {
      "type": "string",
      "description": "The ID of the spreadsheet to update.\nExample: \"1q2w3e4r5t6y7u8i9o0p\""
    }
  }
}