📇 ☁️ - MCP server for Google Sheets API integration with comprehensive reading, writing, formatting, and sheet management capabilities.
Install
npx -y mcp-gsheets@latestRequired environment variables
GOOGLE_SERVICE_ACCOUNT_KEYSet in your MCP configGOOGLE_PRIVATE_KEYSet in your MCP configclaude_desktop_config.json
{
"mcpServers": {
"freema-mcp-gsheets": {
"command": "npx",
"args": [
"-y",
"mcp-gsheets@latest"
],
"env": {
"GOOGLE_SERVICE_ACCOUNT_KEY": "<YOUR_GOOGLE_SERVICE_ACCOUNT_KEY>",
"GOOGLE_PRIVATE_KEY": "<YOUR_GOOGLE_PRIVATE_KEY>"
}
}
}
}Add this to your Claude Desktop config file. Find it at ~/Library/Application Support/Claude/claude_desktop_config.json on macOS.
What this does
freema/mcp-gsheets exposes a set of tools to Claude over the Model Context Protocol. After you add it to claude_desktop_config.json (snippet above) and restart Claude Desktop, those tools become callable inside any conversation. That makes it useful when you want Claude to reach into your team's communication channels without copy-pasting context every turn.
Requirements
This server needs the following environment variables to be set before it can run:
GOOGLE_SERVICE_ACCOUNT_KEY GOOGLE_PRIVATE_KEY
Set these via the env object in your MCP config (see claude_desktop_config.json snippet above).
Common use cases
- •Read recent threads, channels, or DMs to summarize team activity
- •Send messages, replies, or status updates as part of a workflow
- •Bring stakeholder context into a Claude conversation without copy-paste
More TypeScript MCP servers
microsoft/markitdown
🎖️ 🐍 🏠 - MCP tool access to MarkItDown -- a library that converts many file formats (local or remote) to Markdown for LLM consumption.
upstash/context7
📇 ☁️ - Up-to-date code documentation for LLMs and AI code editors.
microsoft/playwright-mcp
Official Microsoft Playwright MCP server, enabling LLMs to interact with web pages through structured accessibility snapshots
agent-infra/mcp-server-browser
📇 🏠 - Browser automation capabilities using Puppeteer, both support local and remote browser connection.