bodyobject · optionalBounded request body sent to the connected application.
Loading tools…
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
pathobject · requiredIdentifier path for the authorised connected-app record.
Output
clearedRangestringReturned cleared range value.
spreadsheetIdstringReturned 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
{
"clearedRange": "Plan!A2:C10",
"spreadsheetId": "spreadsheet-output-id"
}Errors and limitations
connection_required: This capability acts on the connected Google Workspace, which is not available yet.Open connect_url, approve Google Drive access, then retry this run unchanged.
Use Spreadsheet Values Clear with Scrollport
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.