← 返回 Skills 市场
Google Sheet matan
作者
Otman Heddouch
· GitHub ↗
· v1.0.1
· MIT-0
98
总下载
0
收藏
0
当前安装
2
版本数
在 OpenClaw 中安装
/install google-sheet-matan
功能描述
Interact with Google Sheets via the Maton API Gateway — read, write, append, and clear spreadsheet data using curl. Use this skill whenever the user mentions...
使用说明 (SKILL.md)
Google Sheets (Generic, via Maton Gateway)\r \r Access and manage any Google Sheets spreadsheet via Maton Gateway with full OAuth authentication. Supports reading, writing, updating, appending, clearing, formatting, sheet management, formulas, and protection.\r \r 🌐 Base URL\r https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/{native-api-path}\r \r {SPREADSHEET_ID} → Your spreadsheet ID\r {native-api-path} → Google Sheets API path (values, sheets, etc.)\r 🔐 Authentication\r \r Include your Maton API key in headers:\r \r -H "Authorization: Bearer $MATON_API_KEY"\r \r \r Set in environment:\r \r export MATON_API_KEY="YOUR_API_KEY"\r \r 📄 Operations (Generic Placeholders)\r
- Read Values\r curl "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/values/{SHEET_NAME}!{RANGE}" \r -H "Authorization: Bearer $MATON_API_KEY"\r \r \r Placeholders:\r \r {SHEET_NAME} → Name of any sheet/tab\r {RANGE} → A1 notation (A1:Z100)\r
- Append Values\r \r Add new rows to the bottom of a sheet.\r \r curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/values/{SHEET_NAME}!{RANGE}:append?valueInputOption=USER_ENTERED" \r -H "Authorization: Bearer $MATON_API_KEY" \r -H "Content-Type: application/json" \r -d '{\r "values": [\r ["{VALUE1}", "{VALUE2}", "{VALUE3}", "...", "{VALUEN}"]\r ]\r }'\r \r {VALUE1} ... {VALUEN} → Any generic values\r
- Update Values\r curl -X PUT "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/values/{SHEET_NAME}!{RANGE}?valueInputOption=USER_ENTERED" \r -H "Authorization: Bearer $MATON_API_KEY" \r -H "Content-Type: application/json" \r -d '{\r "values": [\r ["{VALUE1}", "{VALUE2}", "{VALUE3}", "...", "{VALUEN}"]\r ]\r }'\r \r
- Batch Update Values\r \r Update multiple ranges at once:\r \r curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/values:batchUpdate" \r -H "Authorization: Bearer $MATON_API_KEY" \r -H "Content-Type: application/json" \r -d '{\r "valueInputOption":"USER_ENTERED",\r "data":[\r {"range":"{SHEET_NAME}!{RANGE1}","values":[["{VALUE1A}", "{VALUE1B}", "..."]]},\r {"range":"{SHEET_NAME}!{RANGE2}","values":[["{VALUE2A}", "{VALUE2B}", "..."]]}\r ]\r }'\r \r
- Clear Values\r curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/values/{SHEET_NAME}!{RANGE}:clear" \r -H "Authorization: Bearer $MATON_API_KEY"\r \r
- Get Spreadsheet Metadata\r curl "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}" \r -H "Authorization: Bearer $MATON_API_KEY"\r \r Returns sheets, properties, titles, IDs\r
- Add a New Sheet\r curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}:batchUpdate" \r -H "Authorization: Bearer $MATON_API_KEY" \r -H "Content-Type: application/json" \r -d '{\r "requests":[\r {"addSheet":{"properties":{"title":"{NEW_SHEET_NAME}"}}}\r ]\r }'\r \r
- Delete a Sheet\r curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}:batchUpdate" \r -H "Authorization: Bearer $MATON_API_KEY" \r -H "Content-Type: application/json" \r -d '{\r "requests":[\r {"deleteSheet":{"sheetId":{SHEET_ID}}}\r ]\r }'\r \r
- Copy Sheet\r curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/sheets/{SHEET_ID}:copyTo" \r -H "Authorization: Bearer $MATON_API_KEY" \r -H "Content-Type: application/json" \r -d '{\r "destinationSpreadsheetId":"{DEST_SPREADSHEET_ID}"\r }'\r \r
- Formatting & Cell Styling\r curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}:batchUpdate" \r -H "Authorization: Bearer $MATON_API_KEY" \r -H "Content-Type: application/json" \r -d '{\r "requests":[\r {\r "repeatCell":{\r "range":{"sheetId":{SHEET_ID},"startRowIndex":{START_ROW},"endRowIndex":{END_ROW},"startColumnIndex":{START_COL},"endColumnIndex":{END_COL}},\r "cell":{"userEnteredFormat":{"backgroundColor":{"red":{R},"green":{G},"blue":{B}}}},\r "fields":"userEnteredFormat.backgroundColor"\r }\r }\r ]\r }'\r \r
- Insert Formulas\r curl -X PUT "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/values/{SHEET_NAME}!{CELL}?valueInputOption=USER_ENTERED" \r -H "Authorization: Bearer $MATON_API_KEY" \r -H "Content-Type: application/json" \r -d '{\r "values":[["{FORMULA}"]]\r }'\r \r
- Protected Ranges\r curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}:batchUpdate" \r -H "Authorization: Bearer $MATON_API_KEY" \r -H "Content-Type: application/json" \r -d '{\r "requests":[\r {"addProtectedRange":{"protectedRange":{"range":{"sheetId":{SHEET_ID},"startRowIndex":{START_ROW},"endRowIndex":{END_ROW}},"description":"{DESCRIPTION}"}}}\r ]\r }'\r \r 📚 Notes\r {SPREADSHEET_ID} → Your spreadsheet ID\r {SHEET_NAME} → Any sheet/tab name\r {RANGE} → A1 notation (e.g., A1:Z100)\r {VALUE1}, {VALUE2}, … → Generic placeholders for any cell content\r USER_ENTERED parses numbers, dates, formulas automatically\r batchUpdate is required for structural changes (add/delete sheets, formatting, protection)
安全使用建议
This skill's functionality (using Maton gateway to call Google Sheets APIs) is coherent, but the manifest failing to list MATON_API_KEY is a red flag — the instructions do require that secret even though the registry metadata does not. Before installing: (1) ask the publisher to update the skill metadata to declare MATON_API_KEY as a required/primary credential; (2) verify the trustworthiness and privacy policy of gateway.maton.ai (your spreadsheet contents and cell data will transit that third party); (3) limit the API key's permissions and scope, use a key that can be revoked/rotated, and avoid placing long-lived secrets in shared environments; (4) test with non-sensitive spreadsheets first. If you cannot confirm the gateway operator and metadata, treat the skill as untrusted.
功能分析
Type: OpenClaw Skill
Name: google-sheet-matan
Version: 1.0.1
The skill bundle provides instructions for an AI agent to interact with Google Sheets via a third-party gateway (maton.ai). The SKILL.md file contains standard API operations (read, write, update, format) using curl commands and generic placeholders, with no evidence of malicious intent, data exfiltration, or prompt injection.
能力标签
能力评估
Purpose & Capability
The skill's name/description and the SKILL.md consistently describe using the Maton API Gateway to operate on Google Sheets (read/write/append/format/etc.), which is appropriate for the stated purpose. However, the registry metadata declares no required environment variables or primary credential, while the runtime instructions explicitly require a MATON_API_KEY. That mismatch is an incoherence between claimed requirements and actual runtime needs.
Instruction Scope
The SKILL.md is instruction-only and confines actions to calling gateway.maton.ai Google Sheets endpoints via curl with an API key. It does not instruct reading arbitrary local files, other environment variables, or sending data to unrelated endpoints. It does instruct setting an environment variable (export MATON_API_KEY).
Install Mechanism
No install spec or code files are present (instruction-only), so nothing is written to disk or downloaded during install — lowest install risk.
Credentials
The only secret the instructions need is MATON_API_KEY, which is proportional for a gateway-based API. The concern is the skill metadata does not declare this required env var or a primary credential, so automated permission checks or the user reviewing required secrets may miss it. MATON_API_KEY is sensitive; the skill asks users to put it in the environment, which is normal but should be declared and minimized to least privilege.
Persistence & Privilege
The skill is not always-enabled and does not request system config paths or modify other skills. It runs as an invocation-only instruction set, so it does not request elevated persistence or privileges.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install google-sheet-matan - 安装完成后，直接呼叫该 Skill 的名称或使用
/google-sheet-matan触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.1
**Expanded skill: Now supports advanced Google Sheets management via Maton Gateway.**
- Rewrote documentation to a concise, generic format for all Sheets API operations.
- Added support examples for formatting, sheet creation/deletion, batch updates, cell styling, formulas, and protected ranges.
- Clarified placeholders and parameters for all request examples.
- Simplified authentication and setup instructions.
- Enhanced focus on OAuth security and full Sheets API compatibility.
v1.0.0
Initial release of the Google Sheets skill for Maton API Gateway.
- Enables reading, writing, appending, and clearing data in Google Sheets via the Maton API Gateway using curl.
- Automatically detects the user's intent (read, write, append, clear) from context.
- Guides users to verify API key and active connection before performing operations.
- Provides curl command templates for all supported operations.
- Includes helpful instructions for extracting spreadsheet IDs and formatting command parameters.
- Offers troubleshooting tips for common issues like missing API key or expired connections.
元数据
常见问题
Google Sheet matan 是什么？
Interact with Google Sheets via the Maton API Gateway — read, write, append, and clear spreadsheet data using curl. Use this skill whenever the user mentions... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 98 次。
如何安装 Google Sheet matan？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install google-sheet-matan」即可一键安装，无需额外配置。
Google Sheet matan 是免费的吗？
是的，Google Sheet matan 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
Google Sheet matan 支持哪些平台？
Google Sheet matan 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 Google Sheet matan？
由 Otman Heddouch（@otman-ai）开发并维护，当前版本 v1.0.1。
推荐 Skills