A
licenseNot graded
qualityD
maintenanceA Model Context Protocol server that integrates with Google Drive and Google Sheets, enabling users to create, read, update, and manage spreadsheets through natural language commands.
24,952 PyPI
1,011
MIT
Google Sheets MCP
by mkummer225
Google 表格 MCP
Google Sheets 的模型上下文协议 (MCP) 连接器允许 AI 代理直接与电子表格交互。
演示
https://github.com/user-attachments/assets/cc4729d9-4e6e-437b-848b-6da9a09418c3
Related MCP server: Google Sheets MCP
设置
克隆此存储库：
git clone https://github.com/mkummer225/google-sheets-mcp
cd google-sheets-mcp安装依赖项：
npm install构建：
npm run build在 Google Cloud Platform 中创建 OAuth 凭据：
在Google Cloud Console中创建新项目
配置 OAuth 同意屏幕
使用适当的重定向 URI 创建 OAuth 客户端 ID 凭据（桌面应用程序）（例如： http://localhost:3000/oauth2callback ）
下载凭证并将其保存为
dist子目录中的gcp-oauth.keys.json
启动 MCP 服务器（必要时会自动提示您验证/重新验证您的 Google 帐户）：
npm run start
用法
示例配置：
{
"mcpServers": {
"google-sheets-mcp": {
"command": "node",
"args": [
"/{path_to_dir}/google-sheets-mcp/dist/index.js"
]
}
}
}然后您应该能够简单地指定您的电子表格 ID 或让您的代理为您创建一个新的电子表格 ID。
可用操作
行动 | 描述 |
| 凭据过期时重新验证您的 Google 帐户 |
| 列出 Google 电子表格中的所有工作表/标签 |
| 在 Google 电子表格中创建新的工作表/标签 |
| 创建新的 Google 电子表格 |
| 读取指定工作表中的所有数据 |
| 读取工作表中的列标题 |
| 从工作表中读取特定行 |
| 读取工作表中的特定列 |
| 编辑工作表中的单个单元格 |
| 编辑工作表中的整行 |
| 编辑工作表中的整列 |
| 在指定位置插入新行 |
| 在指定位置插入新列 |
| 重命名电子表格中的工作表/标签 |
| 重命名 Google 电子表格 |
执照
麻省理工学院
This server cannot be deployed
Maintenance
ActivityInactive
ResponsivenessNo issues
Related MCP Connectors
Connect AI assistants to Google Sheets through controlled tools for reading and updating rows.
The BigQuery remote MCP server is a fully managed service that uses the Model Context Protocol to connect AI applications and LLMs to BigQuery data sources. It provides secure, standardized tools for AI agents to list datasets and tables, retrieve schemas, generate and execute SQL queries through natural language, and analyze data—enabling direct access to enterprise analytics data without requiring manual SQL coding.
Let AI agents query data and act across all your business apps via MCP.
An agent-first office suite Claude & ChatGPT read and write over one MCP URL.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables AI agents to interact directly with Google Sheets to create, read, and edit spreadsheets through the Model Context Protocol. It supports a wide range of actions including cell manipulation, row and column management, and sheet organization.578 npmMIT
- FlicenseNot gradedqualityDmaintenanceEnables AI assistants to read, write, and format Google Spreadsheets through the Model Context Protocol. It supports comprehensive operations including data retrieval, sheet creation, and cell formatting using natural language commands.-
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants to read, write, and manage Google Sheets spreadsheets through natural language commands, providing a bridge between MCP clients and the Google Sheets API.424 npm1MIT