mcp-google-sheets

Overview

This MCP server provides a robust bridge between AI assistants and Google Sheets, enabling creation and modification of spreadsheets through a comprehensive set of 19 tools. It supports both Service Accounts and OAuth 2.0 authentication, with detailed setup instructions in the README. The server is actively maintained with recent commits and includes thoughtful features like tool filtering to reduce context usage. All tools are well-documented with clear parameter descriptions and return values.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• list_spreadsheets

  Lists spreadsheets in the configured Drive folder

  Try:Show me all my spreadsheetsTry:List all spreadsheets in my Drive folder
• create_spreadsheet

  Creates a new spreadsheet with the specified title

  Try:Create a new spreadsheet titled 'Q4 Report'Try:Make a new spreadsheet called 'Budget 2023'
• get_sheet_data

  Reads data from a range in a sheet/tab

  Try:Get data from Sheet1 A1:C10Try:Show me all data in 'Sales Data' sheet
• update_cells

  Writes data to a specific range in a sheet

  Try:Update A1:C3 with these valuesTry:Put 'Hello World' in cell B2
• add_rows

  Adds empty rows to a sheet at a specified index

  Try:Add 5 empty rows to Sheet1Try:Insert 3 new rows at the beginning
• list_sheets

  Lists all sheet/tab names within a spreadsheet

  Try:Show all sheets in this spreadsheetTry:What tabs are in this workbook?
• create_sheet

  Adds a new sheet/tab to a spreadsheet

  Try:Create a new sheet called 'Summary'Try:Add a tab labeled 'Data Analysis'
• find_in_spreadsheet

  Search for values in a spreadsheet

  Try:Find all cells with 'Total'Try:Search for 'Q4' in the spreadsheet
• copy_sheet

  Copies an existing sheet within or between spreadsheets

  Try:Copy 'Sheet1' to 'Sheet1 Backup'Try:Duplicate this sheet in another spreadsheet
• share_spreadsheet

  Shares a spreadsheet with specified users and roles

  Try:Share this spreadsheet with john@example.com as editorTry:Give read access to team members
• batch_update_cells

  Updates multiple ranges in one API call

  Try:Update A1:B2 and D5:E10 in one operationTry:Batch update these cell ranges
• get_multiple_sheet_data

  Fetches data from multiple ranges across different spreadsheets

  Try:Get data from Spreadsheet1 A1:B2 and Spreadsheet2 C5:D10Try:Fetch multiple ranges from different sheets

Comparable tools

Installation

# Install uv
curl -LsSf https://astral.sh/uv/install.sh | sh

# Set environment variables
export SERVICE_ACCOUNT_PATH="/path/to/your/service-account-key.json"
export DRIVE_FOLDER_ID="YOUR_DRIVE_FOLDER_ID"

# Run the server
uvx mcp-google-sheets@latest

{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": ["mcp-google-sheets@latest"],
      "env": {
        "SERVICE_ACCOUNT_PATH": "/path/to/credentials.json"
      }
    }
  }
}

{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": ["mcp-google-sheets@latest", "--include-tools", "get_sheet_data,update_cells,list_spreadsheets"],
      "env": {
        "SERVICE_ACCOUNT_PATH": "/path/to/credentials.json"
      }
    }
  }
}

FAQ

How do I authenticate with Google Sheets?

The server supports three authentication methods: Service Accounts (recommended), OAuth 2.0, and direct credential injection via environment variables. Detailed setup instructions are provided in the README.

How can I reduce context window usage?

Use tool filtering with either the --include-tools command-line argument or ENABLED_TOOLS environment variable to enable only the tools you need, reducing from ~13,000 tokens to just the required tools.

Compare mcp-google-sheets with