Spreadsheet Values Batch Update

Google Drive

Replace values in multiple Google Sheets ranges.

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

What this API does

Writes up to 100 value ranges with one input interpretation and optional returned values. Always one upstream request at $0.0025.

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

Inputs and outputs

Input

bodyobject · required

Bounded request body sent to the connected application.

pathobject · required

Identifier path for the authorised connected-app record.

Output

spreadsheetIdstring

Returned spreadsheet id value.

totalUpdatedCellsnumber

Returned total updated cells value.

totalUpdatedColumnsnumber

Returned total updated columns value.

totalUpdatedRowsnumber

Returned total updated rows 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-batch-update",
  "input": {
    "body": {
      "data": [
        {
          "range": "Plan!A3:C3",
          "values": [
            [
              1,
              2,
              3
            ]
          ]
        }
      ],
      "valueInputOption": "RAW"
    },
    "path": {
      "spreadsheetId": "YOUR-GOOGLE-SHEETS-SPREADSHEET-ID"
    }
  }
}

Output

{
  "spreadsheetId": "spreadsheet-output-id",
  "totalUpdatedRows": 1,
  "totalUpdatedCells": 3,
  "totalUpdatedColumns": 3
}

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 Batch Update 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.