全部技能 分类浏览
← 返回
未分类 Key 中文

Google Sheets Assistant

Read, write, and analyze Google Sheets with AI-powered insights, formula generation, and data summarization. Powered by evolink.ai
读取、写入并分析 Google 表格，AI 驱动洞察、公式生成与数据摘要。由 evolink.ai提供支持。
evolinkai evolinkai 来源
未分类 clawhub v1.0.3 1 版本 100000 Key: 需要
★ 0
Stars
📥 390
下载
💾 0
安装
1
版本
#latest

概述

Google Sheets Assistant

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

CommandDescription
----------------------
bash scripts/sheets.sh read [range]Read values (default: Sheet1)
bash scripts/sheets.sh write Write values to range
bash scripts/sheets.sh append Append rows
bash scripts/sheets.sh info Get spreadsheet metadata
bash scripts/sheets.sh create </code></td><td>Create new spreadsheet</td></tr><tr><td><code>bash scripts/sheets.sh clear <ID> <range></code></td><td>Clear a range</td></tr><tr><td><code>bash scripts/sheets.sh format <ID> <json></code></td><td>Apply batchUpdate formatting</td></tr></tbody></table><h3>Connection Management</h3><table><thead><tr><th>Command</th><th>Description</th></tr></thead><tbody><tr><td>---------</td><td>-------------</td></tr><tr><td><code>bash scripts/sheets.sh connection list</code></td><td>List Google connections</td></tr><tr><td><code>bash scripts/sheets.sh connection create</code></td><td>Connect Google account</td></tr><tr><td><code>bash scripts/sheets.sh connection delete <id></code></td><td>Remove connection</td></tr></tbody></table><h3>AI Operations</h3><table><thead><tr><th>Command</th><th>Description</th></tr></thead><tbody><tr><td>---------</td><td>-------------</td></tr><tr><td><code>bash scripts/sheets.sh ai-analyze <ID> [range]</code></td><td>Analyze data patterns</td></tr><tr><td><code>bash scripts/sheets.sh ai-formula <description></code></td><td>Generate formula</td></tr><tr><td><code>bash scripts/sheets.sh ai-summary <ID> [range]</code></td><td>Summarize data</td></tr></tbody></table><h2>Examples</h2><p>Read a range:</p><p> bash scripts/sheets.sh read 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms "Sheet1!A1:D10"</p><p>Write values:</p><p> bash scripts/sheets.sh write 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms "Sheet1!A1" '[["Name","Score"],["Alice",95],["Bob",87]]'</p><p>Create a new spreadsheet:</p><p> bash scripts/sheets.sh create "Q1 Sales Report"</p><p>Generate a formula:</p><p> bash scripts/sheets.sh ai-formula "sum all values in column B where column A equals Sales"</p><h2>Configuration</h2><table><thead><tr><th>Variable</th><th>Default</th><th>Required</th><th>Description</th></tr></thead><tbody><tr><td>---</td><td>---</td><td>---</td><td>---</td></tr><tr><td><code>MATON_API_KEY</code></td><td>—</td><td>Yes</td><td>Maton API key for Google Sheets access. <a href="https://maton.ai/settings" target="_blank" rel="noopener">Get one</a></td></tr><tr><td><code>EVOLINK_API_KEY</code></td><td>—</td><td>Optional (AI)</td><td>EvoLink API key for AI features. <a href="https://evolink.ai/signup?utm_source=clawhub&utm_medium=skill&utm_campaign=google-sheets" target="_blank" rel="noopener">Get one free</a></td></tr><tr><td><code>EVOLINK_MODEL</code></td><td><code>claude-opus-4-6</code></td><td>No</td><td>Model for AI processing. <a href="https://docs.evolink.ai/en/api-manual/language-series/claude/claude-messages-api?utm_source=clawhub&utm_medium=skill&utm_campaign=google-sheets" target="_blank" rel="noopener">EvoLink API</a></td></tr></tbody></table><p>Required binaries: <code>python3</code>, <code>curl</code></p><h2>Security</h2><p><strong>Important: Data Consent</strong></p><p>All spreadsheet operations are proxied through <code>gateway.maton.ai</code>, which manages your Google OAuth tokens. By setting <code>MATON_API_KEY</code> and authorizing via the connection flow, you consent to Maton accessing your Google Sheets on your behalf.</p><p>AI commands (<code>ai-analyze</code>, <code>ai-formula</code>, <code>ai-summary</code>) transmit spreadsheet data to <code>api.evolink.ai</code> for processing by Claude. By setting <code>EVOLINK_API_KEY</code> and using these commands, you explicitly consent to this transmission. Data is not stored after the response is returned.</p><p>Core operations never transmit data to evolink.ai — only to the Maton gateway.</p><p><strong>Network Access</strong></p><ul><li><code>gateway.maton.ai</code> — Google Sheets API proxy (all operations)</li><li><code>ctrl.maton.ai</code> — OAuth connection management</li><li><code>api.evolink.ai</code> — AI features only (optional)</li></ul><p><strong>Persistence & Privilege</strong></p><p>This skill creates temporary files for API request payloads which are cleaned up automatically. No credentials or persistent data are stored locally.</p><h2>Links</h2><ul><li><a href="https://github.com/EvoLinkAI/google-sheets-skill-for-openclaw" target="_blank" rel="noopener">GitHub</a></li><li><a href="https://docs.evolink.ai/en/api-manual/language-series/claude/claude-messages-api?utm_source=clawhub&utm_medium=skill&utm_campaign=google-sheets" target="_blank" rel="noopener">EvoLink API</a></li><li><a href="https://maton.ai" target="_blank" rel="noopener">Maton</a></li><li><a href="https://discord.com/invite/5mGHfA24kn" target="_blank" rel="noopener">Community</a></li><li><a href="mailto:support@evolink.ai" target="_blank" rel="noopener">Support</a></li></ul></div> </div> </div> <div id="tab-versions" class="detail-content"> <div class="detail-section"> <h2>版本历史</h2> <p style="margin-bottom:12px;font-size:14px;color:#94a3b8;">共 1 个版本</p> <ul class="version-list"> <li> <div> <span class="version-tag">v1.0.3</span> <span style="font-size:11px;color:#5b6abf;margin-left:8px;background:#eef0ff;padding:1px 8px;border-radius:10px;">当前</span> </div> <div style="font-size:12px;color:#94a3b8;"> 2026-05-07 11:33 安全 安全 </div> </li> </ul> </div> </div> <div id="tab-security" class="detail-content"> <div class="detail-section"> <h2>安全检测</h2> <div class="sec-grid"> <div class="sec-card"> <h4>腾讯云安全 (Keen)</h4> <div class="sec-status sec-safe"> 安全，无风险 </div> <a href="https://tix.qq.com/search/skill?keyword=153154c49899a7379176e15ccfe65a47" target="_blank">查看报告</a> </div> <div class="sec-card"> <h4>腾讯云安全 (Sanbu)</h4> <div class="sec-status sec-safe"> 安全，无风险 </div> <a href="https://static.cloudsec.tencent.com/html-report-v2/2026/05/26/442069_8f3393db5b78938eae4369ff097c323c.html?q-sign-algorithm=sha1&q-ak=AKID8JMG1bzBC1dz96qNhssfFftujT1NCoFi&q-sign-time=1782659599%3B1814195599&q-key-time=1782659599%3B1814195599&q-header-list=host&q-url-param-list=&q-signature=484e77d1e73009a02a340db6fe6cd44a21db192a" target="_blank">查看报告</a> </div> </div> </div> </div> <!-- Recommended Skills --> <div style="margin-top:24px;"> <h2 style="font-size:18px;font-weight:600;margin-bottom:16px;">🔗 相关推荐</h2> <div class="rec-grid"> <div class="rec-card"> <span class="badge-cat" style="margin-bottom:8px;display:inline-block;">design-media</span> <h3><a href="/s/best-image-generation">Best Image Generation</a></h3> <div class="rec-owner">evolinkai</div> <div class="rec-desc">最佳质量AI图像生成(约$0.12-0.20/张)，支持文生图、图生图及图像编辑，通过EvoLink API实现。</div> <div class="rec-stats"> <span style="color:#f39c12;">★ 8</span> <span style="color:#5b6abf;">📥 12,056</span> </div> </div> <div class="rec-card"> <span class="badge-cat" style="margin-bottom:8px;display:inline-block;">office-efficiency</span> <h3><a href="/s/excel-xlsx">Excel / XLSX</a></h3> <div class="rec-owner">ivangdavila</div> <div class="rec-desc">创建、检查和编辑 Microsoft Excel 工作簿及 XLSX 文件，支持可靠的公式、日期、类型、格式、重算及模板保留功能。</div> <div class="rec-stats"> <span style="color:#f39c12;">★ 388</span> <span style="color:#5b6abf;">📥 147,828</span> </div> </div> <div class="rec-card"> <span class="badge-cat" style="margin-bottom:8px;display:inline-block;">office-efficiency</span> <h3><a href="/s/gog">Gog</a></h3> <div class="rec-owner">steipete</div> <div class="rec-desc">Google Workspace 命令行工具，支持 Gmail、日历、云端硬盘、通讯录、表格和文档。</div> <div class="rec-stats"> <span style="color:#f39c12;">★ 932</span> <span style="color:#5b6abf;">📥 187,393</span> </div> </div> </div> </div> </div> <script> document.addEventListener('DOMContentLoaded',function(){ document.querySelectorAll('.detail-tab').forEach(function(btn){ btn.addEventListener('click',function(e){ var tab = this.getAttribute('data-tab'); document.querySelectorAll('.detail-tab').forEach(function(b){b.classList.remove('active')}); document.querySelectorAll('.detail-content').forEach(function(c){c.classList.remove('active')}); this.classList.add('active'); var el = document.getElementById('tab-'+tab); if(el) el.classList.add('active'); }); }); }); </script> <div class="footer"> <p>Skill工具集 © 2026</p> </div></body> </html>