How do I install the Gog Sheets skill?

Run npx skillmds@latest add openclaw/gog-sheets in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

What does the Gog Sheets skill do?

Google Sheets operations through gog. It is listed under Coding & Dev Tools on SkillMD.

Is Gog Sheets safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Gog Sheets?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Gog Sheets free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Gog Sheets?

OpenClaw (@openclaw) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Gog Sheets by openclaw — Agent Skill

Name: Gog Sheets
Author: OpenClaw

File contents

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-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)
`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.

---name: gog-sheetsdescription: Google Sheets operations through gog.---# Google SheetsUse `gog` for Google Sheets operations. Read `../gog/SKILL.md` first for shared auth,output, safety, and live-write rules.## Safe start```bashgog auth list --check --json --no-inputgog schema sheets --jsongog --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-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) || `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.

Frequently asked questions

Gog Sheets