google-sheet-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| SHEETS_CLIENT_ID | Yes | OAuth client ID from Google Cloud | |
| SHEETS_CLIENT_SECRET | Yes | OAuth client secret from Google Cloud | |
| SHEETS_REFRESH_TOKEN | Yes | Refresh token obtained via npm run auth |
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_create_spreadsheetB | Create a new Google spreadsheet. |
| sheets_get_valuesC | Read values from a Google Sheet range. |
| sheets_update_valuesC | Overwrite values in a Google Sheet range. |
| sheets_append_valuesC | Append rows to a Google Sheet range. |
| sheets_clear_valuesC | Clear values from a Google Sheet range. |
| sheets_add_sheetC | Add a new tab/sheet to a spreadsheet. |
| sheets_paste_markdown_reportB | Paste a markdown report into a sheet as one line per row. |
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 7 tools
Each tool targets a distinct action (add sheet, append, clear, create, get, paste markdown, update) with no overlap in purpose, ensuring an agent can easily distinguish them.
All tools follow a consistent 'sheets_verb_noun' pattern (e.g., sheets_add_sheet, sheets_get_values), with only 'sheets_paste_markdown_report' slightly deviating in verb form but still predictable.
Seven tools is well-scoped for a Google Sheets server, covering creation, reading, writing, appending, clearing, tab management, and a specialized markdown paste function without being overwhelming.
The tool set covers core operations (create, read, update, append, clear) and adds tab management and markdown support, though missing explicit delete operations (e.g., delete sheet or row) which are minor gaps.