No install? Use cloud.anythingmcp.com directly.
Sign in, install the Coda in one click, paste the credentials, mint an MCP API key — done. No Docker, no git clone, no local server to run.
TL;DR
Drive Coda (docs + tables + formulas) from any AI agent: docs, tables, rows, columns, formulas, packs, controls. 13 tools, Bearer token auth.
💡 无需安装? 直接使用 cloud.anythingmcp.com。 登录、点击 Connectors → Coda、粘贴凭证、生成 MCP API key — 完成。无 Docker、无
git clone、无本地服务器。
Coda + Gemini
Drive Coda (docs + tables + formulas) from any AI agent: docs, tables, rows, columns, formulas, packs, controls. 13 tools, Bearer token auth.
前提条件
完整的设置说明已内置在连接器中 (在 store 中选择连接器时可见)。所需环境变量:
CODA_API_TOKEN
步骤 1 — 获取凭证
io/developers/apis/v1).
Setup:
- Sign in to https://coda.io → top-right avatar → Account → API settings → Generate API token.
- Name the token. Copy it. Set
CODA_API_TOKEN.
Authentication: Authorization: Bearer ${CODA_API_TOKEN}.
Resource hierarchy: Doc → Section (Page) → Table → Row → Cell. Coda's twist: tables are first-class with structured columns and types; rows are addressable individually; columns can hold formulas.
Doc IDs look like dXXXXXXXXXX (10-char prefix d). Visible in the doc URL.
Table IDs look like grid-XXXXX. Discover via coda_list_tables(docId).
…(continued in the in-app connector instructions)
步骤 2 — 安装 adapter
git clone https://github.com/HelpCode-ai/anythingmcp.git
cd anythingmcp && docker compose up -d
步骤 3 — 在 Gemini 中添加连接器
Gemini CLI 从 ~/.gemini/settings.json (Windows: %APPDATA%\gemini\settings.json) 读取 MCP 服务器。添加:
{
"mcpServers": {
"anythingmcp": {
"httpUrl": "https://cloud.anythingmcp.com/mcp",
"headers": { "Authorization": "Bearer YOUR_MCP_API_KEY" }
}
}
}
- 从 AnythingMCP 获取你的 MCP API key。
- 保存文件并重启
gemini。 - 在 Gemini CLI 中运行
/mcp—Coda应显示为可用。 - Vertex AI Studio: 将
https://cloud.anythingmcp.com/mcp传入请求的tools数组,使用相同的 Bearer 头。
可用工具
| Tool | What it does |
|---|---|
coda_whoami | Return the user the token belongs to |
coda_list_docs | List docs the user can access |
coda_get_doc | Fetch a single doc by ID |
coda_list_tables | List tables in a doc |
coda_list_columns | List columns in a table |
coda_list_rows | List rows in a table or view |
coda_get_row | Fetch a single row by ID |
coda_insert_rows | Insert (or upsert with keyColumns) rows into a table |
coda_update_row | Update a specific row by ID |
coda_delete_row | Delete a single row by ID |
coda_delete_rows | Bulk-delete rows by IDs (more efficient than per-row) |
coda_get_formula_result | Evaluate a named formula on a doc |
coda_get_mutation_status | Check the status of an async mutation (insert/update/delete) by its requestId returned from those calls |
FAQ
Gemini 1.5 Pro 或 2.x 支持 MCP 吗? 支持 — Gemini CLI ≥ 0.4 与 Vertex AI tools API 均接受带 Bearer 头的 MCP httpUrl 连接器。
下一步
这份指南对您有帮助吗?