← Back to Skills Marketplace
Google Sheet matan
by
Otman Heddouch
· GitHub ↗
· v1.0.1
· MIT-0
98
Downloads
0
Stars
0
Active Installs
2
Versions
Install in OpenClaw
/install google-sheet-matan
Description
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...
README (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)
Usage Guidance
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.
Capability Analysis
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.
Capability Tags
Capability Assessment
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.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install google-sheet-matan - After installation, invoke the skill by name or use
/google-sheet-matan - Provide required inputs per the skill's parameter spec and get structured output
Version History
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.
Metadata
Frequently Asked Questions
What is 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... It is an AI Agent Skill for Claude Code / OpenClaw, with 98 downloads so far.
How do I install Google Sheet matan?
Run "/install google-sheet-matan" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Google Sheet matan free?
Yes, Google Sheet matan is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Google Sheet matan support?
Google Sheet matan is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Google Sheet matan?
It is built and maintained by Otman Heddouch (@otman-ai); the current version is v1.0.1.
More Skills