Metadata-Version: 2.4
Name: spreadsheet-mcp
Version: 0.1.0
Summary: Google Spreadsheetを操作するためのMCPサーバー
Requires-Python: >=3.11
Requires-Dist: gspread>=6.2.0
Requires-Dist: mcp[cli]>=1.6.0
Requires-Dist: polars>=1.26.0
Description-Content-Type: text/markdown

# 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

```json
{
  "mcpServers": {
    "spreadsheet": {
      "command": "uvx",
      "args": [
        "--from",
        "git+https://github.com/yamitzky/spreadsheet-mcp.git",
        "spreadsheet-mcp"
      ]
    }
  }
}
```

## Development

### Setting up the development environment

```bash
# Clone the repository
git clone https://github.com/yamitzky/spreadsheet-mcp.git
cd spreadsheet-mcp

# Install development dependencies
uv sync
```

### Testing and Linting

```bash
# Run linting with ruff
ruff check .

# Run type checking with pyright
pyright
```
