mcp-gsheets

A Model Context Protocol (MCP) server for Google Sheets API integration. Enables reading, writing, and managing Google Sheets documents directly from your MCP client.

Features

• Complete Google Sheets Integration - Read, write, and manage spreadsheets
• Advanced Operations - Batch operations, formatting, charts, and conditional formatting
• Flexible Authentication - Support for file-based and JSON string credentials
• 27 Comprehensive Tools - Full spreadsheet automation capabilities
• Production Ready - Built with TypeScript and comprehensive error handling

Quick Start

Add the following config to your MCP client:

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": ["-y", "mcp-gsheets@latest"],
      "env": {
        "GOOGLE_PROJECT_ID": "your-project-id",
        "GOOGLE_APPLICATION_CREDENTIALS": "/path/to/service-account-key.json"
      }
    }
  }
}

Available Tools

Reading Data

• sheets_get_values - Read from a range
• sheets_batch_get_values - Read from multiple ranges
• sheets_get_metadata - Get spreadsheet info
• sheets_check_access - Check access permissions

Writing Data

• sheets_update_values - Write to a range
• sheets_batch_update_values - Write to multiple ranges
• sheets_append_values - Append rows to a table
• sheets_clear_values - Clear cell contents
• sheets_insert_rows - Insert new rows

Sheet Management

• sheets_insert_sheet - Add new sheet
• sheets_delete_sheet - Remove sheet
• sheets_duplicate_sheet - Copy sheet
• sheets_copy_to - Copy to another spreadsheet
• sheets_update_sheet_properties - Update sheet settings
• sheets_create_spreadsheet - Create new spreadsheet

Batch Operations

• sheets_batch_delete_sheets - Delete multiple sheets
• sheets_batch_format_cells - Format multiple ranges

Cell Formatting

• sheets_format_cells - Format cells (colors, fonts, alignment)
• sheets_update_borders - Add or modify cell borders
• sheets_merge_cells - Merge cells together
• sheets_unmerge_cells - Unmerge cells
• sheets_add_conditional_formatting - Add conditional formatting

Charts

• sheets_create_chart - Create charts
• sheets_update_chart - Modify charts
• sheets_delete_chart - Remove charts

Utility

• sheets_insert_link - Insert hyperlinks
• sheets_insert_date - Insert date values

Links

• GitHub Repository
• npm Package
• Google Sheets API