# google-sheets OpenAPI overview

> Below is an overview of the google-sheets openapi in simple language. This API contains 17 endpoints.

For more detailed information of an endpoint, visit https://oapis.org/summary/google-sheets/[idOrRoute]

Google Sheets API vv4 - https://sheets.googleapis.com
Reads and writes Google Sheets.

## spreadsheets

- [sheets.spreadsheets.create](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.create): POST https://sheets.googleapis.com/v4/spreadsheets - 
- [sheets.spreadsheets.get](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.get): GET https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}?includeGridData=boolean&ranges=array - 
- [sheets.spreadsheets.developerMetadata.get](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.developerMetadata.get): GET https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId} - 
- [sheets.spreadsheets.developerMetadata.search](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.developerMetadata.search): POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/developerMetadata:search - 
- [sheets.spreadsheets.sheets.copyTo](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.sheets.copyTo): POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo - 
- [sheets.spreadsheets.values.get](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.values.get): GET https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}?dateTimeRenderOption=string&majorDimension=string&valueRenderOption=string - 
- [sheets.spreadsheets.values.update](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.values.update): PUT https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}?includeValuesInResponse=boolean&responseDateTimeRenderOption=string&responseValueRenderOption=string&valueInputOption=string - 
- [sheets.spreadsheets.values.append](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.values.append): POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append?includeValuesInResponse=boolean&insertDataOption=string&responseDateTimeRenderOption=string&responseValueRenderOption=string&valueInputOption=string - 
- [sheets.spreadsheets.values.clear](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.values.clear): POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:clear - 
- [sheets.spreadsheets.values.batchClear](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.values.batchClear): POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchClear - 
- [sheets.spreadsheets.values.batchClearByDataFilter](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.values.batchClearByDataFilter): POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchClearByDataFilter - 
- [sheets.spreadsheets.values.batchGet](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.values.batchGet): GET https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchGet?dateTimeRenderOption=string&majorDimension=string&ranges=array&valueRenderOption=string - 
- [sheets.spreadsheets.values.batchGetByDataFilter](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.values.batchGetByDataFilter): POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter - 
- [sheets.spreadsheets.values.batchUpdate](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.values.batchUpdate): POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchUpdate - 
- [sheets.spreadsheets.values.batchUpdateByDataFilter](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.values.batchUpdateByDataFilter): POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter - 
- [sheets.spreadsheets.batchUpdate](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.batchUpdate): POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}:batchUpdate - 
- [sheets.spreadsheets.getByDataFilter](https://oapis.org/openapi/google-sheets/sheets.spreadsheets.getByDataFilter): POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}:getByDataFilter -