Inputs and outputs

Input

pathobject · required

Identifier path for the authorised connected-app record.

queryobject · optional

Search terms used to find relevant records.

Output

propertiesobject

Returned properties value.

sheetsarray

Returned sheets 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-get",
  "input": {
    "path": {
      "spreadsheetId": "YOUR-GOOGLE-SHEETS-SPREADSHEET-ID"
    },
    "query": {
      "fields": "spreadsheetId,properties,sheets.properties",
      "includeGridData": false
    }
  }
}

Output

{
  "sheets": [
    {
      "properties": {
        "title": "Plan",
        "sheetId": 0
      }
    }
  ],
  "properties": {
    "title": "Launch tracker"
  },
  "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 Get

What this API does

Input

Output

Request

Output

Use Spreadsheet Get with Scrollport

Spreadsheet Get

What this API does

Input

Output

Request

Output

Use Spreadsheet Get with Scrollport