MCP Google Sheets Server
About
MCP server for Google Sheets - Read, write and manipulate spreadsheets through Claude Desktop
Details
- Author
- freema
- Downloads
- 480
- Categories
- Productivity, Other, Automation
Jump to
- Read cell values, ranges, and metadata from spreadsheets
- Write, update, append, and clear cell data
- Add, delete, duplicate, and copy sheets
- Format cells with colors, fonts, alignment, and borders
- Merge and unmerge cells; add conditional formatting rules
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
MCP Google Sheets ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Requires Node.js 18+, a Google Cloud project with the Sheets API enabled, and a service account JSON key. Install via git clone, then run npm install and npm run build. Use the interactive setup script (npm run setup) or manually configure your MCP client (e.g., Claude Desktop) by adding the server configuration with absolute paths to the built script and environment variables for GOOGLE_PROJECT_ID and GOOGLE_APPLICATION_CREDENTIALS. After configuration, restart your MCP client.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mcp google sheets server": {
"mcp-gsheets": {
"command": "node",
"args": [
"/absolute/path/to/mcp-gsheets/dist/index.js"
],
"env": {
"GOOGLE_PROJECT_ID": "",
"GOOGLE_APPLICATION_CREDENTIALS": ""
}
}
}
}
}McpServers
{
"mcp-gsheets": {
"command": "node",
"args": [
"/absolute/path/to/mcp-gsheets/dist/index.js"
],
"env": {
"GOOGLE_PROJECT_ID": "",
"GOOGLE_APPLICATION_CREDENTIALS": ""
}
}
}Google Sheets - ](https://github.com/freema/mcp-gsheets/blob/HEAD/LICENSE)[BlackHawkMCP](https://g📇 ☁️ - MCP server connecting AI to Google Sheets. Read, write, and manage spreadsheets via natural language.
MCP server for Google Sheets — read, write, append, and clear data in any spreadsheet using OAuth. Works with Claude Desktop and any MCP client.
Manage personal finances, track transactions, and create budgets with Budgetsco.
A powerful server for Excel file processing, data analysis, and visualization, leveraging Python and Go for high performance.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
