Spreadsheet Values Get

Google Drive

Read values from one Google Sheets range.

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

What this API does

Returns one value range with selected dimension and rendering options. Always one upstream request at $0.0025.

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

Inputs and outputs

Input

pathobject · required

Identifier path for the authorised connected-app record.

queryobject · optional

Search terms used to find relevant records.

Output

majorDimensionstring

Returned major dimension value.

rangestring

Returned range value.

valuesarray

Returned values 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-get",
  "input": {
    "path": {
      "range": "Plan!A1:C10",
      "spreadsheetId": "YOUR-GOOGLE-SHEETS-SPREADSHEET-ID"
    }
  }
}

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