Inputs and outputs

Input

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.

valueRangesarray

Returned value ranges 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-batch-get",
  "input": {
    "path": {
      "spreadsheetId": "YOUR-GOOGLE-SHEETS-SPREADSHEET-ID"
    },
    "query": {
      "ranges": [
        "Plan!A1:C10",
        "Plan!A1:B5"
      ]
    }
  }
}

Output

{
  "valueRanges": [
    {
      "range": "Plan!A1:C3",
      "values": [
        [
          "Task",
          "Owner",
          "Status"
        ]
      ]
    }
  ],
  "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 Values Batch Get

What this API does

Input

Output

Request

Output

Use Spreadsheet Values Batch Get with Scrollport

Spreadsheet Values Batch Get

What this API does

Input

Output

Request

Output

Use Spreadsheet Values Batch Get with Scrollport