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.
MCP Google Sheets Server
This project provides a Model Context Protocol (MCP) server that allows interaction with Google Sheets.
It exposes tools to:
- List sheets (tabs) within a spreadsheet.
- Read data from specific cell ranges.
- Write data to specific cell ranges.
It explicitly does not provide tools for managing Google Drive files (listing, creating, deleting folders/files). Access is restricted to spreadsheet content only.
Prerequisites
- Python 3.11+
- Google Cloud Project with the Google Sheets API enabled
- Service Account Key:
- Go to the Google Cloud Console and create a new Service Account.
- Download the service account key file (JSON format).
- Grant this service account the "Editor" role for the Google Sheets you want to access.
How to use
-
Clone the repository.
git clone https://github.com/shionhonda/mcp-gsheet.git -
Set up Google Credentials:
- Set the
GOOGLE_APPLICATION_CREDENTIALSenvironment variable to the absolute path of your downloaded service account JSON key file.
export GOOGLE_APPLICATION_CREDENTIALS="/path/to/your/service-account-key.json"- Alternatively, you can place the key file in a standard location recognized by the Google Cloud client libraries (not recommended for shared environments).
- Set the
-
Install Dependencies:
uv venv source .venv/bin/activate -
Run the Server
To develop the server with MCP Inspector:
mcp dev server.pyTo run the server:
mcp run server.pyThe server will start and listen for MCP requests over standard input/output (stdio).
Claude Desktop
Add the following to your Claude Desktop configuration:
{
"mcpServers": {
"gsheet": {
"command": "/path/to/uv",
"env": {
"GOOGLE_APPLICATION_CREDENTIALS": "/path/to/your/service-account-key.json"
},
"args": ["--directory", "/path/to/mcp-gsheet", "run", "server.py"]
}
}
}
MCP Tools Provided
list_sheets(spreadsheet_id: str) -> list[str]: Lists the names of all sheets in the specified spreadsheet.read_cells(spreadsheet_id: str, range_name: str) -> list[list[str]]: Reads data from the given range (e.g.,'Sheet1!A1:B5').write_cells(spreadsheet_id: str, range_name: str, values: list[list[str]]) -> str: Writes the provided 2D list of values to the specified starting cell/range (e.g.,'Sheet1!C1').
