Community Productivity

Google Sheets

Read + write Google Sheets — cells, ranges, formatting.

930 stars 215 forks Last commit 1mo ago Language TypeScript License MIT
Sign in to like, install, or save to a bundle → View on GitHub →

Install

npm install -g @xing5/mcp-google-sheets

Maintainer? Add the badge

Listed on Prismix ← shows on your README, links back here
[![Listed on Prismix](https://prismix.dev/api/badge/mcp/google-sheets.svg)](https://prismix.dev/mcp/google-sheets)

About

Google Sheets API bridge. Cell + range reads + writes, formula manipulation, formatting, sheet management. OAuth.

Recent releases (5)

All releases →
  • v0.6.3 Latest May 14, 2026
    ## Summary
    
    Maintenance release for MCP stdio safety.
    
    ## Changes
    
    - Route diagnostic output through stdlib logging to stderr so stdout remains reserved for MCP stdio JSON-RPC.
    - Configure CLI logging from main() instead of at import time.
    - Disable Google API discovery file cache with cache_discovery=False.
    - Add unit regression tests that reject direct print() calls in server.py and verify main() does not write diagnostics to stdout.
    
    ## Verification
    
    - Required unit tests passed on main.
    - Publishing workflow will run live Google integration tests before PyPI publish.
    View on GitHub ↗
  • v0.6.2 May 14, 2026
    ## Summary
    
    Maintenance release focused on release quality and test coverage.
    
    ## Changes
    
    - Add credential-free unit tests and required PR test workflow for Python 3.10 and 3.12.
    - Add live Google integration coverage for every current MCP tool and gate PyPI publishing on it.
    - Add a local GitHub todo triage skill and status ledger for maintainer workflow.
    - Fix chart creation source ranges so Google Sheets accepts multi-column table data by splitting domain and series ranges.
    
    ## Verification
    
    - Unit test workflow passes on main.
    - Live Google integration workflow passes against disposable Google Drive test resources.
    View on GitHub ↗
  • v0.6.1 Mar 15, 2026
    ## What's Changed
    * feat: add search_spreadsheets and find_in_spreadsheet tools by @dmitry-simple-it in https://github.com/xing5/mcp-google-sheets/pull/60
    * feat: Add tool annotations for improved LLM tool understanding by @bryankthompson in https://github.com/xing5/mcp-google-sheets/pull/57
    * Add tool filtering to reduce context window consumption by @Copilot in https://github.com/xing5/mcp-google-sheets/pull/61
    * Add chart creation functionality to Google Sheets MCP server by @Copilot in https://github.com/xing5/mcp-google-sheets/pull/62
    
    ## New Contributors
    * @dmitry-simple-it made their first contribution in https://github.com/xing5/mcp-google-sheets/pull/60
    * @bryankthompson made their first contribution in https://github.com/xing5/mcp-google-sheets/pull/57
    * @Copilot made their first contribution in https://github.com/xing5/mcp-google-sheets/pull/61
    
    **Full Changelog**: https://github.com/xing5/mcp-google-sheets/compare/v0.6.0...v0.6.1
    View on GitHub ↗
  • v0.6.0 Dec 6, 2025
    ## What's Changed
    * Fix token refresh error handling to prevent server crashes by @slhck in https://github.com/xing5/mcp-google-sheets/pull/52
    * Update README to match actual tools and enhance clarity and detail by @squatto in https://github.com/xing5/mcp-google-sheets/pull/55
    * Add batch_update tool to expose full batchUpdate endpoint (allows Claude to format cells) by @drPod in https://github.com/xing5/mcp-google-sheets/pull/54
    * chore: Add fallback version for cases when I do not have tag by @jhutar in https://github.com/xing5/mcp-google-sheets/pull/47
    
    ## New Contributors
    * @slhck made their first contribution in https://github.com/xing5/mcp-google-sheets/pull/52
    * @squatto made their first contribution in https://github.com/xing5/mcp-google-sheets/pull/55
    * @drPod made their first contribution in https://github.com/xing5/mcp-google-sheets/pull/54
    * @jhutar made their first contribution in https://github.com/xing5/mcp-google-sheets/pull/47
    
    **Full Changelog**: https://github.com/xing5/mcp-google-sheets/compare/v0.5.2...v0.6.0
    View on GitHub ↗
  • v0.5.2 Nov 9, 2025
    ## What's Changed
    * feat: add Docker support and update server configuration by @omarsaad98 in https://github.com/xing5/mcp-google-sheets/pull/50
    * Add list_folders tool and ability to specify folder ID for creating/listing sheets by @lukmanr in https://github.com/xing5/mcp-google-sheets/pull/48
    
    ## New Contributors
    * @omarsaad98 made their first contribution in https://github.com/xing5/mcp-google-sheets/pull/50
    * @lukmanr made their first contribution in https://github.com/xing5/mcp-google-sheets/pull/48
    
    **Full Changelog**: https://github.com/xing5/mcp-google-sheets/compare/v0.5.1...v0.5.2
    View on GitHub ↗

Discussion (0)

Sign in to comment →

No comments yet. Sign in to start the discussion.

More Productivity servers