Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| GOOGLE_API_KEY | No | Google API key for public Google Sheets access. | |
| GOOGLE_OAUTH_TOKEN_FILE | No | Path to the stored Google OAuth refreshable token JSON file. | |
| GOOGLE_OAUTH_ACCESS_TOKEN | No | An existing Google OAuth bearer access token. | |
| GOOGLE_SERVICE_ACCOUNT_FILE | No | Path to the Google Cloud service account key JSON file. | |
| GOOGLE_OAUTH_CLIENT_SECRETS_FILE | No | Path to the Google OAuth client secret JSON file for desktop application authentication. |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| diagnose_google_auth | Return a quick summary of the active Google authentication setup. |
| resolve_google_file | Resolve basic metadata for a Google Docs, Sheets, or Drive file. |
| read_sheet_values | Read raw Google Sheets values for an A1 range. |
| read_sheet_grid | Read Google Sheets grid data including formatted values, formulas, notes, and links. |
| get_sheet_row | Fetch one Google Sheets row and map it to the header row. |
| search_sheet | Search text across one sheet or all sheets and return matching cells. |
| sheet_to_json | Convert a Google Sheets tab into JSON records using the header row. |
| inspect_sheet_images | Inspect Google Sheets images via XLSX export and detect IMAGE() formulas. |
| read_google_doc | Read a Google Doc as structured JSON with text, tables, and image metadata. |
| download_google_doc_images | Download image objects from a Google Doc to a local folder. |
| export_google_file | Export a Google Workspace file to PDF, XLSX, HTML zip, Markdown, or plain text. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |