mcp-google-sheets

概述

这个 MCP 服务器在 AI 助手和 Google Sheets 之间建立了可靠的桥梁，提供 19 种全面的工具用于创建和修改电子表格。它支持服务账户和 OAuth 2.0 认证方式，README 中包含详细的设置说明。服务器由积极维护，最近有提交，并包含诸如工具过滤等 thoughtful 功能以减少上下文使用。所有工具都有清晰文档，包含参数说明和返回值。

试试问 AI

装完之后，这里有 5 个你可以让 AI 做的事：

• list_spreadsheets

  Lists spreadsheets in the configured Drive folder

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

  Creates a new spreadsheet with the specified title

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

  Reads data from a range in a sheet/tab

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

  Writes data to a specific range in a sheet

  试试:Update A1:C3 with these values试试:Put 'Hello World' in cell B2
• add_rows

  Adds empty rows to a sheet at a specified index

  试试:Add 5 empty rows to Sheet1试试:Insert 3 new rows at the beginning
• list_sheets

  Lists all sheet/tab names within a spreadsheet

  试试:Show all sheets in this spreadsheet试试:What tabs are in this workbook?
• create_sheet

  Adds a new sheet/tab to a spreadsheet

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

  Search for values in a spreadsheet

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

  Copies an existing sheet within or between spreadsheets

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

  Shares a spreadsheet with specified users and roles

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

  Updates multiple ranges in one API call

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

  Fetches data from multiple ranges across different spreadsheets

  试试:Get data from Spreadsheet1 A1:B2 and Spreadsheet2 C5:D10试试:Fetch multiple ranges from different sheets

可对比工具

安装

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

# 设置环境变量
export SERVICE_ACCOUNT_PATH="/path/to/your/service-account-key.json"
export DRIVE_FOLDER_ID="YOUR_DRIVE_FOLDER_ID"

# 运行服务器
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

如何与 Google Sheets 进行身份验证？

该服务器支持三种认证方式：服务账户（推荐）、OAuth 2.0 以及通过环境变量直接注入凭据。README 中提供了详细的设置说明。

如何减少上下文窗口使用量？

使用 --include-tools 命令行参数或 ENABLED_TOOLS 环境变量进行工具过滤，只启用您需要的工具，从而将使用量从 ~13,000 个标记减少到仅必要的工具。

mcp-google-sheets 对比