Spreadsheet Values Clear

Google Drive

Clear values from one Google Sheets range while preserving formatting.

Capability: Spreadsheet management
Current price: $0.0025/request
Availability: Requires connected account

What this API does

Clears only cell values in the selected range; formatting and validation remain. Always one upstream request at $0.0025.

Agents select this operation with tool ID google-drive.spreadsheet-values-clear, then check its current inputs and price before a run.

Inputs and outputs

Input

bodyobject · optional

Bounded request body sent to the connected application.

pathobject · required

Identifier path for the authorised connected-app record.

Output

clearedRangestring

Returned cleared range value.

spreadsheetIdstring

Returned spreadsheet id value.

Example request and output

Inspect returns this reviewed example, its estimated cost and the current input schema. Run calculates the estimate for your actual input.

Request

{
  "tool_id": "google-drive.spreadsheet-values-clear",
  "input": {
    "body": {},
    "path": {
      "range": "Plan!A2:C10",
      "spreadsheetId": "YOUR-GOOGLE-SHEETS-SPREADSHEET-ID"
    }
  }
}

Output

Use Spreadsheet Values Clear with Scrollport

Get started

Connect your app account to let your agent use its tools. Your credentials stay private, and you pay only for successful runs.

Connect your first agent to receive $1 trial credit.

{
  "clearedRange": "Plan!A2:C10",
  "spreadsheetId": "spreadsheet-output-id"
}