Google Workspace Mcp Inhouse

google-workspace-mcp-inhouse

> 日本語版: [READMEja.md](READMEja.md)

A read-only MCP server for Google Docs and Google Sheets. Provides 11 tools for AI agents to read, list, and search Google Docs and Sheets — no write access.

---

Available Tools

Google Docs

| Tool | Description | |------|-------------| | read_document | Fetch document body as Markdown or plain text | | list_documents | List Google Docs in your Drive | | search_documents | Search documents by keyword | | get_document_info | Get document metadata (title, owner, timestamps) | | list_comments | List comments on a document | | get_comment | Get a specific comment and its reply thread |

Google Sheets

| Tool | Description | |------|-------------| | read_spreadsheet | Fetch sheet content as CSV or JSON | | get_spreadsheet_info | Get spreadsheet metadata (title, sheets, locale, timezone) | | list_spreadsheets | List Google Sheets in your Drive | | search_spreadsheets | Search spreadsheets by keyword | | get_sheet_range | Get cell values for a specific range (A1 notation) |

Tool parameters

read_document

| Parameter | Type | Required | Default | Description | |-----------|------|----------|---------|-------------| | document_id | string | Yes | — | Google Docs document ID | | format | string | No | "markdown" | Output format: "markdown" or "text" |

list_documents

| Parameter | Type | Required | Default | Description | |-----------|------|----------|---------|-------------| | folder_id | string | No | — | Restrict to a specific folder | | max_results | number | No | 20 | Max items to return (limit: 100) | | order_by | string | No | "modifiedTime desc" | Sort order |

search_documents

| Parameter | Type | Required | Default | Description | |-----------|------|----------|---------|-------------| | query | string | Yes | — | Search keyword | | max_results | number | No | 10 | Max items to return (limit: 50) |

get_document_info

| Parameter | Type | Required | Default | Description | |-----------|------|----------|---------|-------------| | document_id | string | Yes | — | Google Docs document ID |

list_comments

| Parameter | Type | Required | Default | Description | |-----------|------|----------|---------|-------------| | document_id | string | Yes | — | Google Docs document ID | | include_resolved | boolean | No | false | Whether to include resolved comments |

get_comment

| Parameter | Type | Required | Default | Description | |-----------|------|----------|---------|-------------| | document_id | string | Yes | — | Google Docs document ID | | comment_id | string | Yes | — | Comment ID |

read_spreadsheet

| Parameter | Type | Required | Default | Description | |-----------|------|----------|---------|-------------| | spreadsheet_id | string | Yes | — | Google Sheets spreadsheet ID | | sheet_name | string | No | — | Sheet name to read (defaults to first sheet) | | format | string | No | "csv" | Output format: "csv" or "json" |

get_spreadsheet_info

| Parameter | Type | Required | Default | Description | |-----------|------|----------|---------|-------------| | spreadsheet_id | string | Yes | — | Google Sheets spreadsheet ID |

list_spreadsheets

| Parameter | Type | Required | Default | Description | |-----------|------|----------|---------|-------------| | folder_id | string | No | — | Restrict to a specific folder | | max_results | number | No | 20 | Max items to return (limit: 100) | | order_by | string | No | "modifiedTime desc" | Sort order |

search_spreadsheets

| Parameter | Type | Required | Default | Description | |-----------|------|----------|---------|-------------| | query | string | Yes | — | Search keyword | | max_results | number | No | 10 | Max items to return (limit: 50) |

get_sheet_range

| Parameter | Type | Required | Default | Description | |-----------|------|----------|---------|-------------| | spreadsheet_id | string | Yes | — | Google Sheets spreadsheet ID | | range | string | Yes | — | Range in A1 notation (e.g. Sheet1!A1:D10) |

---

Installation

macOS / Linux

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

The binary is installed to ~/bin/google-workspace-mcp-inhouse.

Windows (PowerShell)

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

The binary is installed to %LOCALAPPDATA%\Programs\google-workspace-mcp-inhouse\. The installer automatically adds the directory to your user PATH.

---

Setup

1. Place credentials.json

Obtain credentials.json from the GCP Console and place it in the config directory.

# macOS / Linux
mv ~/Downloads/credentials.json ~/.config/google-workspace-mcp-inhouse/credentials.json

# Windows (PowerShell)
Move-Item ~\Downloads\credentials.json ~\.config\google-workspace-mcp-inhouse\credentials.json

2. Authenticate

# macOS / Linux
google-workspace-mcp-inhouse auth

# Windows
google-workspace-mcp-inhouse.exe auth

A browser window opens. Sign in with your Google account to grant read-only access.

3. Register with Claude Code

Add the following to .mcp.json:

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

> Windows: Replace ${HOME}/bin/google-workspace-mcp-inhouse with the full path, e.g. > C:\Users\yourname\AppData\Local\Programs\google-workspace-mcp-inhouse\google-workspace-mcp-inhouse.exe

---

Updating

# macOS / Linux
google-workspace-mcp-inhouse update

# Windows — re-run the installer
irm https://raw.githubusercontent.com/flowernotfound/google-workspace-mcp-inhouse/master/install.ps1 | iex

---

Prerequisites (admin setup)

Before individual engineers can install this tool, an admin needs to set up the GCP project once. See [READMEja.md — GCP 初期設定](READMEja.md#gcp-初期設定管理者-1-回のみ) for the full setup guide.

---

Development

mise run build     # build binary
mise run test      # run tests
mise run lint      # run linter
mise run fmt       # format code

Requires mise and Go 1.23+.

Source & license

This open-source MCP server is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: flowernotfound
• Source: flowernotfound/google-workspace-mcp-inhouse
• License: MIT

Install and usage instructions live in the source repository linked above.