Google Sheets MCP Server

Google Sheets MCP Server

A Model Context Protocol (MCP) server for Google Sheets written in Go. Provides comprehensive tools for interacting with Google Spreadsheets.

Features

• Sheet Data: Get/update cell data, formulas, batch operations
• Sheet Management: Create, rename, copy sheets, add rows/columns
• Spreadsheet Management: Create, list, share spreadsheets
• Multiple Authentication Methods: Service account, OAuth2, ADC

Quick Start

1. Build:

   make build
   

2. Setup Google API Credentials (see SETUP.md for detailed instructions)

3. Configure Environment:

   # Service Account (recommended)
   export SERVICE_ACCOUNT_PATH="path/to/service-account.json"
   
   # OAuth2
   export CREDENTIALS_PATH="path/to/credentials.json"
   
   # Base64 encoded service account
   export CREDENTIALS_CONFIG="base64_encoded_service_account_json"
   

4. Run:

   # Stdio mode
   ./go_mcp_server_google_sheets
   
   # SSE mode
   ./go_mcp_server_google_sheets -t sse -p 8891
   

Environment Variables

• SERVICE_ACCOUNT_PATH - Path to service account JSON file
• CREDENTIALS_PATH - Path to OAuth2 credentials JSON file
• CREDENTIALS_CONFIG - Base64 encoded service account JSON
• TOKEN_PATH - OAuth2 token storage path (default: token.json)
• DRIVE_FOLDER_ID - Google Drive folder ID for new spreadsheets

Available Tools

Data Operations

• get_sheet_data - Get data from sheet
• get_sheet_formulas - Get formulas from sheet
• update_cells - Update cell values
• batch_update_cells - Batch update multiple ranges

Sheet Management

• list_sheets - List all sheets in spreadsheet
• create_sheet - Create new sheet
• rename_sheet - Rename existing sheet
• copy_sheet - Copy sheet between spreadsheets
• add_rows / add_columns - Add rows or columns

Spreadsheet Management

• create_spreadsheet - Create new spreadsheet
• list_spreadsheets - List spreadsheets in Drive
• share_spreadsheet - Share spreadsheet with users

Authentication Setup

Method 1: Service Account (Recommended)

1. Create Google Cloud Project:

   • Go to Google Cloud Console
   • Create a new project or select existing one

2. Enable APIs:

   • Go to "APIs & Services" > "Library"
   • Enable "Google Sheets API"
   • Enable "Google Drive API"

3. Create Service Account:

   • Go to "APIs & Services" > "Credentials"
   • Click "Create Credentials" > "Service Account"
   • Fill in service account details
   • Click "Create and Continue"

4. Generate Key:

   • Click on created service account
   • Go to "Keys" tab
   • Click "Add Key" > "Create new key"
   • Choose "JSON" format
   • Download the file (this is your service-account.json)

5. Set Environment Variable:

   export SERVICE_ACCOUNT_PATH="/path/to/your/service-account.json"
   

Method 2: OAuth2 (For User Access)

1. Create OAuth2 Credentials:

   • In Google Cloud Console, go to "APIs & Services" > "Credentials"
   • Click "Create Credentials" > "OAuth client ID"
   • Choose "Desktop application"
   • Download the JSON file (this is your credentials.json)

2. Set Environment Variable:

   export CREDENTIALS_PATH="/path/to/your/credentials.json"
   

Method 3: Base64 Encoded (For Containers/CI)

1. Encode Service Account:

   base64 -w 0 /path/to/service-account.json
   

2. Set Environment Variable:

   export CREDENTIALS_CONFIG="your_base64_encoded_string_here"
   

Sharing Spreadsheets with Service Account

When using Service Account, you need to share your spreadsheets with the service account email:

1. Open your Google Spreadsheet
2. Click "Share" button
3. Add the service account email (found in your JSON file as client_email)
4. Give appropriate permissions (Viewer/Editor)

License

MIT