Spreadsheet Mcp
What is Spreadsheet Mcp
spreadsheet-mcp is an MCP server designed for managing Google Spreadsheets, providing functionalities such as data fetching and CSV uploads.
Use cases
Use cases include automating data retrieval for reports, managing project timelines in spreadsheets, and facilitating data imports from CSV files into Google Sheets.
How to use
To use spreadsheet-mcp, clone the repository from GitHub, install the necessary dependencies, and configure the server according to the provided JSON configuration. Authentication is required via OAuth2.
Key features
Key features include fetching data from Google Spreadsheets in Markdown format, listing column names, identifying sheet URLs, retrieving all sheet names, uploading CSV files, and copying content between sheets.
Where to use
spreadsheet-mcp can be used in various fields such as data analysis, project management, and any scenario where Google Spreadsheets are utilized for data organization.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Spreadsheet Mcp
spreadsheet-mcp is an MCP server designed for managing Google Spreadsheets, providing functionalities such as data fetching and CSV uploads.
Use cases
Use cases include automating data retrieval for reports, managing project timelines in spreadsheets, and facilitating data imports from CSV files into Google Sheets.
How to use
To use spreadsheet-mcp, clone the repository from GitHub, install the necessary dependencies, and configure the server according to the provided JSON configuration. Authentication is required via OAuth2.
Key features
Key features include fetching data from Google Spreadsheets in Markdown format, listing column names, identifying sheet URLs, retrieving all sheet names, uploading CSV files, and copying content between sheets.
Where to use
spreadsheet-mcp can be used in various fields such as data analysis, project management, and any scenario where Google Spreadsheets are utilized for data organization.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
Spreadsheet MCP
An MCP server for operating Google Spreadsheets (Google Sheets)
Features
- Fetch data from Google Spreadsheets and display it in Markdown table format
- Get a list of column names (header row) from Google Spreadsheet sheets
- Identify the URL of a specified sheet name within a Google Spreadsheet
- Retrieve a list of all sheet names existing in a Google Spreadsheet
- Upload CSV files to Google Spreadsheets
- Copy the contents of one sheet to another sheet in Google Spreadsheets
This tool is designed for tabular sheets (with columns in the first row and no duplicate column names).
Authentication
https://docs.gspread.org/en/latest/oauth2.html
Configuration
{
"mcpServers": {
"spreadsheet": {
"command": "uvx",
"args": [
"spreadsheet-mcp"
]
}
}
}Development
Setting up the development environment
# Clone the repository
git clone https://github.com/yamitzky/spreadsheet-mcp.git
cd spreadsheet-mcp
# Install development dependencies
uv sync
Testing and Linting
# Run linting with ruff
ruff check .
# Run type checking with pyright
pyright
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
