Awesome MCP › Other MCP Servers

freema/mcp-gsheets

⭐ 98 TypeScript repository created 2025-05-24

MCP Google Sheets Server gives MCP clients access to Google Sheets documents. Its tools read cell ranges in A1 notation, write and append values, clear ranges, and manage the structure of a workbook — adding, renaming and deleting sheets. Batch operations let several ranges be read or updated in one call, which matters both for speed and for staying inside Google's API quotas when a model is working across a large sheet. Formatting operations cover the presentation layer rather than only values. Because a spreadsheet is a common place for small structured datasets that never justified a database, the practical use is direct: a model can read a tracking sheet, compute something and write results back, or populate a sheet from data it gathered elsewhere. Authentication uses a Google service account or OAuth credentials, and access is bounded by what that identity has been granted on specific documents — sharing a single sheet with a service account is a clean way to limit exposure. The server is TypeScript requiring Node.js 20 or newer, published on npm as mcp-gsheets, MIT licensed, with continuous integration and coverage reporting, and registered as io.github.freema/mcp-gsheets. The audience is people who keep working data in Sheets and want an assistant reading and updating it.

https://github.com/freema/mcp-gsheets

mcpgoogle-sheetsspreadsheetstypescriptnodejsoauthbatch-operations