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"
    }
  }
}

Output

{
  "replies": [
    {}
  ],
  "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.

Spreadsheet Batch Update

What this API does

Input

Output

Request

Output

Use Spreadsheet Batch Update with Scrollport

Spreadsheet Batch Update

What this API does

Input

Output

Request

Output

Use Spreadsheet Batch Update with Scrollport