Agent Skills › openclaw/gogcli › gog-sheets

gog-sheets

GitHub

提供Google Sheets自动化操作能力，涵盖数据读写、格式管理、图表及结构变更。强调安全认证、只读模式与原子事务，适用于表格数据处理与集成场景。

.agents/skills/gog-sheets/SKILL.md openclaw/gogcli

Trigger Scenarios

需要读取或写入Google Sheets数据执行Google Sheets格式化或结构修改

Install

npx skills add openclaw/gogcli --skill gog-sheets -g -y

More Options

Non-standard path

npx skills add https://github.com/openclaw/gogcli/tree/main/.agents/skills/gog-sheets -g -y

Use without installing

npx skills use openclaw/gogcli@gog-sheets

指定 Agent (Claude Code)

npx skills add openclaw/gogcli --skill gog-sheets -a claude-code -g -y

安装 repo 全部 skill

npx skills add openclaw/gogcli --all -g -y

预览 repo 内 skill

npx skills add openclaw/gogcli --list

SKILL.md

Frontmatter

{
    "name": "gog-sheets",
    "description": "Google Sheets operations through gog."
}

Google Sheets

Use gog for Google Sheets operations. Read ../gog/SKILL.md first for shared auth, output, safety, and live-write rules.

Safe start

gog auth list --check --json --no-input
gog schema sheets --json
gog --readonly --account user@example.com sheets get SHEET_ID 'Sheet1!A1:D20' --json --wrap-untrusted

Select the account explicitly with --account.
Use --json --wrap-untrusted for agent-readable Google content.
Use --readonly when the task must not mutate Google data.
Use --no-input in automation and --dry-run before supported writes.
Confirm the exact account, object, and mutation before any write or delete.

Commands

Command	Purpose
`add-tab`	Add a new tab/sheet to a spreadsheet
`append`	Append values to a range
`banding`	Manage alternating color banding
`batch-request`	Submit an atomic structural request array (requires confirmation or --force)
`batch-update`	Update values in multiple ranges with one API request
`chart`	Manage spreadsheet charts
`clear`	Clear values in a range
`conditional-format`	Manage conditional formatting rules
`copy`	Copy a Google Sheet
`copy-paste`	Copy a range's values/formulas/format to another range (tiles to fill down/across)
`create`	Create a new spreadsheet
`datasource`	Manage Connected Sheets data sources and extracts
`delete-dimension`	Delete rows or columns while preserving intersecting tables
`delete-tab`	Delete a tab/sheet from a spreadsheet (use --force to skip confirmation)
`duplicate-tab`	Duplicate a tab within a spreadsheet
`export`	Export a Google Sheet (pdf\|xlsx\|csv) via Drive
`filter`	Manage basic filters
`find-replace`	Find and replace text across a spreadsheet
`format`	Apply cell formatting to a range
`freeze`	Freeze rows and columns on a sheet
`get`	Get values from a range
`insert`	Insert empty rows or columns into a sheet
`links`	Get or set cell hyperlinks
`merge`	Merge cells in a range
`metadata`	Get spreadsheet metadata
`named-ranges`	Manage named ranges
`notes`	Get cell notes from a range
`number-format`	Apply number format to a range
`raw`	Dump raw Google Sheets API response as JSON (Spreadsheets.Get; lossless; for scripting and LLM consumption)
`read-format`	Read cell formatting from a range
`rename-tab`	Rename a tab/sheet in a spreadsheet
`reorder-tab`	Move a tab/sheet to a specific 0-based position in the spreadsheet
`resize-columns`	Resize sheet columns
`resize-rows`	Resize sheet rows
`table`	Manage Google Sheets tables
`unmerge`	Unmerge cells in a range
`update`	Update values in a range
`update-note`	Set or clear a cell note
`validation`	Manage cell data validation rules

Run gog sheets <command> --help for flags and gog schema sheets <command> --json for the machine-readable contract. Do not guess command syntax.

Version History

3a4bbf2 Current 2026-09-28 14:00
新增batch-request命令，支持原子性结构化请求，修复#1108并增强受限策略下的安全性。
5c918b6 2026-09-23 03:31
新增 duplicate-tab 命令，支持在电子表格内复制标签页并指定目标名称和索引。
be4037f 2026-08-29 00:13
新增刷新单个Connected Sheets数据源的功能。
eb85a99 2026-08-20 12:40