googleapis.com

Reads and writes Google Sheets.

🔑 oauth2 17 endpoints analyticsmedia
📄 Docs 📋 OpenAPI spec 🔬 Try in Swagger UI

SDKs by language (10 total)

mcp-toolbox-sdk-python ✓ Official
pip install mcp-toolbox-sdk-python
python-storage ✓ Official
pip install python-storage
python-aiplatform ✓ Official
pip install python-aiplatform
python-genai ✓ Official
pip install python-genai
js-genai ✓ Official
npm install js-genai
go-genai ✓ Official
go get github.com/googleapis/go-genai
sdk-platform-java ✓ Official
# Maven: see https://github.com/googleapis/sdk-platform-java
java-genai ✓ Official
# Maven: see https://github.com/googleapis/java-genai
dotnet-genai ✓ Official
# See https://github.com/googleapis/dotnet-genai
gax-java ✓ Official
# See https://github.com/googleapis/gax-java
curl examples
Returns the spreadsheet at the given ID. The caller must specify the spreadsh…
curl \
  -H "Authorization: Bearer $ACCESS_TOKEN" \
  https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}
Returns a range of values from a spreadsheet. The caller must specify the spr…
curl \
  -H "Authorization: Bearer $ACCESS_TOKEN" \
  https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}
Returns one or more ranges of values from a spreadsheet. The caller must spec…
curl \
  -H "Authorization: Bearer $ACCESS_TOKEN" \
  https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchGet
Endpoints (17 total)
GET
/v4/spreadsheets/{spreadsheetId}
Returns the spreadsheet at the given ID. The caller must specify the spreadsh…
GET
/v4/spreadsheets/{spreadsheetId}/values/{range}
Returns a range of values from a spreadsheet. The caller must specify the spr…
GET
/v4/spreadsheets/{spreadsheetId}/values:batchGet
Returns one or more ranges of values from a spreadsheet. The caller must spec…
GET
/v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId}
Returns the developer metadata with the specified ID. The caller must specify…
POST
/v4/spreadsheets
Creates a spreadsheet, returning the newly created spreadsheet.
POST
/v4/spreadsheets/{spreadsheetId}:batchUpdate
Applies one or more updates to the spreadsheet. Each request is validated bef…
POST
/v4/spreadsheets/{spreadsheetId}:getByDataFilter
Returns the spreadsheet at the given ID. The caller must specify the spreadsh…
POST
/v4/spreadsheets/{spreadsheetId}/values:batchClear
Clears one or more ranges of values from a spreadsheet. The caller must speci…
POST
/v4/spreadsheets/{spreadsheetId}/values:batchUpdate
Sets values in one or more ranges of a spreadsheet. The caller must specify t…
POST
/v4/spreadsheets/{spreadsheetId}/values/{range}:clear
Clears values from a spreadsheet. The caller must specify the spreadsheet ID …
POST
/v4/spreadsheets/{spreadsheetId}/values/{range}:append
Appends values to a spreadsheet. The input range is used to search for existi…
POST
/v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo
Copies a single sheet from a spreadsheet to another spreadsheet. Returns the …
At a glance
Total SDKs10
Languages6
Endpoints17
Authoauth2
Categories2
https://sheets.googleapis.com