Google Sheets MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| GOOGLE_APPLICATION_CREDENTIALS | Yes | Path to the Google service account key JSON file |
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
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| read_sheetC | スプレッドシートの指定された範囲のデータを読み取ります |
| write_sheetC | スプレッドシートの指定された範囲にデータを書き込みます |
| append_rowC | スプレッドシートの最後に新しい行を追加します |
| get_sheet_infoC | スプレッドシートの基本情報を取得します |
| create_sheetC | 新しいシートを作成します |
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 5 tools
Each tool has a clearly distinct purpose with no overlap: append_row adds rows, create_sheet creates sheets, get_sheet_info retrieves metadata, read_sheet reads data, and write_sheet writes data. The descriptions clearly differentiate between operations on data versus structure.
All tools follow a consistent verb_noun pattern with snake_case naming (e.g., append_row, create_sheet, read_sheet). The verbs are action-oriented and predictable, making the set easy to navigate.
Five tools is reasonable for a Google Sheets server, covering core operations like reading, writing, appending, creating sheets, and getting info. It's slightly lean but functional; minor additions like update or delete operations could enhance it without being necessary.
The tools cover essential CRUD-like operations for Google Sheets: create (create_sheet), read (read_sheet, get_sheet_info), and write/append (write_sheet, append_row). A minor gap is the lack of explicit update or delete tools, but agents can work around this using write_sheet for updates.