google-sheets-mcp-server
If you are the rightful owner of google-sheets-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol (MCP) server for Google Sheets that enables Claude Desktop to interact with Google Sheets directly.
The Google Sheets MCP Server is designed to facilitate seamless interaction between Claude Desktop and Google Sheets. It allows users to create, read, write, and manage Google Sheets directly from Claude Desktop. The server supports a variety of operations such as formatting cells, adding or deleting sheets, writing formulas, and searching for sheets. It requires Python 3.10 or higher, a Google Cloud Project with the Google Sheets API enabled, and OAuth 2.0 credentials. The server is set up using a virtual environment and the `uv` package manager, and it integrates with Claude Desktop through a configuration file. Once set up, users can execute various commands to manipulate Google Sheets, making it a powerful tool for managing spreadsheets programmatically.
Features
- Create new Google Sheets
- Read and write data to existing sheets
- Format cells and ranges
- Add and delete sheets
- Write formulas
