barie-google-sheets-mcp 0.1.0

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

Barie Google Sheets MCP Server

A Model Context Protocol (MCP) server for managing Google Sheets — list spreadsheets, create spreadsheets, read cell ranges, update values, and append rows.

Installation

# Using uvx (recommended)
uvx --from . barie-google-sheets-mcp

# Or install locally
pip install -e .

Usage

barie-google-sheets-mcp \
  --access-token "YOUR_ACCESS_TOKEN" \
  --refresh-token "YOUR_REFRESH_TOKEN" \
  --client-id "YOUR_CLIENT_ID" \
  --client-secret "YOUR_CLIENT_SECRET" \
  --expiry "2024-12-31T23:59:59Z" \
  --scopes '["https://www.googleapis.com/auth/spreadsheets","https://www.googleapis.com/auth/drive.file"]'

Required Arguments

• --access-token - Google OAuth2 access token
• --refresh-token - Google OAuth2 refresh token
• --client-id - Google OAuth2 client ID
• --client-secret - Google OAuth2 client secret

Optional Arguments

• --expiry - Token expiry timestamp (ISO format)
• --scopes - OAuth2 scopes as JSON array string

Tools

Tool	Description
list-spreadsheets	List Google Sheets files from Drive
get-spreadsheet	Get spreadsheet metadata (optionally ranges/gridData)
create-spreadsheet	Create a new spreadsheet
get-values	Read cell values (A1 range)
update-values	Write values to a range
append-values	Append rows to a range

Development

python server.py --help