mcp-google-sheets-server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| GOOGLE_SERVICE_ACCOUNT_KEY | Yes | Your Google Service Account key (JSON) for authentication |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| sheets_get_dataB | Get data from Google Sheets with optional formatting |
| sheets_update_dataC | Update data in Google Sheets with optional formatting |
| sheets_createC | Create a new Google Sheets with optional initial data and formatting |
| sheets_format_cellsB | Apply formatting to cells including colors, fonts, borders, and alignment |
| sheets_conditional_formattingB | Apply conditional formatting rules to cells |
| sheets_merge_cellsC | Merge cells in a range |
| sheets_create_chartB | Create various types of charts in Google Sheets |
| sheets_update_chartC | Update an existing chart in Google Sheets |
| sheets_set_data_validationC | Set data validation rules for cells |
| sheets_protect_rangeB | Protect a range of cells from editing |
| sheets_insert_rowsB | Insert rows at a specific position |
| sheets_insert_columnsC | Insert columns at a specific position |
| sheets_delete_rowsC | Delete rows from a specific position |
| sheets_delete_columnsA | Delete columns from a specific position |
| sheets_set_formulaB | Set formulas in cells |
| sheets_calculate_formulaC | Calculate the result of a formula |
| sheets_create_sheetC | Create a new sheet in the spreadsheet |
| sheets_duplicate_sheetC | Duplicate an existing sheet |
| sheets_delete_sheetC | Delete a sheet from the spreadsheet |
| sheets_rename_sheetC | Rename an existing sheet |
| sheets_hide_sheetB | Hide a sheet from view (make it invisible) |
| sheets_show_sheetA | Show a hidden sheet (make it visible again) |
| sheets_move_sheetA | Move a sheet to a different position in the spreadsheet |
| sheets_get_sheet_infoC | Get detailed information about all sheets in a spreadsheet |
| sheets_get_sheet_propertiesC | Get properties of a specific sheet (title, index, hidden status, etc.) |
| sheets_create_chart_with_dataC | Create a chart with data and automatically populate it |
| sheets_create_chart_from_tableB | Create a chart from a table structure with headers and data |
| sheets_update_chart_dataC | Update chart data and refresh the chart |
| sheets_delete_chartB | Delete a chart from the spreadsheet |
| sheets_list_chartsA | List all charts in a spreadsheet with their details |
| sheets_searchB | Search for Google Sheets by name or content |
| sheets_shareB | Share Google Sheets with specific permissions |
| sheets_get_metadataB | Get comprehensive metadata about Google Sheets |
| sheets_batch_updateC | Perform multiple operations in a single request for better performance |
| sheets_batch_getA | Get data from multiple ranges in a single request |
| sheets_clear_rangeA | Clear content and formatting from a range |
| sheets_copy_toA | Copy a sheet to another spreadsheet |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 37 tools
Several tools have overlapping purposes: three chart creation tools, update_chart vs update_chart_data, and get_metadata vs get_sheet_info/get_sheet_properties are hard to distinguish without deep inspection. This creates ambiguity for an agent selecting the right tool.
Tool names mostly follow a consistent sheets_verb_noun snake_case pattern. Minor inconsistencies like 'conditional_formatting' instead of a verb-based name and varied chart-creation forms prevent a perfect score.
With 37 tools, the server is well beyond the typical comfortable range and feels heavy. Many tools are slight variations of the same operation, making the large count harder to justify.
The tool surface covers spreadsheets, sheets, charts, formatting, data validation, and protection comprehensively. Only minor gaps like deleting/copying a spreadsheet or appending rows keep it from being fully complete.