Google Sheets API

Service: Google Sheets API
Description: Google Sheets API provides a REST API for programmatic access to its features. Use it to integrate with Google services.
Auth: oauth2
Capabilities:
  - spreadsheets: Manage spreadsheets — creates a spreadsheet, returning the newly created spreadsheet, returns the spreadsheet at the given id. the caller must specify the spreadsheet id. for more information, see [read, write, and search metadata](https://developers.google.com/workspace/sheets/api/guides/metadata). 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 in one of two ways: * specify a [field mask](https://developers.google.com/workspace/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, applies one or more updates to the spreadsheet. each request is validated before being applied. if any request is not valid then the entire request will fail and nothing will be applied. some requests have replies to give you some information about how they are applied. the replies will mirror the requests. for example, if you applied 4 updates and the 3rd one had a reply, then the response will have 2 empty replies, the actual reply, and another empty reply, in that order. due to the collaborative nature of spreadsheets, it is not guaranteed that the spreadsheet will reflect exactly your changes after this completes, however it is guaranteed that the updates in the request will be applied together atomically. your changes may be altered with respect to collaborator changes. if there are no collaborators, the spreadsheet should reflect your changes. Supports standard CRUD operations through the REST API.
  - spreadsheets_developer_metadata: Manage spreadsheets developermetadata — returns all developer metadata matching the specified datafilter. for more information, see [read, write, and search metadata](https://developers.google.com/workspace/sheets/api/guides/metadata). if the provided datafilter represents a developermetadatalookup object, this will return all developermetadata entries selected by it. if the datafilter represents a location in a spreadsheet, this will return all developer metadata associated with locations intersecting that region, returns the developer metadata with the specified id. the caller must specify the spreadsheet id and the developer metadata's unique metadataid. for more information, see [read, write, and search metadata](https://developers.google.com/workspace/sheets/api/guides/metadata). Supports standard CRUD operations through the REST API.
  - spreadsheets_sheets: Manage spreadsheets sheets — copies a single sheet from a spreadsheet to another spreadsheet. returns the properties of the newly created sheet. Supports standard CRUD operations through the REST API.
  - spreadsheets_values: Manage spreadsheets values — sets values in one or more ranges of a spreadsheet. the caller must specify the spreadsheet id, a valueinputoption, and one or more valueranges, 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 (such as formatting and data validation) are kept, returns one or more ranges of values that match the specified data filters. for more information, see [read, write, and search metadata](https://developers.google.com/workspace/sheets/api/guides/metadata). 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. Supports standard CRUD operations through the REST API.