Google Sheets API v4

openapi: 3.1.0
info:
  title: Google Sheets API
  description: >-
    The Google Sheets API lets you read, write, and format data in Google
    Sheets. It supports creating spreadsheets, reading and writing cell
    values, updating formatting, managing sheets within a spreadsheet, and
    working with developer metadata.
  version: v4
  termsOfService: https://developers.google.com/terms
  contact:
    name: Google Workspace Developer Support
    url: https://developers.google.com/sheets/api/support
  license:
    name: Creative Commons Attribution 4.0
    url: https://creativecommons.org/licenses/by/4.0/
externalDocs:
  description: Google Sheets API documentation
  url: https://developers.google.com/sheets/api
servers:
- url: https://sheets.googleapis.com/v4
  description: Google Sheets API v4 production server
security:
- oauth2: []
- apiKey: []
tags:
- name: developerMetadata
  description: Operations on developer metadata
- name: Sheets
  description: Operations on individual sheets within a spreadsheet
- name: Spreadsheets
  description: Operations on spreadsheet resources
- name: Values
  description: Operations on spreadsheet cell values
paths:
  /spreadsheets:
    post:
      operationId: createSpreadsheet
      summary: Google Sheets Create a Spreadsheet
      description: Creates a new spreadsheet, optionally with initial properties, sheets, and data.
      tags:
      - Spreadsheets
      requestBody:
        description: The spreadsheet to create.
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/Spreadsheet'
            examples:
              CreatespreadsheetRequestExample:
                summary: Default createSpreadsheet request
                x-microcks-default: true
                value:
                  spreadsheetId: '500123'
                  properties:
                    title: Example Title
                    locale: example_value
                    autoRecalc: ON_CHANGE
                    timeZone: example_value
                    importFunctionsExternalUrlAccessAllowed: https://www.example.com
                  sheets:
                  - data: {}
                    merges: {}
                    conditionalFormats: {}
                    filterViews: {}
                    protectedRanges: {}
                    charts: {}
                    bandedRanges: {}
                    slicers: {}
                  namedRanges:
                  - namedRangeId: '500123'
                    name: Example Title
                  spreadsheetUrl: https://www.example.com
                  developerMetadata:
                  - metadataId: '500123'
                    metadataKey: example_value
                    metadataValue: example_value
                    visibility: DEVELOPER_METADATA_VISIBILITY_UNSPECIFIED
                  dataSources:
                  - dataSourceId: '500123'
                    calculatedColumns: {}
                    sheetId: '500123'
                  dataSourceSchedules:
                  - enabled: true
                    refreshScope: DATA_SOURCE_REFRESH_SCOPE_UNSPECIFIED
                    nextRun: {}
                    dailySchedule: {}
                    weeklySchedule: {}
                    monthlySchedule: {}
      responses:
        '200':
          description: Successful response containing the newly created spreadsheet.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Spreadsheet'
              examples:
                Createspreadsheet200Example:
                  summary: Default createSpreadsheet 200 response
                  x-microcks-default: true
                  value:
                    spreadsheetId: '500123'
                    properties:
                      title: Example Title
                      locale: example_value
                      autoRecalc: ON_CHANGE
                      timeZone: example_value
                      importFunctionsExternalUrlAccessAllowed: https://www.example.com
                    sheets:
                    - data: {}
                      merges: {}
                      conditionalFormats: {}
                      filterViews: {}
                      protectedRanges: {}
                      charts: {}
                      bandedRanges: {}
                      slicers: {}
                    namedRanges:
                    - namedRangeId: '500123'
                      name: Example Title
                    spreadsheetUrl: https://www.example.com
                    developerMetadata:
                    - metadataId: '500123'
                      metadataKey: example_value
                      metadataValue: example_value
                      visibility: DEVELOPER_METADATA_VISIBILITY_UNSPECIFIED
                    dataSources:
                    - dataSourceId: '500123'
                      calculatedColumns: {}
                      sheetId: '500123'
                    dataSourceSchedules:
                    - enabled: true
                      refreshScope: DATA_SOURCE_REFRESH_SCOPE_UNSPECIFIED
                      nextRun: {}
                      dailySchedule: {}
                      weeklySchedule: {}
                      monthlySchedule: {}
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
        '429':
          $ref: '#/components/responses/TooManyRequests'

      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /spreadsheets/{spreadsheetId}:
    get:
      operationId: getSpreadsheet
      summary: Google Sheets Get a Spreadsheet
      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 two ways using the fields URL
        parameter or the includeGridData query parameter.
      tags:
      - Spreadsheets
      parameters:
      - $ref: '#/components/parameters/spreadsheetId'
      - name: ranges
        in: query
        description: The ranges to retrieve from the spreadsheet.
        schema:
          type: array
          items:
            type: string
        example: []
      - name: includeGridData
        in: query
        description: >-
          True if grid data should be returned. This parameter is ignored
          if a field mask was set in the request.
        schema:
          type: boolean
          default: false
        example: true
      responses:
        '200':
          description: Successful response containing the spreadsheet.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Spreadsheet'
              examples:
                Getspreadsheet200Example:
                  summary: Default getSpreadsheet 200 response
                  x-microcks-default: true
                  value:
                    spreadsheetId: '500123'
                    properties:
                      title: Example Title
                      locale: example_value
                      autoRecalc: ON_CHANGE
                      timeZone: example_value
                      importFunctionsExternalUrlAccessAllowed: https://www.example.com
                    sheets:
                    - data: {}
                      merges: {}
                      conditionalFormats: {}
                      filterViews: {}
                      protectedRanges: {}
                      charts: {}
                      bandedRanges: {}
                      slicers: {}
                    namedRanges:
                    - namedRangeId: '500123'
                      name: Example Title
                    spreadsheetUrl: https://www.example.com
                    developerMetadata:
                    - metadataId: '500123'
                      metadataKey: example_value
                      metadataValue: example_value
                      visibility: DEVELOPER_METADATA_VISIBILITY_UNSPECIFIED
                    dataSources:
                    - dataSourceId: '500123'
                      calculatedColumns: {}
                      sheetId: '500123'
                    dataSourceSchedules:
                    - enabled: true
                      refreshScope: DATA_SOURCE_REFRESH_SCOPE_UNSPECIFIED
                      nextRun: {}
                      dailySchedule: {}
                      weeklySchedule: {}
                      monthlySchedule: {}
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
        '404':
          $ref: '#/components/responses/NotFound'
        '429':
          $ref: '#/components/responses/TooManyRequests'

      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /spreadsheets/{spreadsheetId}:batchUpdate:
    post:
      operationId: batchUpdateSpreadsheet
      summary: Google Sheets Batch Update a Spreadsheet
      description: >-
        Applies one or more updates to the spreadsheet. Each request is
        validated before being applied. If any request is not valid, the
        entire request will fail and nothing will be applied.
      tags:
      - Spreadsheets
      parameters:
      - $ref: '#/components/parameters/spreadsheetId'
      requestBody:
        description: The batch update request.
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/BatchUpdateSpreadsheetRequest'
            examples:
              BatchupdatespreadsheetRequestExample:
                summary: Default batchUpdateSpreadsheet request
                x-microcks-default: true
                value:
                  requests:
                  - {}
                  includeSpreadsheetInResponse: true
                  responseRanges:
                  - example_value
                  responseIncludeGridData: true
      responses:
        '200':
          description: Successful response containing the batch update results.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/BatchUpdateSpreadsheetResponse'
              examples:
                Batchupdatespreadsheet200Example:
                  summary: Default batchUpdateSpreadsheet 200 response
                  x-microcks-default: true
                  value:
                    spreadsheetId: '500123'
                    replies:
                    - {}
                    updatedSpreadsheet:
                      spreadsheetId: '500123'
                      sheets:
                      - {}
                      namedRanges:
                      - {}
                      spreadsheetUrl: https://www.example.com
                      developerMetadata:
                      - {}
                      dataSources:
                      - {}
                      dataSourceSchedules:
                      - {}
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
        '404':
          $ref: '#/components/responses/NotFound'
        '429':
          $ref: '#/components/responses/TooManyRequests'

      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /spreadsheets/{spreadsheetId}:getByDataFilter:
    post:
      operationId: getSpreadsheetByDataFilter
      summary: Google Sheets Get a Spreadsheet 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.
      tags:
      - Spreadsheets
      parameters:
      - $ref: '#/components/parameters/spreadsheetId'
      requestBody:
        description: The data filter request.
        required: true
        content:
          application/json:
            schema:
              type: object
              properties:
                dataFilters:
                  type: array
                  description: The DataFilters used to select which ranges to retrieve from the spreadsheet.
                  items:
                    $ref: '#/components/schemas/DataFilter'
                includeGridData:
                  type: boolean
                  description: True if grid data should be returned.
                  default: false
            examples:
              GetspreadsheetbydatafilterRequestExample:
                summary: Default getSpreadsheetByDataFilter request
                x-microcks-default: true
                value:
                  dataFilters:
                  - a1Range: example_value
                  includeGridData: true
      responses:
        '200':
          description: Successful response containing the spreadsheet.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Spreadsheet'
              examples:
                Getspreadsheetbydatafilter200Example:
                  summary: Default getSpreadsheetByDataFilter 200 response
                  x-microcks-default: true
                  value:
                    spreadsheetId: '500123'
                    properties:
                      title: Example Title
                      locale: example_value
                      autoRecalc: ON_CHANGE
                      timeZone: example_value
                      importFunctionsExternalUrlAccessAllowed: https://www.example.com
                    sheets:
                    - data: {}
                      merges: {}
                      conditionalFormats: {}
                      filterViews: {}
                      protectedRanges: {}
                      charts: {}
                      bandedRanges: {}
                      slicers: {}
                    namedRanges:
                    - namedRangeId: '500123'
                      name: Example Title
                    spreadsheetUrl: https://www.example.com
                    developerMetadata:
                    - metadataId: '500123'
                      metadataKey: example_value
                      metadataValue: example_value
                      visibility: DEVELOPER_METADATA_VISIBILITY_UNSPECIFIED
                    dataSources:
                    - dataSourceId: '500123'
                      calculatedColumns: {}
                      sheetId: '500123'
                    dataSourceSchedules:
                    - enabled: true
                      refreshScope: DATA_SOURCE_REFRESH_SCOPE_UNSPECIFIED
                      nextRun: {}
                      dailySchedule: {}
                      weeklySchedule: {}
                      monthlySchedule: {}
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
        '404':
          $ref: '#/components/responses/NotFound'
        '429':
          $ref: '#/components/responses/TooManyRequests'

      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /spreadsheets/{spreadsheetId}/values/{range}:
    get:
      operationId: getValues
      summary: Google Sheets Get Values From a Range
      description: >-
        Returns a range of values from a spreadsheet. The caller must specify
        the spreadsheet ID and a range.
      tags:
      - Values
      parameters:
      - $ref: '#/components/parameters/spreadsheetId'
      - $ref: '#/components/parameters/range'
      - name: majorDimension
        in: query
        description: The major dimension that results should use.
        schema:
          $ref: '#/components/schemas/Dimension'
        example: example_value
      - name: valueRenderOption
        in: query
        description: How values should be represented in the output.
        schema:
          $ref: '#/components/schemas/ValueRenderOption'
        example: example_value
      - name: dateTimeRenderOption
        in: query
        description: How dates, times, and durations should be represented in the output.
        schema:
          $ref: '#/components/schemas/DateTimeRenderOption'
        example: example_value
      responses:
        '200':
          description: Successful response containing the requested values.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ValueRange'
              examples:
                Getvalues200Example:
                  summary: Default getValues 200 response
                  x-microcks-default: true
                  value:
                    range: example_value
                    majorDimension: DIMENSION_UNSPECIFIED
                    values:
                    - []
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
        '404':
          $ref: '#/components/responses/NotFound'
        '429':
          $ref: '#/components/responses/TooManyRequests'

      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
    put:
      operationId: updateValues
      summary: Google Sheets Update Values in a Range
      description: >-
        Sets values in a range of a spreadsheet. The caller must specify the
        spreadsheet ID, range, and a valueInputOption.
      tags:
      - Values
      parameters:
      - $ref: '#/components/parameters/spreadsheetId'
      - $ref: '#/components/parameters/range'
      - name: valueInputOption
        in: query
        description: How the input data should be interpreted.
        required: true
        schema:
          $ref: '#/components/schemas/ValueInputOption'
        example: example_value
      - name: includeValuesInResponse
        in: query
        description: Determines if the update response should include the values of the cells that were updated.
        schema:
          type: boolean
          default: false
        example: true
      - name: responseValueRenderOption
        in: query
        description: Determines how values in the response should be rendered.
        schema:
          $ref: '#/components/schemas/ValueRenderOption'
        example: example_value
      - name: responseDateTimeRenderOption
        in: query
        description: Determines how dates, times, and durations in the response should be rendered.
        schema:
          $ref: '#/components/schemas/DateTimeRenderOption'
        example: example_value
      requestBody:
        description: The values to update.
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ValueRange'
            examples:
              UpdatevaluesRequestExample:
                summary: Default updateValues request
                x-microcks-default: true
                value:
                  range: example_value
                  majorDimension: DIMENSION_UNSPECIFIED
                  values:
                  - []
      responses:
        '200':
          description: Successful response containing the update result.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/UpdateValuesResponse'
              examples:
                Updatevalues200Example:
                  summary: Default updateValues 200 response
                  x-microcks-default: true
                  value:
                    spreadsheetId: '500123'
                    updatedRange: example_value
                    updatedRows: 10
                    updatedColumns: 10
                    updatedCells: 10
                    updatedData:
                      range: example_value
                      values:
                      - {}
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
        '404':
          $ref: '#/components/responses/NotFound'
        '429':
          $ref: '#/components/responses/TooManyRequests'

      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /spreadsheets/{spreadsheetId}/values/{range}:append:
    post:
      operationId: appendValues
      summary: Google Sheets Append Values to a Range
      description: >-
        Appends values to a spreadsheet. The input range is used to search
        for existing data and find a table within that range. Values will be
        appended to the next row of the table, starting with the first column
        of the table.
      tags:
      - Values
      parameters:
      - $ref: '#/components/parameters/spreadsheetId'
      - $ref: '#/components/parameters/range'
      - name: valueInputOption
        in: query
        description: How the input data should be interpreted.
        required: true
        schema:
          $ref: '#/components/schemas/ValueInputOption'
        example: example_value
      - name: insertDataOption
        in: query
        description: How the input data should be inserted.
        schema:
          type: string
          enum:
          - OVERWRITE
          - INSERT_ROWS
        example: OVERWRITE
      - name: includeValuesInResponse
        in: query
        description: Determines if the update response should include the values of the cells that were appended.
        schema:
          type: boolean
          default: false
        example: true
      - name: responseValueRenderOption
        in: query
        description: Determines how values in the response should be rendered.
        schema:
          $ref: '#/components/schemas/ValueRenderOption'
        example: example_value
      - name: responseDateTimeRenderOption
        in: query
        description: Determines how dates, times, and durations in the response should be rendered.
        schema:
          $ref: '#/components/schemas/DateTimeRenderOption'
        example: example_value
      requestBody:
        description: The values to append.
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ValueRange'
            examples:
              AppendvaluesRequestExample:
                summary: Default appendValues request
                x-microcks-default: true
                value:
                  range: example_value
                  majorDimension: DIMENSION_UNSPECIFIED
                  values:
                  - []
      responses:
        '200':
          description: Successful response containing the append result.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AppendValuesResponse'
              examples:
                Appendvalues200Example:
                  summary: Default appendValues 200 response
                  x-microcks-default: true
                  value:
                    spreadsheetId: '500123'
                    tableRange: example_value
                    updates:
                      spreadsheetId: '500123'
                      updatedRange: example_value
                      updatedRows: 10
                      updatedColumns: 10
                      updatedCells: 10
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
        '404':
          $ref: '#/components/responses/NotFound'
        '429':
          $ref: '#/components/responses/TooManyRequests'

      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /spreadsheets/{spreadsheetId}/values/{range}:clear:
    post:
      operationId: clearValues
      summary: Google Sheets Clear Values From a Range
      description: >-
        Clears values from a spreadsheet. The caller must specify the
        spreadsheet ID and range. Only values are cleared; all other
        properties of the cell (such as formatting and data validation) are
        kept.
      tags:
      - Values
      parameters:
      - $ref: '#/components/parameters/spreadsheetId'
      - $ref: '#/components/parameters/range'
      requestBody:
        description: The clear values request.
        required: true
        content:
          application/json:
            schema:
              type: object
            examples:
              ClearvaluesRequestExample:
                summary: Default clearValues request
                x-microcks-default: true
                value: {}
      responses:
        '200':
          description: Successful response containing the cleared range.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ClearValuesResponse'
              examples:
                Clearvalues200Example:
                  summary: Default clearValues 200 response
                  x-microcks-default: true
                  value:
                    spreadsheetId: '500123'
                    clearedRange: example_value
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
        '404':
          $ref: '#/components/responses/NotFound'
        '429':
          $ref: '#/components/responses/TooManyRequests'

      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /spreadsheets/{spreadsheetId}/values:batchGet:
    get:
      operationId: batchGetValues
      summary: Google Sheets Get Values From Multiple Ranges
      description: >-
        Returns one or more ranges of values from a spreadsheet. The caller
        must specify the spreadsheet ID and one or more ranges.
      tags:
      - Values
      parameters:
      - $ref: '#/components/parameters/spreadsheetId'
      - name: ranges
        in: query
        description: The A1 notation or R1C1 notation of the range to retrieve values from.
        required: true
        schema:
          type: array
          items:
            type: string
        example: []
      - name: majorDimension
        in: query
        description: The major dimension that results should use.
        schema:
          $ref: '#/components/schemas/Dimension'
        example: example_value
      - name: valueRenderOption
        in: query
        description: How values should be represented in the output.
        schema:
          $ref: '#/components/schemas/ValueRenderOption'
        example: example_value
      - name: dateTimeRenderOption
        in: query
        description: How dates, times, and durations should be represented in the output.
        schema:
          $ref: '#/components/schemas/DateTimeRenderOption'
        example: example_value
      responses:
        '200':
          description: Successful response containing the requested values.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/BatchGetValuesResponse'
              examples:
                Batchgetvalues200Example:
                  summary: Default batchGetValues 200 response
                  x-microcks-default: true
                  value:
                    spreadsheetId: '500123'
                    valueRanges:
                    - range: example_value
                      values: {}
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
        '404':
          $ref: '#/components/responses/NotFound'
        '429':
          $ref: '#/components/responses/TooManyRequests'

      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /spreadsheets/{spreadsheetId}/values:batchUpdate:
    post:
      operationId: batchUpdateValues
      summary: Google Sheets Update Values in Multiple Ranges
      description: >-
        Sets values in one or more ranges of a spreadsheet. The caller must
        specify the spreadsheet ID, a valueInputOption, and one or more
        ValueRanges.
      tags:
      - Values
      parameters:
      - $ref: '#/components/parameters/spreadsheetId'
      requestBody:
        description: The batch update values request.
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/BatchUpdateValuesRequest'
            examples:
              BatchupdatevaluesRequestExample:
                summary: Default batchUpdateValues request
                x-microcks-default: true
                value:
                  valueInputOption: INPUT_VALUE_OPTION_UNSPECIFIED
                  data:
                  - range: example_value
                    values: {}
                  includeValuesInResponse: true
                  responseValueRenderOption: FORMATTED_VALUE
                  responseDateTimeRenderOption: SERIAL_NUMBER
      responses:
        '200':
          description: Successful response containing the batch update results.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/BatchUpdateValuesResponse'
              examples:
                Batchupdatevalues200Example:
                  summary: Default batchUpdateValues 200 response
                  x-microcks-default: true
                  value:
                    spreadsheetId: '500123'
                    totalUpdatedRows: 10
                    totalUpdatedColumns: 10
                    totalUpdatedCells: 10
                    totalUpdatedSheets: 10
                    responses:
                    - spreadsheetId: '500123'
                      updatedRange: example_value
                      updatedRows: 10
                      updatedColumns: 10
                      updatedCells: 10
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
        '404':
          $ref: '#/components/responses/NotFound'
        '429':
          $ref: '#/components/responses/TooManyRequests'

      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /spreadsheets/{spreadsheetId}/values:batchClear:
    post:
      operationId: batchClearValues
      summary: Google Sheets Clear Values From Multiple Ranges
      description: >-
        Clears one or more ranges of values from a spreadsheet. The caller
        must specify the spreadsheet ID and one or more ranges. Only values
        are cleared; all other properties of the cell are kept.
      tags:
      - Values
      parameters:
      - $ref: '#/components/parameters/spreadsheetId'
      requestBody:
        description: The batch clear values request.
        required: true
        content:
          application/json:
            schema:
              type: object
              properties:
                ranges:
                  type: array
                  description: The ranges to clear in A1 or R1C1 notation.
                  items:
                    type: string
            examples:
              BatchclearvaluesRequestExample:
                summary: Default batchClearValues request
                x-microcks-default: true
                value:
                  ranges:
                  - example_value
      responses:
        '200':
          description: Successful response containing the cleared ranges.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/BatchClearValuesResponse'
              examples:
                Batchclearvalues200Example:
                  summary: Default batchClearValues 200 response
                  x-microcks-default: true
                  value:
                    spreadsheetId: '500123'
                    clearedRanges:
                    - example_value
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
        '404':
          $ref: '#/components/responses/NotFound'
        '429':
          $ref: '#/components/responses/TooManyRequests'

      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /spreadsheets/{spreadsheetId}/values:batchGetByDataFilter:
    post:
      operationId: batchGetValuesByDataFilter
      summary: Google Sheets Get Values From Ranges Matching Data Filters
      description: >-
        Returns one or more ranges of v

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