## ── Attaching packages ───────────────────────────────────────── tidyverse 1.2.1 ──
## ✔ ggplot2 2.2.1.9000     ✔ purrr   0.2.4.9000
## ✔ tibble  1.4.2.9001     ✔ dplyr   0.7.4.9000
## ✔ tidyr   0.8.0          ✔ stringr 1.3.1     
## ✔ readr   1.2.0          ✔ forcats 0.3.0
## ── Conflicts ──────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter()  masks stats::filter()
## ✖ purrr::flatten() masks jsonlite::flatten()
## ✖ dplyr::lag()     masks stats::lag()

Exploring the Google Sheets API v4 Discovery Document

This is a machine-generated spec that describes what the API understands. Only the human-edited help strings are patched in.

https://sheets.googleapis.com/$discovery/rest?version=v4!

https://sheets.googleapis.com/$discovery/rest?version=v4

above should be https://sheets.googleapis.com/$discovery/rest?version=v4 but rendering often URLencodes the $ and breaks the link

Perhaps I will use this to automatically generate documentation for a low-level interface provided by the new googlesheets. It will be used internally and exposed for users who want direct access.

Inspired by the way the node-github automatically generates docs for the GitHub API, based on this JSON file documenting the underlying API.

spreadsheets.get

  • id: spreadsheets.get
  • httpMethod: GET
  • path: v4/spreadsheets/{spreadsheetId}
  • parameters:
    • spreadsheetId:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The spreadsheet to request.
    • ranges:
      • location: query
      • required: NA
      • type: string
      • repeated: TRUE
      • enum: NA
      • description: The ranges to retrieve from the spreadsheet.
    • includeGridData:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: True if grid data should be returned. This …
    • upload_protocol:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Upload protocol for media (e.g. “raw”, “mul…
    • prettyPrint:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Returns response with indentations and line…
    • uploadType:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Legacy upload protocol for media (e.g. “med…
    • fields:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Selector specifying which fields to include…
    • $.xgafv:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: 1 2
      • description: V1 error format.
    • callback:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: JSONP
    • alt:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: json media proto
      • description: Data format for response.
    • key:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: API key. Your API key identifies your proje…
    • access_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth access token.
    • quotaUser:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Available to use for quota purposes for ser…
    • pp:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Pretty-print response.
    • oauth_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth 2.0 token for the current user.
    • bearer_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth bearer token.
  • scopes: drive, drive.file, drive.readonly, spreadsheets, spre…
  • description: Returns the spreadsheet at the given ID. The caller m…
  • response: Spreadsheet
  • parameterOrder: spreadsheetId
  • request: NA

spreadsheets.getByDataFilter

  • id: spreadsheets.getByDataFilter
  • httpMethod: POST
  • path: v4/spreadsheets/{spreadsheetId}:getByDataFilter
  • parameters:
    • spreadsheetId:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The spreadsheet to request.
    • upload_protocol:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Upload protocol for media (e.g. “raw”, “mul…
    • prettyPrint:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Returns response with indentations and line…
    • uploadType:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Legacy upload protocol for media (e.g. “med…
    • fields:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Selector specifying which fields to include…
    • $.xgafv:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: 1 2
      • description: V1 error format.
    • callback:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: JSONP
    • alt:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: json media proto
      • description: Data format for response.
    • key:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: API key. Your API key identifies your proje…
    • access_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth access token.
    • quotaUser:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Available to use for quota purposes for ser…
    • pp:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Pretty-print response.
    • oauth_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth 2.0 token for the current user.
    • bearer_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth bearer token.
  • scopes: drive, drive.file, spreadsheets
  • description: Returns the spreadsheet at the given ID. The caller m…
  • response: Spreadsheet
  • parameterOrder: spreadsheetId
  • request: GetSpreadsheetByDataFilterRequest

spreadsheets.create

  • id: spreadsheets.create
  • httpMethod: POST
  • path: v4/spreadsheets
  • parameters:
    • upload_protocol:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Upload protocol for media (e.g. “raw”, “mul…
    • prettyPrint:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Returns response with indentations and line…
    • uploadType:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Legacy upload protocol for media (e.g. “med…
    • fields:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Selector specifying which fields to include…
    • $.xgafv:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: 1 2
      • description: V1 error format.
    • callback:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: JSONP
    • alt:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: json media proto
      • description: Data format for response.
    • key:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: API key. Your API key identifies your proje…
    • access_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth access token.
    • quotaUser:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Available to use for quota purposes for ser…
    • pp:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Pretty-print response.
    • oauth_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth 2.0 token for the current user.
    • bearer_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth bearer token.
  • scopes: drive, drive.file, spreadsheets
  • description: Creates a spreadsheet, returning the newly created sp…
  • response: Spreadsheet
  • parameterOrder: NA
  • request: Spreadsheet

spreadsheets.batchUpdate

  • id: spreadsheets.batchUpdate
  • httpMethod: POST
  • path: v4/spreadsheets/{spreadsheetId}:batchUpdate
  • parameters:
    • spreadsheetId:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The spreadsheet to apply the updates to.
    • upload_protocol:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Upload protocol for media (e.g. “raw”, “mul…
    • prettyPrint:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Returns response with indentations and line…
    • uploadType:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Legacy upload protocol for media (e.g. “med…
    • fields:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Selector specifying which fields to include…
    • $.xgafv:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: 1 2
      • description: V1 error format.
    • callback:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: JSONP
    • alt:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: json media proto
      • description: Data format for response.
    • key:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: API key. Your API key identifies your proje…
    • access_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth access token.
    • quotaUser:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Available to use for quota purposes for ser…
    • pp:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Pretty-print response.
    • oauth_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth 2.0 token for the current user.
    • bearer_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth bearer token.
  • scopes: drive, drive.file, spreadsheets
  • description: Applies one or more updates to the spreadsheet.

Each… * response: BatchUpdateSpreadsheetResponse * parameterOrder: spreadsheetId * request: BatchUpdateSpreadsheetRequest

spreadsheets.values.batchGet

  • id: spreadsheets.values.batchGet
  • httpMethod: GET
  • path: v4/spreadsheets/{spreadsheetId}/values:batchGet
  • parameters:
    • valueRenderOption:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: FORMATTED_VALUE UNFORMATTED_VALUE FORMULA
      • description: How values should be represented in the out…
    • dateTimeRenderOption:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: SERIAL_NUMBER FORMATTED_STRING
      • description: How dates, times, and durations should be r…
    • ranges:
      • location: query
      • required: NA
      • type: string
      • repeated: TRUE
      • enum: NA
      • description: The A1 notation of the values to retrieve.
    • majorDimension:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: DIMENSION_UNSPECIFIED ROWS COLUMNS
      • description: The major dimension that results should use…
    • spreadsheetId:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The ID of the spreadsheet to retrieve data …
    • upload_protocol:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Upload protocol for media (e.g. “raw”, “mul…
    • prettyPrint:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Returns response with indentations and line…
    • uploadType:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Legacy upload protocol for media (e.g. “med…
    • fields:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Selector specifying which fields to include…
    • $.xgafv:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: 1 2
      • description: V1 error format.
    • callback:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: JSONP
    • alt:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: json media proto
      • description: Data format for response.
    • key:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: API key. Your API key identifies your proje…
    • access_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth access token.
    • quotaUser:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Available to use for quota purposes for ser…
    • pp:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Pretty-print response.
    • oauth_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth 2.0 token for the current user.
    • bearer_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth bearer token.
  • scopes: drive, drive.file, drive.readonly, spreadsheets, spre…
  • description: Returns one or more ranges of values from a spreadshe…
  • response: BatchGetValuesResponse
  • parameterOrder: spreadsheetId
  • request: NA

spreadsheets.values.clear

  • id: spreadsheets.values.clear
  • httpMethod: POST
  • path: v4/spreadsheets/{spreadsheetId}/values/{range}:clear
  • parameters:
    • spreadsheetId:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The ID of the spreadsheet to update.
    • range:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The A1 notation of the values to clear.
    • upload_protocol:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Upload protocol for media (e.g. “raw”, “mul…
    • prettyPrint:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Returns response with indentations and line…
    • uploadType:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Legacy upload protocol for media (e.g. “med…
    • fields:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Selector specifying which fields to include…
    • $.xgafv:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: 1 2
      • description: V1 error format.
    • callback:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: JSONP
    • alt:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: json media proto
      • description: Data format for response.
    • key:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: API key. Your API key identifies your proje…
    • access_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth access token.
    • quotaUser:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Available to use for quota purposes for ser…
    • pp:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Pretty-print response.
    • oauth_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth 2.0 token for the current user.
    • bearer_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth bearer token.
  • scopes: drive, drive.file, spreadsheets
  • description: Clears values from a spreadsheet. The caller must spe…
  • response: ClearValuesResponse
  • parameterOrder: spreadsheetId, range
  • request: ClearValuesRequest

spreadsheets.values.batchClearByDataFilter

  • id: spreadsheets.values.batchClearByDataFilter
  • httpMethod: POST
  • path: v4/spreadsheets/{spreadsheetId}/values:batchClearByDa…
  • parameters:
    • spreadsheetId:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The ID of the spreadsheet to update.
    • upload_protocol:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Upload protocol for media (e.g. “raw”, “mul…
    • prettyPrint:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Returns response with indentations and line…
    • uploadType:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Legacy upload protocol for media (e.g. “med…
    • fields:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Selector specifying which fields to include…
    • $.xgafv:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: 1 2
      • description: V1 error format.
    • callback:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: JSONP
    • alt:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: json media proto
      • description: Data format for response.
    • key:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: API key. Your API key identifies your proje…
    • access_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth access token.
    • quotaUser:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Available to use for quota purposes for ser…
    • pp:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Pretty-print response.
    • oauth_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth 2.0 token for the current user.
    • bearer_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth bearer token.
  • scopes: drive, drive.file, spreadsheets
  • description: Clears one or more ranges of values from a spreadshee…
  • response: BatchClearValuesByDataFilterResponse
  • parameterOrder: spreadsheetId
  • request: BatchClearValuesByDataFilterRequest

spreadsheets.values.append

  • id: spreadsheets.values.append
  • httpMethod: POST
  • path: v4/spreadsheets/{spreadsheetId}/values/{range}:append
  • parameters:
    • spreadsheetId:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The ID of the spreadsheet to update.
    • responseValueRenderOption:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: FORMATTED_VALUE UNFORMATTED_VALUE FORMULA
      • description: Determines how values in the response shoul…
    • insertDataOption:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: OVERWRITE INSERT_ROWS
      • description: How the input data should be inserted.
    • valueInputOption:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: INPUT_VALUE_OPTION_UNSPECIFIED RAW USER_ENTERED
      • description: How the input data should be interpreted.
    • responseDateTimeRenderOption:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: SERIAL_NUMBER FORMATTED_STRING
      • description: Determines how dates, times, and durations …
    • range:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The A1 notation of a range to search for a …
    • includeValuesInResponse:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Determines if the update response should in…
    • upload_protocol:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Upload protocol for media (e.g. “raw”, “mul…
    • prettyPrint:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Returns response with indentations and line…
    • uploadType:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Legacy upload protocol for media (e.g. “med…
    • fields:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Selector specifying which fields to include…
    • $.xgafv:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: 1 2
      • description: V1 error format.
    • callback:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: JSONP
    • alt:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: json media proto
      • description: Data format for response.
    • key:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: API key. Your API key identifies your proje…
    • access_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth access token.
    • quotaUser:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Available to use for quota purposes for ser…
    • pp:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Pretty-print response.
    • oauth_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth 2.0 token for the current user.
    • bearer_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth bearer token.
  • scopes: drive, drive.file, spreadsheets
  • description: Appends values to a spreadsheet. The input range is u…
  • response: AppendValuesResponse
  • parameterOrder: spreadsheetId, range
  • request: ValueRange

spreadsheets.values.batchGetByDataFilter

  • id: spreadsheets.values.batchGetByDataFilter
  • httpMethod: POST
  • path: v4/spreadsheets/{spreadsheetId}/values:batchGetByData…
  • parameters:
    • spreadsheetId:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The ID of the spreadsheet to retrieve data …
    • upload_protocol:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Upload protocol for media (e.g. “raw”, “mul…
    • prettyPrint:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Returns response with indentations and line…
    • uploadType:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Legacy upload protocol for media (e.g. “med…
    • fields:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Selector specifying which fields to include…
    • $.xgafv:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: 1 2
      • description: V1 error format.
    • callback:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: JSONP
    • alt:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: json media proto
      • description: Data format for response.
    • key:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: API key. Your API key identifies your proje…
    • access_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth access token.
    • quotaUser:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Available to use for quota purposes for ser…
    • pp:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Pretty-print response.
    • oauth_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth 2.0 token for the current user.
    • bearer_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth bearer token.
  • scopes: drive, drive.file, spreadsheets
  • description: Returns one or more ranges of values that match the s…
  • response: BatchGetValuesByDataFilterResponse
  • parameterOrder: spreadsheetId
  • request: BatchGetValuesByDataFilterRequest

spreadsheets.values.batchClear

  • id: spreadsheets.values.batchClear
  • httpMethod: POST
  • path: v4/spreadsheets/{spreadsheetId}/values:batchClear
  • parameters:
    • spreadsheetId:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The ID of the spreadsheet to update.
    • upload_protocol:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Upload protocol for media (e.g. “raw”, “mul…
    • prettyPrint:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Returns response with indentations and line…
    • uploadType:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Legacy upload protocol for media (e.g. “med…
    • fields:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Selector specifying which fields to include…
    • $.xgafv:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: 1 2
      • description: V1 error format.
    • callback:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: JSONP
    • alt:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: json media proto
      • description: Data format for response.
    • key:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: API key. Your API key identifies your proje…
    • access_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth access token.
    • quotaUser:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Available to use for quota purposes for ser…
    • pp:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Pretty-print response.
    • oauth_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth 2.0 token for the current user.
    • bearer_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth bearer token.
  • scopes: drive, drive.file, spreadsheets
  • description: Clears one or more ranges of values from a spreadshee…
  • response: BatchClearValuesResponse
  • parameterOrder: spreadsheetId
  • request: BatchClearValuesRequest

spreadsheets.values.get

  • id: spreadsheets.values.get
  • httpMethod: GET
  • path: v4/spreadsheets/{spreadsheetId}/values/{range}
  • parameters:
    • majorDimension:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: DIMENSION_UNSPECIFIED ROWS COLUMNS
      • description: The major dimension that results should use…
    • spreadsheetId:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The ID of the spreadsheet to retrieve data …
    • range:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The A1 notation of the values to retrieve.
    • valueRenderOption:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: FORMATTED_VALUE UNFORMATTED_VALUE FORMULA
      • description: How values should be represented in the out…
    • dateTimeRenderOption:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: SERIAL_NUMBER FORMATTED_STRING
      • description: How dates, times, and durations should be r…
    • upload_protocol:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Upload protocol for media (e.g. “raw”, “mul…
    • prettyPrint:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Returns response with indentations and line…
    • uploadType:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Legacy upload protocol for media (e.g. “med…
    • fields:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Selector specifying which fields to include…
    • $.xgafv:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: 1 2
      • description: V1 error format.
    • callback:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: JSONP
    • alt:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: json media proto
      • description: Data format for response.
    • key:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: API key. Your API key identifies your proje…
    • access_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth access token.
    • quotaUser:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Available to use for quota purposes for ser…
    • pp:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Pretty-print response.
    • oauth_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth 2.0 token for the current user.
    • bearer_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth bearer token.
  • scopes: drive, drive.file, drive.readonly, spreadsheets, spre…
  • description: Returns a range of values from a spreadsheet. The cal…
  • response: ValueRange
  • parameterOrder: spreadsheetId, range
  • request: NA

spreadsheets.values.batchUpdateByDataFilter

  • id: spreadsheets.values.batchUpdateByDataFilter
  • httpMethod: POST
  • path: v4/spreadsheets/{spreadsheetId}/values:batchUpdateByD…
  • parameters:
    • spreadsheetId:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The ID of the spreadsheet to update.
    • upload_protocol:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Upload protocol for media (e.g. “raw”, “mul…
    • prettyPrint:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Returns response with indentations and line…
    • uploadType:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Legacy upload protocol for media (e.g. “med…
    • fields:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Selector specifying which fields to include…
    • $.xgafv:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: 1 2
      • description: V1 error format.
    • callback:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: JSONP
    • alt:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: json media proto
      • description: Data format for response.
    • key:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: API key. Your API key identifies your proje…
    • access_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth access token.
    • quotaUser:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Available to use for quota purposes for ser…
    • pp:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Pretty-print response.
    • oauth_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth 2.0 token for the current user.
    • bearer_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth bearer token.
  • scopes: drive, drive.file, spreadsheets
  • description: Sets values in one or more ranges of a spreadsheet. T…
  • response: BatchUpdateValuesByDataFilterResponse
  • parameterOrder: spreadsheetId
  • request: BatchUpdateValuesByDataFilterRequest

spreadsheets.values.update

  • id: spreadsheets.values.update
  • httpMethod: PUT
  • path: v4/spreadsheets/{spreadsheetId}/values/{range}
  • parameters:
    • includeValuesInResponse:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Determines if the update response should in…
    • range:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The A1 notation of the values to update.
    • spreadsheetId:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The ID of the spreadsheet to update.
    • responseValueRenderOption:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: FORMATTED_VALUE UNFORMATTED_VALUE FORMULA
      • description: Determines how values in the response shoul…
    • valueInputOption:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: INPUT_VALUE_OPTION_UNSPECIFIED RAW USER_ENTERED
      • description: How the input data should be interpreted.
    • responseDateTimeRenderOption:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: SERIAL_NUMBER FORMATTED_STRING
      • description: Determines how dates, times, and durations …
    • upload_protocol:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Upload protocol for media (e.g. “raw”, “mul…
    • prettyPrint:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Returns response with indentations and line…
    • uploadType:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Legacy upload protocol for media (e.g. “med…
    • fields:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Selector specifying which fields to include…
    • $.xgafv:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: 1 2
      • description: V1 error format.
    • callback:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: JSONP
    • alt:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: json media proto
      • description: Data format for response.
    • key:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: API key. Your API key identifies your proje…
    • access_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth access token.
    • quotaUser:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Available to use for quota purposes for ser…
    • pp:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Pretty-print response.
    • oauth_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth 2.0 token for the current user.
    • bearer_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth bearer token.
  • scopes: drive, drive.file, spreadsheets
  • description: Sets values in a range of a spreadsheet. The caller m…
  • response: UpdateValuesResponse
  • parameterOrder: spreadsheetId, range
  • request: ValueRange

spreadsheets.values.batchUpdate

  • id: spreadsheets.values.batchUpdate
  • httpMethod: POST
  • path: v4/spreadsheets/{spreadsheetId}/values:batchUpdate
  • parameters:
    • spreadsheetId:
      • location: path
      • required: TRUE
      • type: string
      • repeated: NA
      • enum: NA
      • description: The ID of the spreadsheet to update.
    • upload_protocol:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Upload protocol for media (e.g. “raw”, “mul…
    • prettyPrint:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Returns response with indentations and line…
    • uploadType:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Legacy upload protocol for media (e.g. “med…
    • fields:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Selector specifying which fields to include…
    • $.xgafv:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: 1 2
      • description: V1 error format.
    • callback:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: JSONP
    • alt:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: json media proto
      • description: Data format for response.
    • key:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: API key. Your API key identifies your proje…
    • access_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth access token.
    • quotaUser:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: Available to use for quota purposes for ser…
    • pp:
      • location: query
      • required: NA
      • type: boolean
      • repeated: NA
      • enum: NA
      • description: Pretty-print response.
    • oauth_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth 2.0 token for the current user.
    • bearer_token:
      • location: query
      • required: NA
      • type: string
      • repeated: NA
      • enum: NA
      • description: OAuth bearer token.
  • scopes: drive, drive.file, spreadsheets
  • description: Sets values in one or more ranges of a spreadsheet. T…
  • response: BatchUpdateValuesResponse
  • parameterOrder: spreadsheetId
  • request: BatchUpdateValuesRequest