Google Sheets · Capability
Google Sheets Spreadsheet Data Management
Workflow for managing spreadsheet data including creating spreadsheets, reading and writing cell values, batch operations, and metadata management. Used by data analysts, developers, and automation engineers.
What You Can Do
POST
Create spreadsheet
— Create a new spreadsheet
/v1/spreadsheets
GET
Get spreadsheet
— Get spreadsheet details
/v1/spreadsheets/{spreadsheetId}
GET
Get values
— Read values from a range
/v1/spreadsheets/{spreadsheetId}/values/{range}
PUT
Update values
— Write values to a range
/v1/spreadsheets/{spreadsheetId}/values/{range}
POST
Append values
— Append values to a range
/v1/spreadsheets/{spreadsheetId}/values/{range}
DELETE
Clear values
— Clear values from a range
/v1/spreadsheets/{spreadsheetId}/values/{range}
MCP Tools
create-spreadsheet
Create a new Google Sheets spreadsheet
get-spreadsheet
Get spreadsheet details by ID
read-only
idempotent
batch-update-spreadsheet
Apply batch updates to a spreadsheet
get-values
Read values from a spreadsheet range
read-only
idempotent
update-values
Write values to a spreadsheet range
idempotent
append-values
Append rows of data to a spreadsheet
clear-values
Clear values from a spreadsheet range
idempotent
batch-get-values
Read values from multiple ranges at once
read-only
idempotent
batch-update-values
Write values to multiple ranges at once
idempotent
batch-clear-values
Clear values from multiple ranges
idempotent
copy-sheet
Copy a sheet to another spreadsheet
get-developer-metadata
Get developer metadata by ID
read-only
idempotent
search-developer-metadata
Search developer metadata matching filters
read-only
idempotent
APIs Used
google-sheets