barie-google-sheets-mcp 0.1.1

Google Sheets MCP Server for managing spreadsheets via the Model Context Protocol

Barie Google Sheets MCP Server

Model Context Protocol (MCP) server for Google Sheets and Google Drive discovery.

It supports listing spreadsheet-like files from Drive, and full read/write operations on native Google Sheets.

Install

uvx barie-google-sheets-mcp --help

Run

barie-google-sheets-mcp \
  --access-token "YOUR_ACCESS_TOKEN" \
  --refresh-token "YOUR_REFRESH_TOKEN" \
  --client-id "YOUR_CLIENT_ID" \
  --client-secret "YOUR_CLIENT_SECRET"

Optional:

• --expiry: token expiry timestamp in ISO format
• --scopes: JSON array string, for example: ["https://www.googleapis.com/auth/drive","https://www.googleapis.com/auth/spreadsheets"]

MCP Client Config Example

{
  "mcpServers": {
    "google_sheets": {
      "command": "uvx",
      "args": [
        "barie-google-sheets-mcp",
        "--access-token",
        "YOUR_ACCESS_TOKEN",
        "--refresh-token",
        "YOUR_REFRESH_TOKEN",
        "--client-id",
        "YOUR_CLIENT_ID",
        "--client-secret",
        "YOUR_CLIENT_SECRET"
      ]
    }
  }
}

If you need to force-refresh package resolution in long-lived environments, you can add --refresh and --reinstall before barie-google-sheets-mcp.

Tool Names

The server exposes these MCP tools:

• list_spreadsheets
• get_spreadsheet
• create_spreadsheet
• get_sheet_data
• update_cells
• append_values
• add_columns
• add_rows
• batch_update
• batch_update_cells
• copy_sheet
• create_sheet
• find_in_spreadsheet
• get_multiple_sheet_data
• get_multiple_spreadsheet_summary
• get_sheet_formulas
• list_folders
• list_sheets
• rename_sheet
• search_spreadsheets
• share_spreadsheet

File Format Behavior

• list_spreadsheets can return Google Sheets and some spreadsheet-like Drive files.
• Read/write tools (get_sheet_data, update_cells, append_values, etc.) work only with native Google Sheets (application/vnd.google-apps.spreadsheet).
• For .xlsx, .xls, or .csv, convert to Google Sheets first, then use the converted file ID.

If a non-native spreadsheet is passed to a Sheets-only tool, the server returns a clear conversion-required error.

Publish

cd google_sheets
python -m build
python -m twine check dist/*
python -m twine upload dist/*