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/google-data-api"

All apis

curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

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. See our Privacy Policy and Terms.

GitHub Google LinkedIn

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

OpenAPI Specification

openapi: 3.2.0
info:
  title: Google Sheets Data API
  description: The Google Sheets API is a RESTful interface that lets you read and modify a spreadsheet's data..
  version: 1.0.0
servers:
- url: https://sheets.googleapis.com
  description: Google Sheets API Server
security:
- oauth2Auth: []
tags:
- name: Data
  description: Operations related to Data
paths:
  /v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter:
    post:
      tags:
      - Data
      summary: Google Get Values By Data Filter
      description: Returns one or more ranges of values that match the specified data filters. The caller must specify the spreadsheet ID and one or more DataFilters. Ranges that match any of the data filters in the request will be returned.
      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}}'
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/SpreadsheetsValuesbatchGetByDataFilterPostRequest'
      responses:
        '200':
          description: OK
          headers:
            Content-Type:
              schema:
                type: string
                example: application/json
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SpreadsheetsValuesbatchGetByDataFilterPostResponse'
              examples:
                SpreadsheetsValuesbatchGetByDataFilterPostResponseExample:
                  $ref: '#/components/examples/SpreadsheetsValuesbatchGetByDataFilterPostResponseExample'
      x-api-evangelist-processing:
        ChooseTags: true
      x-microcks-operation:
        delay: 100
        dispatcher: FALLBACK
        dispatcherRules: SpreadsheetsValuesbatchGetByDataFilterPostResponseExample
  /v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter:
    post:
      tags:
      - Data
      summary: Google Update by Data Filter
      description: Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a valueInputOption, and one or more DataFilterValueRanges.
      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}}'
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/SpreadsheetsValuesbatchUpdateByDataFilterPostRequest'
      responses:
        '200':
          description: OK
          headers:
            Content-Type:
              schema:
                type: string
                example: application/json
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SpreadsheetsValuesbatchUpdateByDataFilterPostResponse'
              examples:
                SpreadsheetsValuesbatchUpdateByDataFilterPostResponseExample:
                  $ref: '#/components/examples/SpreadsheetsValuesbatchUpdateByDataFilterPostResponseExample'
      x-api-evangelist-processing:
        ChooseTags: true
      x-microcks-operation:
        delay: 100
        dispatcher: FALLBACK
        dispatcherRules: SpreadsheetsValuesbatchUpdateByDataFilterPostResponseExample
  /v4/spreadsheets/{spreadsheetId}:getByDataFilter:
    post:
      tags:
      - Data
      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:
    SpreadsheetsValuesbatchGetByDataFilterPostResponse:
      description: SpreadsheetsValuesbatchGetByDataFilterPostResponse schema
      type: object
    SpreadsheetsValuesbatchGetByDataFilterPostRequest:
      description: SpreadsheetsValuesbatchGetByDataFilterPostRequest schema
      type: object
      example:
        dataFilters:
        - a1Range: eiusmod anim enim culpa
          developerMetadataLookup:
            locationMatchingStrategy: INTERSECTING_LOCATION
            locationType: SPREADSHEET
            metadataId: -64798951
            metadataKey: sint minim commodo
            metadataLocation:
              dimensionRange:
                dimension: ROWS
                endIndex: 34518543
                sheetId: 68337575
                startIndex: 91706381
              locationType: ROW
              sheetId: -33783740
              spreadsheet: true
            metadataValue: sunt
            visibility: DEVELOPER_METADATA_VISIBILITY_UNSPECIFIED
          gridRange:
            endColumnIndex: -96821047
            endRowIndex: -9277805
            sheetId: 7522437
            startColumnIndex: 85603635
            startRowIndex: -31384652
        - a1Range: sunt irure dolor
          developerMetadataLookup:
            locationMatchingStrategy: DEVELOPER_METADATA_LOCATION_MATCHING_STRATEGY_UNSPECIFIED
            locationType: SHEET
            metadataId: 26360577
            metadataKey: in minim nulla aliquip laboris
            metadataLocation:
              dimensionRange:
                dimension: COLUMNS
                endIndex: -14426665
                sheetId: 88787400
                startIndex: -98846780
              locationType: COLUMN
              sheetId: -14062757
              spreadsheet: true
            metadataValue: proident au
            visibility: DOCUMENT
          gridRange:
            endColumnIndex: -11696202
            endRowIndex: -87528654
            sheetId: 32991035
            startColumnIndex: -95148112
            startRowIndex: -72465558
        dateTimeRenderOption: FORMATTED_STRING
        majorDimension: DIMENSION_UNSPECIFIED
        valueRenderOption: FORMULA
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersBottomColorStyle:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersBottomColorStyle schema
      type: object
      properties:
        rgbColor:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersBottomColorStyleRgbColor'
        themeColor:
          type: string
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersTopColorStyle:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersTopColorStyle schema
      type: object
      properties:
        rgbColor:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersTopColorStyleRgbColor'
        themeColor:
          type: string
    SpreadsheetsPostResponse2PropertiesDefaultFormatTextRotation:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatTextRotation schema
      type: object
      properties:
        angle:
          type: integer
        vertical:
          type: boolean
    SpreadsheetsPostResponse2PropertiesDefaultFormat:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormat schema
      type: object
      properties:
        backgroundColor:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBackgroundColor'
        backgroundColorStyle:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBackgroundColorStyle'
        borders:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBorders'
        horizontalAlignment:
          type: string
        hyperlinkDisplayType:
          type: string
        numberFormat:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatNumberFormat'
        padding:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatPadding'
        textDirection:
          type: string
        textFormat:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormat'
        textRotation:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatTextRotation'
        verticalAlignment:
          type: string
        wrapStrategy:
          type: string
    SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormatForegroundColor:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormatForegroundColor 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
    SpreadsheetsPostResponse2PropertiesDefaultFormatPadding:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatPadding schema
      type: object
      properties:
        bottom:
          type: integer
        left:
          type: integer
        right:
          type: integer
        top:
          type: integer
    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'
    SpreadsheetsPostResponse2PropertiesDefaultFormatBackgroundColorStyleRgbColor:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBackgroundColorStyleRgbColor 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
    SpreadsheetsPostResponse2PropertiesSpreadsheetTheme:
      description: SpreadsheetsPostResponse2PropertiesSpreadsheetTheme schema
      type: object
      properties:
        primaryFontFamily:
          type: string
        themeColors:
          type: array
          items:
            type: object
            properties:
              color:
                type: object
                properties:
                  rgbColor:
                    type: object
                    properties:
                      alpha:
                        type: number
                      blue:
                        type: number
                      green:
                        type: number
                      red:
                        type: number
                  themeColor:
                    type: string
              colorType:
                type: string
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersTopColorStyleRgbColor:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersTopColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersRightColorStyle:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersRightColorStyle schema
      type: object
      properties:
        rgbColor:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersRightColorStyleRgbColor'
        themeColor:
          type: string
    SpreadsheetsValuesbatchUpdateByDataFilterPostRequest:
      description: SpreadsheetsValuesbatchUpdateByDataFilterPostRequest schema
      type: object
      example: null
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColor:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeft:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeft schema
      type: object
      properties:
        color:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColor'
        colorStyle:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColorStyle'
        style:
          type: string
        width:
          type: integer
    SpreadsheetsPostResponse2PropertiesDefaultFormatNumberFormat:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatNumberFormat schema
      type: object
      properties:
        pattern:
          type: string
        type:
          type: string
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersRightColor:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersRightColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsValuesbatchUpdateByDataFilterPostResponse:
      description: SpreadsheetsValuesbatchUpdateByDataFilterPostResponse schema
      type: object
    SpreadsheetsPostResponse2Properties:
      description: SpreadsheetsPostResponse2Properties schema
      type: object
      properties:
        autoRecalc:
          type: string
        defaultFormat:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormat'
        iterativeCalculationSettings:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesIterativeCalculationSettings'
        locale:
          type: string
        spreadsheetTheme:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesSpreadsheetTheme'
        timeZone:
          type: string
        title:
          type: string
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColorStyleRgbColor:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersBottom:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersBottom schema
      type: object
      properties:
        color:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersBottomColor'
        colorStyle:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersBottomColorStyle'
        style:
          type: string
        width:
          type: integer
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersRightColorStyleRgbColor:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersRightColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    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
    SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormatForegroundColorStyleRgbColor:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormatForegroundColorStyleRgbColor schema
      type: object
      properties:
        alpha:
          type: number
        blue:
          type: number
        green:
          type: number
        red:
          type: number
    SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColorStyle:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColorStyle schema
      type: object
      properties:
        rgbColor:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatBordersLeftColorStyleRgbColor'
        themeColor:
          type: string
    SpreadsheetsPostResponse2PropertiesIterativeCalculationSettings:
      description: SpreadsheetsPostResponse2PropertiesIterativeCalculationSettings schema
      type: object
      properties:
        convergenceThreshold:
          type: number
        maxIterations:
          type: integer
    SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormatForegroundColorStyle:
      description: SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormatForegroundColorStyle schema
      type: object
      properties:
        rgbColor:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2PropertiesDefaultFormatTextFormatForegroundColorStyleRgbColor'
        themeColor:
          type: string
    SpreadsheetsPostResponse2:
      description: SpreadsheetsPostResponse2 schema
      type: object
      properties:
        dataSourceSchedules:
          type: array
          items:
            type: object
            properties:
              dailySchedule:
                type: object
                properties:
                  startTime:
                    type: object
                    properties:
                      hours:
                        type: integer
                      minutes:
                        type: integer
                      nanos:
                        type: integer
                      seconds:
                        type: integer
              enabled:
                type: boolean
              monthlySchedule:
                type: object
                properties:
                  daysOfMonth:
                    type: array
                    items:
                      type: integer
                  startTime:
                    type: object
                    properties:
                      hours:
                        type: integer
                      minutes:
                        type: integer
                      nanos:
                        type: integer
                      seconds:
                        type: integer
              nextRun:
                type: object
                properties:
                  endTime:
                    type: string
                  startTime:
                    type: string
              refreshScope:
                type: string
              weeklySchedule:
                type: object
                properties:
                  daysOfWeek:
                    type: array
                    items:
                      type: string
                  startTime:
                    type: object
                    properties:
                      hours:
                        type: integer
                      minutes:
                        type: integer
                      nanos:
                        type: integer
                      seconds:
                        type: integer
        dataSources:
          type: array
          items:
            type: object
            properties:
              calculatedColumns:
                type: array
                items:
                  type: object
                  properties:
                    formula:
                      type: string
                    reference:
                      type: object
                      properties:
                        name:
                          type: string
              dataSourceId:
                type: string
              sheetId:
                type: integer
              spec:
                type: object
                properties:
                  bigQuery:
                    type: object
                    properties:
                      projectId:
                        type: string
                      querySpec:
                        type: object
                        properties:
                          rawQuery:
                            type: string
                      tableSpec:
                        type: object
                        properties:
                          datasetId:
                            type: string
                          tableId:
                            type: string
                          tableProjectId:
                            type: string
                  parameters:
                    type: array
                    items:
                      type: object
                      properties:
                        name:
                          type: string
                        namedRangeId:
                          type: string
                        range:
                          type: object
                          properties:
                            endColumnIndex:
                              type: integer
                            endRowIndex:
                              type: integer
                            sheetId:
                              type: integer
                            startColumnIndex:
                              type: integer
                            startRowIndex:
                              type: integer
        developerMetadata:
          type: array
          items:
            type: object
            properties:
              location:
                type: object
                properties:
                  dimensionRange:
                    type: object
                    properties:
                      dimension:
                        type: string
                      endIndex:
                        type: integer
                      sheetId:
                        type: integer
                      startIndex:
                        type: integer
                  locationType:
                    type: string
                  sheetId:
                    type: integer
                  spreadsheet:
                    type: boolean
              metadataId:
                type: integer
              metadataKey:
                type: string
              metadataValue:
                type: string
              visibility:
                type: string
        namedRanges:
          type: array
          items:
            type: object
            properties:
              name:
                type: string
              namedRangeId:
                type: string
              range:
                type: object
                properties:
                  endColumnIndex:
                    type: integer
                  endRowIndex:
                    type: integer
                  sheetId:
                    type: integer
                  startColumnIndex:
                    type: integer
                  startRowIndex:
                    type: integer
        properties:
          $ref: '#/components/schemas/SpreadsheetsPostResponse2Properties'
        sheets:
          type: array
          items:
            type: object
            properties:
              bandedRanges:
                type: array
                items:
                  type: object
                  properties:
                    bandedRangeId:
                      type: integer
                    columnProperties:
                      type: object
                      properties:
                        firstBandColor:
                          type: object
                          properties:
                            alpha:
                              type: number
                            blue:
                              type: number
                            green:
                              type: number
                            red:
                              type: number
                        firstBandColorStyle:
                          type: object
                          properties:
                            rgbColor:
                              type: object
                              properties:
                                alpha:
                                  type: number
                                blue:
                                  type: number
                                green:
                                  type: number
                                red:
                                  type: number
                            themeColor:
                              type: string
                        footerColor:
                          type: object
                          properties:
                            alpha:
                              type: number
                            blue:
                              type: number
                            green:
                              type: number
                            red:
                              type: number
                        footerColorStyle:
                          type: object
                          properties:
                            rgbColor:
                              type: object
                              properties:
                                alpha:
                                  type: number
                                blue:
                                  type: number
                                green:
                                  type: number
                                red:
                                  type: number
                            themeColor:
                              type: string
                        headerColor:
                          type: object
                          properties:
                            alpha:
                              type: number
                            blue:
                              type: number
                            green:
                              type: number
                            red:
                              type: number
                        headerColorStyle:
                          type: object
                          properties:
                            rgbColor:
                              type: object
                              properties:
                                alpha:
                                  type: number
                                blue:
                                  type: number
                                green:
                                  type: number
                                red:
                                  type: number
                            themeColor:
                              type: string
                        secondBandColor:
                          type: object
                          properties:
                            alpha:
                              type: number
                            blue:
                              type: number
                            green:
                              type: number
                            red:
                              type: number
          

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