Google Sheets Read GPT · GPT-Aktionen

{
  "openapi": "3.1.0",
  "info": {
    "title": "Google Sheets API",
    "description": "Provides access to Google Sheets for reading and manipulating spreadsheet data.",
    "version": "v1.0.0"
  },
  "servers": [
    {
      "url": "https://sheets.googleapis.com"
    }
  ],
  "paths": {
    "/v4/spreadsheets/{spreadsheetId}": {
      "get": {
        "description": "Reads data from a specified Google Sheet.",
        "operationId": "ReadSpreadsheet",
        "parameters": [
          {
            "name": "spreadsheetId",
            "in": "path",
            "description": "The unique identifier for the spreadsheet",
            "required": true,
            "schema": {
              "type": "string"
            }
          },
          {
            "name": "ranges",
            "in": "query",
            "description": "The A1 notation of the ranges to read",
            "required": false,
            "schema": {
              "type": "array",
              "items": {
                "type": "string"
              }
            }
          },
          {
            "name": "includeGridData",
            "in": "query",
            "description": "True if grid data should be returned",
            "required": false,
            "schema": {
              "type": "boolean"
            }
          }
        ],
        "deprecated": false
      }
    },
    "/v4/spreadsheets/{spreadsheetId}/values/{range}": {
      "put": {
        "description": "Updates values in a range of a spreadsheet.",
        "operationId": "UpdateSpreadsheetValues",
        "parameters": [
          {
            "name": "spreadsheetId",
            "in": "path",
            "description": "The unique identifier for the spreadsheet",
            "required": true,
            "schema": {
              "type": "string"
            }
          }
        ],
        "requestBody": {
          "description": "Data to be updated in the specified range",
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "$ref": "#/components/schemas/ValueRange"
              }
            }
          }
        },
        "deprecated": false
      }
    }
  },
  "components": {
    "schemas": {
      "ValueRange": {
        "type": "object",
        "properties": {
          "range": {
            "type": "string"
          },
          "majorDimension": {
            "type": "string"
          },
          "values": {
            "type": "array",
            "items": {
              "type": "array",
              "items": {
                "type": "string"
              }
            }
          }
        }
      }
    }
  }
}