A powerful interface for AI agents to interact with Google Sheets via the Maton Gateway with full OAuth support.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install google-sheet-matan
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install google-sheet-matan using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Google Sheets Maton Gateway?
The Google Sheets Maton Gateway skill allows AI agents to interact directly with the Google Sheets API v4. By leveraging the Maton Gateway as a proxy, this skill for Openclaw Skills simplifies the authentication process while providing comprehensive access to spreadsheet data. It enables agents to read, write, and manipulate structured data in the cloud without the need for complex local library configurations or managing individual OAuth tokens. This bridge is essential for developers building agents that require persistent, collaborative data storage and real-time reporting capabilities.
Google Sheets Maton Gateway Use Cases
- Automated data entry and row appending from AI-driven web research or user interactions.
- Generating dynamic business reports by reading existing spreadsheet data and synthesizing insights.
- Programmatic formatting of cells and application of conditional styling based on data analysis.
- Managing spreadsheet architecture by adding, deleting, or copying sheets for organizational workflows.
- Inserting complex formulas to automate calculations and data processing within the Google ecosystem.
How Google Sheets Maton Gateway Works
- The AI agent identifies the target spreadsheet by its unique SPREADSHEET_ID and the specific range in A1 notation.
- The skill constructs a RESTful API request directed to the Maton Gateway endpoint.
- The Maton Gateway authenticates the request using the provided Bearer token and proxies it to the Google Sheets v4 API.
- The spreadsheet performs the requested operation, such as appending rows or updating cell values with USER_ENTERED parsing.
- The agent receives a JSON response confirming the update or providing the requested cell data to continue its workflow within Openclaw Skills.
Google Sheets Maton Gateway Setup
To get started with this skill, you must set your Maton API key as an environment variable and identify the ID of the spreadsheet you wish to manipulate.
# Set your Maton API Key
export MATON_API_KEY="YOUR_API_KEY"
# Example: Read a specific range from a sheet
curl "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/values/{SHEET_NAME}!{RANGE}" \
-H "Authorization: Bearer $MATON_API_KEY"
Google Sheets Maton Gateway Data Schema & Taxonomy
The skill interacts with Google Sheets using the following data parameters to ensure precision in data placement and retrieval:
| Parameter | Description | Typical Value |
|---|---|---|
| SPREADSHEET_ID | The unique identifier found in the spreadsheet URL. | 1abc12345... |
| SHEET_NAME | The name of the specific tab within the spreadsheet. | Sheet1 |
| RANGE | The A1 notation defining the cells to be targeted. | A1:D10 |
| VALUE_INPUT_OPTION | Determines how input data should be interpreted. | USER_ENTERED |
| batchUpdate | A request structure used for making multiple structural or formatting changes. | JSON Object |
Google Sheets Maton Gateway Advanced Features
- Batch update capabilities for high-performance operations across multiple cell ranges in a single call.
- Fine-grained cell styling support, allowing agents to change background colors, fonts, and borders.
- Automated formula insertion to create live, self-calculating spreadsheets through Openclaw Skills.
- Sheet management tools to programmatically copy, create, or delete tabs within a workbook.
- Range protection features to secure sensitive data columns from accidental manual edits.
SKILL.md
Loading
Related Openclaw Skills
Umnix AgentMemory Skill
A conceptual framework providing AI agents with persistent, structured memory across episodic, semantic, procedural, and relational types.
AI Hallucination Correction (CN)
A specialized intent alias for VeriClaw designed to detect, diagnose, and fix AI hallucinations and false task completions through evidence-based correction loops.
Umnix Jury System
A conceptual framework skill for transparent, multi-perspective AI dispute resolution featuring a 12-juror parallel AI panel and human oversight.
Umnix Constitution Engine Skill
A foundational governance framework defining mandates, permissions, and performance standards for autonomous AI agents.
Fal.Ai Media Generation
A powerful integration for generating professional-grade AI media including high-resolution images, cinematic videos, and accurate audio transcripts.
Social Media Management Roadmap
A professional career development API that generates personalized learning pathways and skill roadmaps for social media management professionals.
Featured*
