Work with Google Sheets through the gog command-line tool. Read and update cells, organize tabs, manage formatting, charts, and input rules, and export spreadsheets as PDF, Excel, or CSV files.
中文简介正在准备中。当前显示英语简介。
Google Sheets operations through gog.
安装前可以查看交给 AI 代理的指令内容。
Use gog for Google Sheets operations. Read ../gog/SKILL.md first for shared auth,
output, safety, and live-write rules.
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
--account.--json --wrap-untrusted for agent-readable Google content.--readonly when the task must not mutate Google data.--no-input in automation and --dry-run before supported writes.| 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.
还没有评价。欢迎分享你的使用感受。
无需登录即可发表。欢迎分享使用感受、提问，或说明在哪些环境下无法运行。
还没有评论。来写第一条吧。
Run OpenClaw tests and reproduce bugs on remote machines through Crabbox. Choose a suitable execution provider, verify realistic user workflows, and report the actual provider, environment ID, logs, and timing.
中文简介正在准备中。当前显示英语简介。
Automate Google Workspace tasks through a command-line tool: read email, calendars, files, documents, and spreadsheet data, or make requested updates. Inspect authentication, return structured JSON data, and restrict allowed operations for agent workflows.
中文简介正在准备中。当前显示英语简介。
Manage Workspace users, groups, and organizational units through gog. The skill guides account selection and command checking, with confirmation of the target and intended change before writes or deletions, plus preview checks for supported writes.
中文简介正在准备中。当前显示英语简介。
Use gog to inspect Google AdSense accounts, ad units, sites, payments, alerts, and policy issues. Generate AdSense reports and retrieve details about ad clients and channels to review advertising operations.
中文简介正在准备中。当前显示英语简介。
Use gog to list Google Analytics 4 account summaries and run reports through the Analytics Data API. Explicit account selection and read-only options help agents retrieve information from the intended account.
中文简介正在准备中。当前显示英语简介。
Manage Apps Script projects through gog: inspect code and metadata, list versions and deployments, download projects locally, create new projects, and run deployed functions with explicit account selection and checks before changes.
中文简介正在准备中。当前显示英语简介。