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/*