scrollport

Spreadsheet Values Update

Google Drive

Replace values in one Google Sheets range.

Use this tool with your AI agent

  1. Copy the prompt
  2. Paste it into your agent
  3. Tell it what you need

Read https://scrollport.com/start. Use my existing Scrollport connection, or help me connect if needed. Help me use Spreadsheet Values Update (tool ID: google-drive.spreadsheet-values-update). Ask me for the details you need, then show me the result. Help me connect the required app account if needed.

Already connected
Your agent can use that connection.
New user
Your agent will guide you through setup, sign-in and authorisation.

This tool also needs you to connect your app account.

Connect your first agent to receive $1 trial credit.

Job
Read and update Google Sheets
Current price
$0.0025/request
Availability
Requires connected account

Tool details

About this tool

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

Inputs and outputs

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

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