mcp-gsheet
If you are the rightful owner of mcp-gsheet 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.
The MCP Google Sheets Server allows interaction with Google Sheets through a Model Context Protocol server, providing tools to list, read, and write data within spreadsheets.
The MCP Google Sheets Server is designed to facilitate interaction with Google Sheets by providing a Model Context Protocol (MCP) server. This server allows users to list sheets, read data from specific cell ranges, and write data to specific cell ranges within a spreadsheet. It is important to note that this server does not manage Google Drive files, such as listing, creating, or deleting folders/files. The server is focused solely on spreadsheet content. To use this server, users need Python 3.11+, a Google Cloud Project with the Google Sheets API enabled, and a service account key with appropriate permissions. The server can be run in development mode with MCP Inspector or in standard mode to listen for MCP requests over stdio.
Features
- List sheets within a spreadsheet
- Read data from specific cell ranges
- Write data to specific cell ranges
- Restricted to spreadsheet content only
- Requires Google Cloud Project and service account
Tools
list_sheets
List all worksheet names in the specified spreadsheet
read_cells
Read data from a specified range
write_cells
Write data to the specified range
