功能描述

Read, write, and analyze Google Sheets with AI-powered insights, formula generation, and data summarization. Powered by evolink.ai

使用说明 (SKILL.md)

Google Sheets Assistant

Name: Google Sheets Assistant
Author: evolinkai

Read, write, and analyze Google Sheets with AI-powered data insights, formula generation, and summarization — all from your terminal.

Powered by Evolink.ai + Maton

When to Use

User says "read my spreadsheet", "get data from Google Sheets"
User wants to write data, update cells, or append rows
User says "create a spreadsheet" or "make a new sheet"
User wants formatting: "make the header bold", "resize columns"
User says "analyze this data", "find patterns"
User asks "what formula would...", "suggest a formula for..."
User says "summarize the spreadsheet"
User needs to connect their Google account

Quick Start

1. Get your Maton API key

Sign up at maton.ai, then copy your key from maton.ai/settings.

export MATON_API_KEY="your-maton-key"

2. Connect your Google account

bash scripts/sheets.sh connection create

Open the returned URL in your browser to authorize Google access.

3. Read a spreadsheet

bash scripts/sheets.sh read SPREADSHEET_ID "Sheet1!A1:D10"

4. (Optional) Enable AI features

Get a free EvoLink key at evolink.ai/signup:

export EVOLINK_API_KEY="your-evolink-key"

5. Try AI analysis

bash scripts/sheets.sh ai-analyze SPREADSHEET_ID

Capabilities

Core Operations

Read — Fetch and display spreadsheet values with aligned table output
Write — Update cell values in any range
Append — Add new rows to the end of a range
Info — Get spreadsheet metadata (title, sheets, dimensions)
Create — Create a new spreadsheet
Clear — Clear values from a range
Format — Apply formatting via Google Sheets batchUpdate API

Connection Management

List — View active Google OAuth connections
Create — Start OAuth flow to connect a Google account
Delete — Remove a connection

AI Features (Optional)

Requires EVOLINK_API_KEY. Get one free

ai-analyze — AI-powered data analysis with patterns, insights, and recommendations
ai-formula — Generate Google Sheets formulas from natural language descriptions
ai-summary — Summarize spreadsheet content with key figures and trends

Commands

Core Operations

Command	Description
`bash scripts/sheets.sh read \x3CID> [range]`	Read values (default: Sheet1)
`bash scripts/sheets.sh write \x3CID> \x3Crange> \x3Cjson>`	Write values to range
`bash scripts/sheets.sh append \x3CID> \x3Crange> \x3Cjson>`	Append rows
`bash scripts/sheets.sh info \x3CID>`	Get spreadsheet metadata
`bash scripts/sheets.sh create \x3Ctitle>`	Create new spreadsheet
`bash scripts/sheets.sh clear \x3CID> \x3Crange>`	Clear a range
`bash scripts/sheets.sh format \x3CID> \x3Cjson>`	Apply batchUpdate formatting

Connection Management

Command	Description
`bash scripts/sheets.sh connection list`	List Google connections
`bash scripts/sheets.sh connection create`	Connect Google account
`bash scripts/sheets.sh connection delete \x3Cid>`	Remove connection

AI Operations

Command	Description
`bash scripts/sheets.sh ai-analyze \x3CID> [range]`	Analyze data patterns
`bash scripts/sheets.sh ai-formula \x3Cdescription>`	Generate formula
`bash scripts/sheets.sh ai-summary \x3CID> [range]`	Summarize data

Examples

Read a range:

bash scripts/sheets.sh read 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms "Sheet1!A1:D10"

Write values:

bash scripts/sheets.sh write 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms "Sheet1!A1" '[["Name","Score"],["Alice",95],["Bob",87]]'

Create a new spreadsheet:

bash scripts/sheets.sh create "Q1 Sales Report"

Generate a formula:

bash scripts/sheets.sh ai-formula "sum all values in column B where column A equals Sales"

Configuration

Variable	Default	Required	Description
`MATON_API_KEY`	—	Yes	Maton API key for Google Sheets access. Get one
`EVOLINK_API_KEY`	—	Optional (AI)	EvoLink API key for AI features. Get one free
`EVOLINK_MODEL`	`claude-opus-4-6`	No	Model for AI processing. EvoLink API

Required binaries: python3, curl

Security

Important: Data Consent

All spreadsheet operations are proxied through gateway.maton.ai, which manages your Google OAuth tokens. By setting MATON_API_KEY and authorizing via the connection flow, you consent to Maton accessing your Google Sheets on your behalf.

AI commands (ai-analyze, ai-formula, ai-summary) transmit spreadsheet data to api.evolink.ai for processing by Claude. By setting EVOLINK_API_KEY and using these commands, you explicitly consent to this transmission. Data is not stored after the response is returned.

Core operations never transmit data to evolink.ai — only to the Maton gateway.

Network Access

gateway.maton.ai — Google Sheets API proxy (all operations)
ctrl.maton.ai — OAuth connection management
api.evolink.ai — AI features only (optional)

Persistence & Privilege

This skill creates temporary files for API request payloads which are cleaned up automatically. No credentials or persistent data are stored locally.

Links

安全使用建议

This skill appears to do what it claims (read/write Google Sheets and optional AI analysis), but take these precautions before installing: - Verify the source: check the referenced GitHub repo and the publisher (EvoLinkAI/owner) to ensure you trust them. The registry/version metadata shows small inconsistencies (version and which env vars are required). - Understand the privilege you're granting: MATON_API_KEY lets the Maton gateway access your Google Sheets on your behalf. Only grant a key you control and that you can revoke; confirm Maton's privacy/security practices if you care about sensitive data. - EVOLINK_API_KEY is only needed for AI features — don't set it unless you want those features. The registry listing incorrectly marks EVOLINK_API_KEY as required; treat EVOLINK as optional per the skill docs. - Inspect the included script (scripts/sheets.sh) yourself (it is included) to confirm endpoints and behavior match your expectations; run commands with least-privilege test data first (use a throwaway spreadsheet or account). - If you need stronger assurance, ask the publisher for a signed release or run the tool in an isolated environment (container) and monitor network traffic to confirm which endpoints receive your data.

能力标签

requires-oauth-token

能力评估

ℹ Purpose & Capability

The skill's name, description, and code (scripts/sheets.sh) align: it proxies Google Sheets operations via gateway.maton.ai (MATON_API_KEY) and optionally sends data to api.evolink.ai for AI features (EVOLINK_API_KEY). Binaries (python3, curl) are reasonable for the provided shell script. Small metadata mismatches exist (SKILL.md/_meta.json list EVOLINK as optional but registry metadata lists EVOLINK_API_KEY as required), which is inconsistent with the stated purpose but not directly malicious.

✓ Instruction Scope

SKILL.md runtime instructions and the script limit actions to: manage OAuth connections via ctrl.maton.ai, proxy Google Sheets API calls through gateway.maton.ai, and call Evolink for AI when EVOLINK_API_KEY is set. The instructions do not instruct reading unrelated files or exfiltrating data to unknown endpoints; the skill includes clear consent language about Maton and Evolink.

✓ Install Mechanism

No install spec (instruction-only with an included shell script). Nothing is downloaded from arbitrary URLs and no archive extraction is present. Risk from the install mechanism is low, but the script will run network calls at runtime.

⚠ Credentials

MATON_API_KEY is an appropriate primary credential because Maton proxies Google API access. However, registry metadata lists EVOLINK_API_KEY as required while SKILL.md and _meta.json treat it as optional for AI features—this inconsistency could cause surprising behavior in automated install checks or permission prompts. The skill requests a third-party API key (Maton) which grants Maton access to the user's Google Sheets; that is proportionate to the purpose but is a meaningful privilege the user must explicitly accept.

✓ Persistence & Privilege

The skill is not forced-always and does not request system-wide configuration or other skills' credentials. It can be invoked autonomously (platform default), which is expected for skills; no unusual persistence or elevated privileges are requested.

版本历史

v1.0.3

Clean publish: remove npm installer from package to resolve instruction-only audit flag

v1.0.2

Fix: use openclaw metadata format, add homepage, sync all versions to 1.0.2

v1.0.1

Fix: declare required env vars and binaries in SKILL.md frontmatter for registry metadata

v1.0.0

Initial release: Read, write, and analyze Google Sheets with AI-powered insights, formula generation, and data summarization

元数据

Slug google-sheets-assistant

版本 1.0.3

许可证 MIT-0

累计安装 0

当前安装数 0

历史版本数 4

常见问题