Google Workspace MCP
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_authB | Return a quick summary of the active Google authentication setup. |
| resolve_google_fileB | Resolve basic metadata for a Google Docs, Sheets, or Drive file. |
| read_sheet_valuesC | Read raw Google Sheets values for an A1 range. |
| read_sheet_gridC | Read Google Sheets grid data including formatted values, formulas, notes, and links. |
| get_sheet_rowC | Fetch one Google Sheets row and map it to the header row. |
| search_sheetC | Search text across one sheet or all sheets and return matching cells. |
| sheet_to_jsonB | Convert a Google Sheets tab into JSON records using the header row. |
| inspect_sheet_imagesB | Inspect Google Sheets images via XLSX export and detect IMAGE() formulas. |
| read_google_docB | Read a Google Doc as structured JSON with text, tables, and image metadata. |
| download_google_doc_imagesC | Download image objects from a Google Doc to a local folder. |
| export_google_fileB | 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 | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/NgoQuocViet2001/google-workspace-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server