Google Sheets MCP
About
MCP server for Google Sheets — read, write, append, and clear data in any spreadsheet using OAuth. Works with Claude Desktop and any MCP client.
Details
- Author
- generalist-club
- Categories
- Cloud Service, Other, Productivity
Jump to
Setup
Install Google Sheets MCP in your MCP client (Claude Desktop, Cursor, Windsurf, and others).
Repository: https://github.com/generalist-club/google-sheets-mcp
Follow the installation instructions in the repository README, then restart your MCP client.
MCP server for Google Sheets — read, write, append, and clear data in any spreadsheet using OAuth. Works with Claude Desktop and any MCP client.
All tools accept a full Google Sheets URLora bare spreadsheet ID.
- Node.js 18+
- A Google account
- A Google Cloud project (free)
git clone https://github.com/generalist-club/google-sheets-mcp.git cd google-sheets-mcp npm install
2. Create a Google Cloud project & OAuth credentials
- Go toGoogle Cloud Console - Create a new project (or select an existing one) - Enable theGoogle Sheets APIandGoogle Drive API:- Navigate toAPIs & Services → Library
- Search for and enable both APIs
- Navigate toAPIs & Services → Credentials
- ClickCreate Credentials → OAuth client ID
- Application type:Desktop app
- Download the JSON file
Run the auth script to generate your token:
It will print a URL. Open it in your browser, authorize the app, then paste the code back into the terminal. This creates atoken.jsonfile locally — keep it secret.
Token refresh:The server automatically refreshes the access token when it expires. You should only need to runauth.jsonce.
4. Configure Claude Desktop (or any MCP client)
Add this server to your Claude Desktop config at~/Library/Application Support/Claude/claude_desktop_config.json:
{ "mcpServers": { "google-sheets": { "command": "node", "args": Replace/absolute/path/to/google-sheets-mcpwith the actual path on your machine.
Restart Claude Desktop. The five Google Sheets tools will now be available.
Once connected, you can ask Claude things like:
- "Read the data from this spreadsheet:https://docs.google.com/spreadsheets/d/..."
- "Append a new row with today's date and 42 to Sheet1"
- "What sheets are in this workbook and how many rows does each have?"
- "Clear the range B2:D10 in my spreadsheet"
- credentials.jsonandtoken.jsonare excluded from git via.gitignore— never commit them
- The OAuth token is stored locally and only grants access to your own Google account
- Scopes requested:spreadsheets(read/write) anddrive.readonly(to resolve sheet metadata)
Google Sheets - BlackHawkMCP without needing Microsoft Excel, featuring an integrated AI assistant.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
