openapi: 3.0.0
info:
  title: Google Sheets API
  description: API for retrieving data from Google Sheets
  version: 1.0.0
servers:
  - url: https://sheets.googleapis.com/v4
    description: Google Sheets API Server
paths:
  /spreadsheets/{spreadsheetId}/values/{range}:
    get:
      summary: Retrieve values from a Google Sheet
      description: Fetches values from a specific range in a spreadsheet.
      parameters:
        - name: spreadsheetId
          in: path
          required: true
          schema:
            type: string
          description: The unique ID of the Google Spreadsheet.
        - name: range
          in: path
          required: true
          schema:
            type: string
          description: The range to fetch data from (e.g., "Sheet1!A1:C10").
        - name: key
          in: query
          required: true
          schema:
            type: string
          description: API Key for authentication.
      responses:
        "200":
          description: Successfully retrieved sheet values
          content:
            application/json:
              schema:
                $ref: "#/components/schemas/SheetValues"
        "401":
          description: Unauthorized – Invalid API key
        "404":
          description: Not Found – Spreadsheet or range does not exist

components:
  securitySchemes:
    ApiKeyAuth:
      type: apiKey
      in: query
      name: key
  schemas:
    SheetValues:
      type: object
      properties:
        range:
          type: string
        values:
          type: array
          items:
            type: array
            items:
              type: string

security:
  - ApiKeyAuth: []