Google Sheet API

openapi: 3.1.0
info:
  title: Google Books About Sheet API
  description: API for retrieving Bookshelf and Volume resources from Google Books
  version: 1.0.0
  contact:
    name: Google Books API
    url: https://developers.google.com/books
servers:
- url: https://www.googleapis.com/books/v1
  description: Google Books API v1
tags:
- name: Sheet
  description: Operations related to Sheet
paths:
  /v4/spreadsheets:
    post:
      tags:
      - Sheet
      summary: Google Create Sheet
      description: Creates a spreadsheet, returning the newly created spreadsheet.
      security:
      - oauth2Auth: []
      parameters:
      - name: Content-Type
        in: header
        schema:
          type: string
        example: application/json
      - name: Accept
        in: header
        schema:
          type: string
        example: application/json
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/SpreadsheetsPostRequest'
      responses:
        '200':
          description: OK
          headers:
            Content-Type:
              schema:
                type: string
                example: application/json
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SpreadsheetsPostResponse'
              examples:
                SpreadsheetsPostResponseExample:
                  $ref: '#/components/examples/SpreadsheetsPostResponseExample'
      x-api-evangelist-processing:
        ChooseTags: true
      x-microcks-operation:
        delay: 100
        dispatcher: FALLBACK
        dispatcherRules: SpreadsheetsPostResponseExample
  /v4/spreadsheets/{spreadsheetId}:
    get:
      tags:
      - Sheet
      summary: Google Get Sheet
      description: 'Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within grids is not returned. You can include grid data in one of 2 ways: * Specify a [field mask](https://developers.google.com/sheets/api/guides/field-masks) listing your desired fields using the `fields` URL parameter in HTTP * Set the includeGridData URL parameter to true. If a field mask is set, the `includeGridData` parameter is ignored For large spreadsheets, as a best practice, retrieve only the specific spreadsheet fields that you want. To retrieve only subsets of spreadsheet data, use the ranges URL parameter. Ranges are specified using [A1 notation](/sheets/api/guides/concepts#cell). You can define a single cell (for example, `A1`) or multiple cells (for example, `A1:D5`). You can also get cells from other sheets within the same spreadsheet (for example, `Sheet2!A1:C4`) or retrieve multiple ranges at once (for example, `?ranges=A1:D5&ranges=Sheet2!A1:C4`). Limiting the range returns only the portions of the spreadsheet that intersect the requested ranges.'
      security:
      - oauth2Auth: []
      parameters:
      - name: Accept
        in: header
        schema:
          type: string
        example: application/json
      - name: spreadsheetId
        in: path
        schema:
          type: string
        required: true
        description: '(Required) '
        example: '{{spreadsheetId}}'
      responses:
        '200':
          description: OK
          headers:
            Content-Type:
              schema:
                type: string
                example: application/json
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SpreadsheetsGetResponse'
              examples:
                SpreadsheetsGetResponseExample:
                  $ref: '#/components/examples/SpreadsheetsGetResponseExample'
      x-api-evangelist-processing:
        ChooseTags: true
      x-microcks-operation:
        delay: 100
        dispatcher: FALLBACK
        dispatcherRules: SpreadsheetsGetResponseExample
  /v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo:
    post:
      tags:
      - Sheet
      summary: Google Copy To Sheet
      description: Copies a single sheet from a spreadsheet to another spreadsheet. Returns the properties of the newly created sheet.
      security:
      - oauth2Auth: []
      parameters:
      - name: Content-Type
        in: header
        schema:
          type: string
        example: application/json
      - name: Accept
        in: header
        schema:
          type: string
        example: application/json
      - name: spreadsheetId
        in: path
        schema:
          type: string
        required: true
        description: '(Required) '
        example: '{{spreadsheetId}}'
      - name: sheetId
        in: path
        schema:
          type: string
        required: true
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/SpreadsheetsSheetsPostRequest'
      responses:
        '200':
          description: OK
          headers:
            Content-Type:
              schema:
                type: string
                example: application/json
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SpreadsheetsSheetsPostResponse'
              examples:
                SpreadsheetsSheetsPostResponseExample:
                  $ref: '#/components/examples/SpreadsheetsSheetsPostResponseExample'
      x-api-evangelist-processing:
        ChooseTags: true
      x-microcks-operation:
        delay: 100
        dispatcher: FALLBACK
        dispatcherRules: SpreadsheetsSheetsPostResponseExample
  /v4/spreadsheets/{spreadsheetId}:getByDataFilter:
    post:
      tags:
      - Sheet
      summary: Google Get Sheet by Data Filter
      description: 'Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. This method differs from GetSpreadsheet in that it allows selecting which subsets of spreadsheet data to return by specifying a dataFilters parameter. Multiple DataFilters can be specified. Specifying one or more data filters returns the portions of the spreadsheet that intersect ranges matched by any of the filters. By default, data within grids is not returned. You can include grid data one of 2 ways: * Specify a [field mask](https://developers.google.com/sheets/api/guides/field-masks) listing your desired fields using the `fields` URL parameter in HTTP * Set the includeGridData parameter to true. If a field mask is set, the `includeGridData` parameter is ignored For large spreadsheets, as a best practice, retrieve only the specific spreadsheet fields that you want.'
      security:
      - oauth2Auth: []
      parameters:
      - name: Content-Type
        in: header
        schema:
          type: string
        example: application/json
      - name: Accept
        in: header
        schema:
          type: string
        example: application/json
      - name: spreadsheetId
        in: path
        schema:
          type: string
        required: true
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/SpreadsheetsPostRequest2'
      responses:
        '200':
          description: OK
          headers:
            Content-Type:
              schema:
                type: string
                example: application/json
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SpreadsheetsPostResponse2'
              examples:
                SpreadsheetsPostResponse2Example:
                  $ref: '#/components/examples/SpreadsheetsPostResponse2Example'
      x-api-evangelist-processing:
        ChooseTags: true
      x-microcks-operation:
        delay: 100
        dispatcher: FALLBACK
        dispatcherRules: SpreadsheetsPostResponse2Example
components:
  schemas:
    SpreadsheetsGetResponsePropertiesDefaultFormat:
      description: SpreadsheetsGetResponsePropertiesDefaultFormat schema
      type: object
      properties:
        backgroundColor:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatBackgroundColor'
        backgroundColorStyle:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatBackgroundColorStyle'
        borders:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatBorders'
        horizontalAlignment:
          type: string
        hyperlinkDisplayType:
          type: string
        numberFormat:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatNumberFormat'
        padding:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatPadding'
        textDirection:
          type: string
        textFormat:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatTextFormat'
        textRotation:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatTextRotation'
        verticalAlignment:
          type: string
        wrapStrategy:
          type: string
    SpreadsheetsPostResponsePropertiesDefaultFormatBordersTopColorStyleRgbColor:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatBordersTopColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponsePropertiesDefaultFormatBordersLeftColorStyleRgbColor:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatBordersLeftColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponsePropertiesDefaultFormatBordersLeft:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatBordersLeft schema
      type: object
      properties:
        color:
          $ref: '#/components/schemas/SpreadsheetsPostResponsePropertiesDefaultFormatBordersLeftColor'
        colorStyle:
          $ref: '#/components/schemas/SpreadsheetsPostResponsePropertiesDefaultFormatBordersLeftColorStyle'
        style:
          type: string
        width:
          type: integer
    SpreadsheetsGetResponsePropertiesDefaultFormatTextRotation:
      description: SpreadsheetsGetResponsePropertiesDefaultFormatTextRotation schema
      type: object
      properties:
        angle:
          type: integer
        vertical:
          type: boolean
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeft:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeft schema
      type: object
      properties:
        color:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColor'
        colorStyle:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColorStyle'
        style:
          type: string
        width:
          type: integer
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColorStyleRgbColor:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsGetResponsePropertiesDefaultFormatBordersRightColor:
      description: SpreadsheetsGetResponsePropertiesDefaultFormatBordersRightColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersBottomColorStyle:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersBottomColorStyle schema
      type: object
      properties:
        rgbColor:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersBottomColorStyleRgbColor'
        themeColor:
          type: string
    SpreadsheetsSheetsPostResponse:
      description: SpreadsheetsSheetsPostResponse schema
      type: object
      properties:
        dataSourceSheetProperties:
          $ref: '#/components/schemas/SpreadsheetsSheetsPostResponseDataSourceSheetProperties'
        gridProperties:
          $ref: '#/components/schemas/SpreadsheetsSheetsPostResponseGridProperties'
        hidden:
          type: boolean
        index:
          type: integer
        rightToLeft:
          type: boolean
        sheetId:
          type: integer
        sheetType:
          type: string
        tabColor:
          $ref: '#/components/schemas/SpreadsheetsSheetsPostResponseTabColor'
        tabColorStyle:
          $ref: '#/components/schemas/SpreadsheetsSheetsPostResponseTabColorStyle'
        title:
          type: string
    SpreadsheetsPostResponse2PropertiesIterativeCalculationSettings:
      description: SpreadsheetsPostResponse2PropertiesIterativeCalculationSettings schema
      type: object
      properties:
        convergenceThreshold:
          type: number
        maxIterations:
          type: integer
    SpreadsheetsPostResponsePropertiesDefaultFormatBordersTopColor:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatBordersTopColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersTopColorStyle:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersTopColorStyle schema
      type: object
      properties:
        rgbColor:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersTopColorStyleRgbColor'
        themeColor:
          type: string
    SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormatForegroundColorStyleRgbColor:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormatForegroundColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersRightColor:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersRightColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponsePropertiesDefaultFormatBordersTopColorStyle:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatBordersTopColorStyle schema
      type: object
      properties:
        rgbColor:
          $ref: '#/components/schemas/SpreadsheetsPostResponsePropertiesDefaultFormatBordersTopColorStyleRgbColor'
        themeColor:
          type: string
    SpreadsheetsPostResponsePropertiesDefaultFormatBordersRight:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatBordersRight schema
      type: object
      properties:
        color:
          $ref: '#/components/schemas/SpreadsheetsPostResponsePropertiesDefaultFormatBordersRightColor'
        colorStyle:
          $ref: '#/components/schemas/SpreadsheetsPostResponsePropertiesDefaultFormatBordersRightColorStyle'
        style:
          type: string
        width:
          type: integer
    SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormatForegroundColor:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormatForegroundColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormat:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormat schema
      type: object
      properties:
        bold:
          type: boolean
        fontFamily:
          type: string
        fontSize:
          type: integer
        foregroundColor:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormatForegroundColor'
        foregroundColorStyle:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormatForegroundColorStyle'
        italic:
          type: boolean
        link:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormatLink'
        strikethrough:
          type: boolean
        underline:
          type: boolean
    SpreadsheetsPostResponse2PropertiesDefaultFormatBackgroundColorStyleRgbColor:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBackgroundColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsGetResponsePropertiesDefaultFormatBordersTopColor:
      description: SpreadsheetsGetResponsePropertiesDefaultFormatBordersTopColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersBottomColorStyleRgbColor:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersBottomColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponse2PropertiesDefaultFormatNumberFormat:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatNumberFormat schema
      type: object
      properties:
        pattern:
          type: string
        type:
          type: string
    SpreadsheetsPostResponsePropertiesDefaultFormatTextRotation:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatTextRotation schema
      type: object
      properties:
        angle:
          type: integer
        vertical:
          type: boolean
    SpreadsheetsGetResponsePropertiesDefaultFormatTextFormatForegroundColorStyle:
      description: SpreadsheetsGetResponsePropertiesDefaultFormatTextFormatForegroundColorStyle schema
      type: object
      properties:
        rgbColor:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatTextFormatForegroundColorStyleRgbColor'
        themeColor:
          type: string
    SpreadsheetsSheetsPostResponseTabColor:
      description: SpreadsheetsSheetsPostResponseTabColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsGetResponsePropertiesDefaultFormatPadding:
      description: SpreadsheetsGetResponsePropertiesDefaultFormatPadding schema
      type: object
      properties:
        bottom:
          type: integer
        left:
          type: integer
        right:
          type: integer
        top:
          type: integer
    SpreadsheetsGetResponsePropertiesDefaultFormatBorders:
      description: SpreadsheetsGetResponsePropertiesDefaultFormatBorders schema
      type: object
      properties:
        bottom:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatBordersBottom'
        left:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatBordersLeft'
        right:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatBordersRight'
        top:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatBordersTop'
    SpreadsheetsPostResponsePropertiesDefaultFormatBordersBottom:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatBordersBottom schema
      type: object
      properties:
        color:
          $ref: '#/components/schemas/SpreadsheetsPostResponsePropertiesDefaultFormatBordersBottomColor'
        colorStyle:
          $ref: '#/components/schemas/SpreadsheetsPostResponsePropertiesDefaultFormatBordersBottomColorStyle'
        style:
          type: string
        width:
          type: integer
    SpreadsheetsPostResponsePropertiesDefaultFormatBordersBottomColorStyleRgbColor:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatBordersBottomColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersTop:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersTop schema
      type: object
      properties:
        color:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersTopColor'
        colorStyle:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersTopColorStyle'
        style:
          type: string
        width:
          type: integer
    SpreadsheetsPostRequest2:
      description: SpreadsheetsPostRequest2 schema
      type: object
      example:
        dataFilters:
        - a1Range: tempor culpa in
          developerMetadataLookup:
            locationMatchingStrategy: EXACT_LOCATION
            locationType: DEVELOPER_METADATA_LOCATION_TYPE_UNSPECIFIED
            metadataId: 38631502
            metadataKey: nisi volupt
            metadataLocation:
              dimensionRange:
                dimension: DIMENSION_UNSPECIFIED
                endIndex: 63439729
                sheetId: -25406806
                startIndex: 35052771
              locationType: SHEET
              sheetId: 11542900
              spreadsheet: false
            metadataValue: in nostrud labore enim sint
            visibility: DEVELOPER_METADATA_VISIBILITY_UNSPECIFIED
          gridRange:
            endColumnIndex: 23894477
            endRowIndex: -48431467
            sheetId: -4486644
            startColumnIndex: 74711378
            startRowIndex: 6303367
        - a1Range: occaecat non consectetur
          developerMetadataLookup:
            locationMatchingStrategy: INTERSECTING_LOCATION
            locationType: SHEET
            metadataId: 43386196
            metadataKey: aliqua nulla
            metadataLocation:
              dimensionRange:
                dimension: COLUMNS
                endIndex: -12105509
                sheetId: 31623920
                startIndex: -90047308
              locationType: DEVELOPER_METADATA_LOCATION_TYPE_UNSPECIFIED
              sheetId: 66134968
              spreadsheet: false
            metadataValue: consequat
            visibility: DOCUMENT
          gridRange:
            endColumnIndex: -29841116
            endRowIndex: 41097577
            sheetId: -38508617
            startColumnIndex: -53934581
            startRowIndex: 18701599
        includeGridData: true
    SpreadsheetsGetResponsePropertiesDefaultFormatBordersBottom:
      description: SpreadsheetsGetResponsePropertiesDefaultFormatBordersBottom schema
      type: object
      properties:
        color:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatBordersBottomColor'
        colorStyle:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatBordersBottomColorStyle'
        style:
          type: string
        width:
          type: integer
    SpreadsheetsSheetsPostResponseTabColorStyle:
      description: SpreadsheetsSheetsPostResponseTabColorStyle schema
      type: object
      properties:
        rgbColor:
          $ref: '#/components/schemas/SpreadsheetsSheetsPostResponseTabColorStyleRgbColor'
        themeColor:
          type: string
    SpreadsheetsSheetsPostResponseDataSourceSheetPropertiesDataExecutionStatus:
      description: SpreadsheetsSheetsPostResponseDataSourceSheetPropertiesDataExecutionStatus schema
      type: object
      properties:
        errorCode:
          type: string
        errorMessage:
          type: string
        lastRefreshTime:
          type: string
        state:
          type: string
    SpreadsheetsPostResponseProperties:
      description: SpreadsheetsPostResponseProperties schema
      type: object
      properties:
        autoRecalc:
          type: string
        defaultFormat:
          $ref: '#/components/schemas/SpreadsheetsPostResponsePropertiesDefaultFormat'
        iterativeCalculationSettings:
          $ref: '#/components/schemas/SpreadsheetsPostResponsePropertiesIterativeCalculationSettings'
        locale:
          type: string
        spreadsheetTheme:
          $ref: '#/components/schemas/SpreadsheetsPostResponsePropertiesSpreadsheetTheme'
        timeZone:
          type: string
        title:
          type: string
    SpreadsheetsGetResponsePropertiesDefaultFormatBordersRight:
      description: SpreadsheetsGetResponsePropertiesDefaultFormatBordersRight schema
      type: object
      properties:
        color:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatBordersRightColor'
        colorStyle:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatBordersRightColorStyle'
        style:
          type: string
        width:
          type: integer
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColorStyle:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColorStyle schema
      type: object
      properties:
        rgbColor:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColorStyleRgbColor'
        themeColor:
          type: string
    SpreadsheetsGetResponsePropertiesDefaultFormatBordersBottomColorStyle:
      description: SpreadsheetsGetResponsePropertiesDefaultFormatBordersBottomColorStyle schema
      type: object
      properties:
        rgbColor:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatBordersBottomColorStyleRgbColor'
        themeColor:
          type: string
    SpreadsheetsPostResponsePropertiesDefaultFormatBordersBottomColor:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatBordersBottomColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsGetResponsePropertiesDefaultFormatBordersLeft:
      description: SpreadsheetsGetResponsePropertiesDefaultFormatBordersLeft schema
      type: object
      properties:
        color:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatBordersLeftColor'
        colorStyle:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatBordersLeftColorStyle'
        style:
          type: string
        width:
          type: integer
    SpreadsheetsGetResponsePropertiesDefaultFormatTextFormat:
      description: SpreadsheetsGetResponsePropertiesDefaultFormatTextFormat schema
      type: object
      properties:
        bold:
          type: boolean
        fontFamily:
          type: string
        fontSize:
          type: integer
        foregroundColor:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatTextFormatForegroundColor'
        foregroundColorStyle:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatTextFormatForegroundColorStyle'
        italic:
          type: boolean
        link:
          $ref: '#/components/schemas/SpreadsheetsGetResponsePropertiesDefaultFormatTextFormatLink'
        strikethrough:
          type: boolean
        underline:
          type: boolean
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersTopColorStyleRgbColor:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersTopColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponsePropertiesDefaultFormatTextFormatForegroundColorStyleRgbColor:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatTextFormatForegroundColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponsePropertiesDefaultFormatBackgroundColorStyleRgbColor:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatBackgroundColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponsePropertiesDefaultFormatNumberFormat:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatNumberFormat schema
      type: object
      properties:
        pattern:
          type: string
        type:
          type: string
    SpreadsheetsPostResponsePropertiesDefaultFormatTextFormatLink:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatTextFormatLink schema
      type: object
      properties:
        uri:
          type: string
    SpreadsheetsPostResponse2PropertiesDefaultFormatBorders:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBorders schema
      type: object
      properties:
        bottom:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersBottom'
        left:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeft'
        right:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersRight'
        top:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersTop'
    SpreadsheetsPostResponse2PropertiesDefaultFormatTextRotation:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatTextRotation schema
      type: object
      properties:
        angle:
          type: integer
        vertical:
          type: boolean
    SpreadsheetsPostResponsePropertiesDefaultFormatBordersLeftColorStyle:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatBordersLeftColorStyle schema
      type: object
      properties:
        rgbColor:
          $ref: '#/components/schemas/SpreadsheetsPostResponsePropertiesDefaultFormatBordersLeftColorStyleRgbColor'
        themeColor:
          type: string
    SpreadsheetsGetResponsePropertiesDefaultFormatBackgroundColorStyleRgbColor:
      description: SpreadsheetsGetResponsePropertiesDefaultFormatBackgroundColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponsePropertiesDefaultFormatBorders:
      description: SpreadsheetsPostResponsePropertiesDefaultFormatBorders schema
      type: object
      properties:
        bottom:
          $ref: '#/components/schemas/SpreadsheetsPostResponsePropertiesDefaultFormatBordersBottom'
        left:
          $ref: '#/components/schemas/SpreadsheetsPostResponsePropertiesDefaultFormatBordersLeft'
        right:
          $ref: '#/components/schemas/SpreadsheetsPostResponsePropertiesDefaultFormatBordersRight'
        top:
          $ref: '#/components/schemas/SpreadsheetsPostResponsePropertiesDefaultFormatBordersTop'
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersRightColorStyle:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersRightColorStyle schema
      type: object
      properties:
        rgbColor:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersRightColorStyleRgbColor'
        themeColor:
          type: string
    SpreadsheetsSheetsPostResponseGridProperties:
      des

# --- truncated at 32 KB (1348 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/google/refs/heads/main/openapi/google-sheet-api-openapi.yml