Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| LOG_LEVEL | No | Logging level for the server | INFO |
| SERVER_NAME | No | Server configuration name | google-sheets-mcp-server |
| SHEET_API_KEY | No | Your Google API key for accessing public spreadsheets (optional fallback to OAuth) | |
| SERVER_VERSION | No | Server version | 1.0.0 |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| read_sheet_data | Read data from a Google Sheet by spreadsheet ID and range |
| get_sheet_metadata | Get metadata about a Google Spreadsheet |
| list_sheets | List all sheets/tabs in a Google Spreadsheet |
| search_sheet_data | Search for specific data in a Google Sheet |
| get_range_data | Get data from a specific range with formatting options |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| Google Sheets Reader | Access and read Google Sheets data |