scrollport
Back to Connected apps

Spreadsheet Values Update

Google Drive

Replace values in one Google Sheets range.

Capability
Spreadsheet management
Current price
$0.0050/call
Availability
Connected app
Last accepted verification

What this API does

Writes one bounded value matrix using RAW or USER_ENTERED interpretation. Always one upstream request at $0.0050.

Agents select this operation with tool ID google-drive.spreadsheet-values-update, then inspect its current executable contract before a run.

Public input and output shape

Input

bodyobject · required

Bounded request body sent to the connected application.

pathobject · required

Identifier path for the authorised connected-app record.

queryobject · required

Search terms used to find relevant records.

Output

spreadsheetIdstring

Returned spreadsheet id value.

updatedCellsnumber

Returned updated cells value.

updatedColumnsnumber

Returned updated columns value.

updatedRangestring

Returned updated range value.

updatedRowsnumber

Returned updated rows value.

Example request and output

This reviewed worked example is shared with inspect. Inspect also returns the current executable schema and price estimate before a paid run.

Request

{
  "tool_id": "google-drive.spreadsheet-values-update",
  "input": {
    "body": {
      "values": [
        [
          "Workflow",
          "Owner",
          "Status"
        ],
        [
          "Google verification",
          "Scrollport",
          "Ready"
        ]
      ]
    },
    "path": {
      "range": "Plan!A1:C2",
      "spreadsheetId": "YOUR-GOOGLE-SHEETS-SPREADSHEET-ID"
    },
    "query": {
      "valueInputOption": "USER_ENTERED"
    }
  }
}

Output

{
  "updatedRows": 1,
  "updatedCells": 3,
  "updatedRange": "Plan!A2:C2",
  "spreadsheetId": "spreadsheet-output-id",
  "updatedColumns": 3
}
Teaching 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.
Updated
22 August 2026

Use Spreadsheet Values Update with Scrollport

Use Scrollport

Scrollport validates tools for connected apps and provides them on a pay-as-you-go basis so your agent can use accounts you already own without receiving sensitive API keys.

Give your agent the setup prompt to receive $1 in trial credit and start using the tools right away.