Spreadsheet Batch Update

Google Drive

Apply structural, formatting, formula and copy or paste updates to a Google Sheet.

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

What this API does

Applies up to 100 Sheets requests atomically; the API rejects the whole batch when one request is invalid. Always one upstream request at $0.0025.

Agents select this operation with tool ID google-drive.spreadsheet-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

repliesarray

Returned replies 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-batch-update",
  "input": {
    "body": {
      "requests": [
        {
          "updateSheetProperties": {
            "fields": "gridProperties.frozenRowCount",
            "properties": {
              "sheetId": 863449203,
              "gridProperties": {
                "frozenRowCount": 1
              }
            }
          }
        }
      ]
    },
    "path": {
      "spreadsheetId": "YOUR-GOOGLE-SHEETS-SPREADSHEET-ID"
    }
  }
}

Use Spreadsheet 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.