google-workspace -inhouse

google-workspace-mcp-inhouse is a read-only MCP server that provides access to Google Docs and Google Sheets data without write permissions. It exposes 11 tools across Docs and Sheets that let AI agents read document bodies, fetch metadata, list items, and search content. Tools include read_document, list_documents, search_documents, get_document_info, list_comments, get_comment for Docs, and read_spreadsheet, get_spreadsheet_info, list_spreadsheets, search_spreadsheets, get_sheet_range for Sheets. To use it, start the binary on a host with a valid credentials.json already configured, then connect your agent or Claude-compatible runner to the MCP server via the standard .mcp.json registration snippet. The server handles authentication against Google services in read-only mode and returns information in formats such as Markdown, CSV, or JSON depending on the tool and parameters you pass.

Prerequisites:

• A host with macOS, Linux, or Windows capable of running the binary
• Go toolchain not strictly required for end users, but the project uses a Go-based binary that is installed via the provided scripts
• Credentials: Obtain credentials.json from the Google Cloud Console and configure it in the expected config directory

Installation steps:

1. macOS / Linux:

curl -fsSL https://raw.githubusercontent.com/flowernotfound/google-workspace-mcp-inhouse/master/install.sh | bash

The installer places the binary at a typical location like ~/bin/google-workspace-mcp-inhouse.

2. Windows (PowerShell):

irm https://raw.githubusercontent.com/flowernotfound/google-workspace-mcp-inhouse/master/install.ps1 | iex

The installer places the binary under %LOCALAPPDATA%\Programs\google-workspace-mcp-inhouse.

3) Post-install: ensure the binary is in your PATH and that credentials.json is placed in the expected config directory, e.g. ~/.config/google-workspace-mcp-inhouse/credentials.json on macOS/Linux or the corresponding Windows path.

4) Authenticate and configure:
```bash
# macOS / Linux
google-workspace-mcp-inhouse auth

This opens a browser to authorize read-only access to Google Docs/Sheets.

5. Register with Claude Code (example .mcp.json):

{
  "mcpServers": {
    "google-workspace-mcp-inhouse": {
      "type": "stdio",
      "command": "${HOME}/bin/google-workspace-mcp-inhouse"
    }
  }
}

Optional: If you installed in Windows, adjust the path accordingly to the exe location.

Tips and notes:

• This server is read-only by design; write operations are not exposed.
• Ensure credentials.json is kept secure and that the config directory has proper permissions.
• If you encounter authentication issues, re-run the auth step and confirm the Google account has the necessary read permissions for the target documents and spreadsheets.
• The tools support parameters for filtering, formatting (markdown vs text for documents, CSV vs JSON for spreadsheets), and range queries for sheets. Use the provided parameter tables in the README to construct valid requests.
• When integrating with Claude Code, use the standard .mcp.json registration snippet to expose google-workspace-mcp-inhouse as a stdio server.