Layero Google Sheets API

The google_sheets API from Layero — 4 operation(s) for google_sheets.

GitHub OpenAPI

Operations 5

GET /projects/{project_id}/integrations/google-sheets Get Google Sheets Integration #
DELETE /projects/{project_id}/integrations/google-sheets Disconnect Google Sheets #
POST /projects/{project_id}/integrations/google-sheets/connect Connect Google Sheets #
GET /integrations/google-sheets/start Start Google Sheets #
GET /integrations/google-sheets/callback Google Sheets Callback #

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API
curl "https://apis.io/api/v1/apis/layero-ru:layero-ru-google-sheets-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. By signing up you are subscribing to the APIs.io and API Evangelist newsletters — you can unsubscribe from any issue. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

layero-ru-google-sheets-api-openapi.yml Raw ↑
openapi: 3.2.0
info:
  title: Layero Google Sheets API
  version: 0.1.0
tags:
- name: google_sheets
paths:
  /projects/{project_id}/integrations/google-sheets:
    get:
      tags:
      - google_sheets
      summary: Get Google Sheets Integration
      operationId: get_google_sheets_integration_projects__project_id__integrations_google_sheets_get
      parameters:
      - name: project_id
        in: path
        required: true
        schema:
          type: string
          format: uuid
          title: Project Id
      - name: authorization
        in: header
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Authorization
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response Get Google Sheets Integration Projects  Project Id  Integrations Google Sheets Get
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
    delete:
      tags:
      - google_sheets
      summary: Disconnect Google Sheets
      description: 'Drop the integration row. The spreadsheet stays in the user''s Drive, and

        submissions keep being collected (they just stop syncing until reconnect).'
      operationId: disconnect_google_sheets_projects__project_id__integrations_google_sheets_delete
      parameters:
      - name: project_id
        in: path
        required: true
        schema:
          type: string
          format: uuid
          title: Project Id
      - name: authorization
        in: header
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Authorization
      responses:
        '204':
          description: Successful Response
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /projects/{project_id}/integrations/google-sheets/connect:
    post:
      tags:
      - google_sheets
      summary: Connect Google Sheets
      description: Start the Google OAuth flow. Returns the Google authorize URL.
      operationId: connect_google_sheets_projects__project_id__integrations_google_sheets_connect_post
      parameters:
      - name: project_id
        in: path
        required: true
        schema:
          type: string
          format: uuid
          title: Project Id
      - name: authorization
        in: header
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Authorization
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                title: Response Connect Google Sheets Projects  Project Id  Integrations Google Sheets Connect Post
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /integrations/google-sheets/start:
    get:
      tags:
      - google_sheets
      summary: Start Google Sheets
      description: 'Верхнеуровневый вход в поток привязки: ставит куку-нонс и ведёт к Google.


        Зачем отдельная ручка, а не редирект из панели по `oauth_url`. Куку обязан

        поставить НАШ ответ в first-party-контексте, иначе браузер её не сохранит:

        панель живёт на `app.layero.ru`, API — на `api.layero.ru`, и XHR между

        ними кросс-сайтовый, а axios-клиент создан без `withCredentials`.


        Аутентификация билетом, а не заголовком: верхнеуровневый переход не несёт

        JWT (он в localStorage). Билет выдаёт `/connect` по `Authorization` и живёт

        пять минут. T-20260807-4.'
      operationId: start_google_sheets_integrations_google_sheets_start_get
      parameters:
      - name: ticket
        in: query
        required: true
        schema:
          type: string
          description: Билет из /connect. НЕ сессионный токен.
          title: Ticket
        description: Билет из /connect. НЕ сессионный токен.
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema: {}
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
  /integrations/google-sheets/callback:
    get:
      tags:
      - google_sheets
      summary: Google Sheets Callback
      description: OAuth redirect target (dedicated, so login and this flow never mix).
      operationId: google_sheets_callback_integrations_google_sheets_callback_get
      parameters:
      - name: code
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Code
      - name: state
        in: query
        required: true
        schema:
          type: string
          title: State
      - name: error
        in: query
        required: false
        schema:
          anyOf:
          - type: string
          - type: 'null'
          title: Error
      responses:
        '200':
          description: Successful Response
          content:
            application/json:
              schema: {}
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
components:
  schemas:
    ValidationError:
      properties:
        loc:
          items:
            anyOf:
            - type: string
            - type: integer
          type: array
          title: Location
        msg:
          type: string
          title: Message
        type:
          type: string
          title: Error Type
        input:
          title: Input
        ctx:
          type: object
          title: Context
      type: object
      required:
      - loc
      - msg
      - type
      title: ValidationError
    HTTPValidationError:
      properties:
        detail:
          items:
            $ref: '#/components/schemas/ValidationError'
          type: array
          title: Detail
      type: object
      title: HTTPValidationError