Google Sheets

GOOGLESHEETS_CLEAR_VALUES

Clears cell content (preserving formatting and notes) from a specified A1 notation range in a Google Spreadsheet; the range must correspond to an existing sheet and cells.

Remote googlesheets

Other tools also called GOOGLESHEETS_CLEAR_VALUES? See providers with this name

Input Schema


            {
  "type": "object",
  "properties": {
    "range": {
      "type": "string",
      "description": "The A1 notation of the range to clear values from (e.g., 'Sheet1!A1:B2', 'MySheet!C:C', or 'A1:D5'). If the sheet name is omitted (e.g., 'A1:B2'), the operation applies to the first visible sheet.\nExamples:\n  \"Sheet1!A1:B10\"\n  \"Sheet2!C:D\"\n  \"A1:Z100\"\n  \"My Custom Sheet!B3:F10\""
    },
    "spreadsheet_id": {
      "type": "string",
      "description": "The unique identifier of the Google Spreadsheet from which to clear values. This ID can be found in the URL of the spreadsheet.\nExamples:\n  \"1qZ_g6N0g3Z0s5hJ2xQ8vP9r7T_u6X3iY2o0kE_l5N7M\"\n  \"spreαdsheetId_from_url\""
    }
  }
}