Skip to main content
affpapa.org
RU EN
skill Claude Code CX Codex Cursor GitHub Copilot official · Google

gws-sheets — Claude Code skill: what it does, how to install

This skill lets an agent read and edit Google Sheets through the CLI. Use it when a coding workflow needs spreadsheet data or table updates.

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓ 
npx skills add googleworkspace/cli --skill gws-sheets -a claude-code
Open on GitHub

What gws-sheets does

gws-sheets gives an agent commands for Google Sheets through gws sheets [flags]. It covers spreadsheet creation, value reads and writes, and batch updates. Separate helpers handle row appends with +append and spreadsheet reads with +read.

Inspect available resources with gws sheets --help before calling an API method. Then use gws schema sheets.. to check required parameters, types, and defaults. The skill requires the gws binary and the shared file ../gws-shared/SKILL.md, which contains auth settings, global flags, and security rules.

Install it when your agent needs to work with spreadsheets through the Google Workspace CLI. A project without gws or configured auth needs environment setup first.

What it helps with

  • read values from Google Sheets
  • append rows to a spreadsheet
  • create a new spreadsheet
  • apply batch updates
  • inspect API method parameters

Example prompts for the agent

  • Read the values from this spreadsheet with `gws sheets`.
  • Append this row using `+append`.
  • Inspect the method with `gws schema sheets..`.

How to install gws-sheets

1Skills CLI (Vercel)

npx skills add googleworkspace/cli --skill gws-sheets -a claude-code

2Manually: put the files in place

~/.claude/skills/gws-sheets/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/gws-sheets/

From the same set95

The whole set →
gws-gmail official googleworkspace This skill hands your agent Gmail: send mail, read the inbox, reply in a thread. Useful when email work already runs through the gws CLI. Claude Code CX Codex Cursor +1 81,900installs gws-gmail-send official googleworkspace A skill that teaches your agent to send Gmail from the terminal: recipients, subject, body, attachments and drafts. Claude Code CX Codex Cursor +1 74,700installs gws-drive official googleworkspace This skill hands your agent Google Drive through the gws CLI: files, folders, shared drives, comments and access requests. Useful when docs move through code. Claude Code CX Codex Cursor +1 74,500installs gws-shared official googleworkspace This skill gives agents shared rules for gws CLI authentication, flags, and output formats. Use it when working with gws commands. Claude Code CX Codex Cursor +1 66,000installs gws-calendar official googleworkspace Manage Google Calendar events, access rules, and schedules through the gws CLI tool. Claude Code CX Codex Cursor +1 61,100installs gws-docs official googleworkspace This skill lets an agent read and update Google Docs through gws. Use it when document changes should happen from an agent chat. Claude Code CX Codex Cursor +1 58,300installs gws-sheets-read official googleworkspace Reads cell values and sheets from Google Spreadsheets via CLI. Useful when an agent needs spreadsheet data without risk of altering it. Claude Code CX Codex Cursor +1 50,600installs gws-docs-write official googleworkspace Appends plain text to the end of a Google Docs document through gws. Use it when an agent needs to write a result into a specific document. Claude Code CX Codex Cursor +1 50,100installs

Similar

ppt-master hugohe3 This skill creates and edits PPTX decks, rebuilds slide visuals, and fills native templates. Use it when an agent needs a presentation workflow rather than plain text. Claude Code CX Codex Cursor +1 19,700installs pptx official anthropics This skill helps create, read, and edit .pptx files and .potx templates. Use it when building a deck or extracting slide text. Claude Code Claude.ai 241,433installs pdf official anthropics This skill lets an agent read, create, and edit PDF files, including forms and scanned documents. Use it when PDF work is part of the task. Claude Code Claude.ai 216,041installs docx official anthropics This skill creates, reads, and edits Word documents and templates. Use it for reports, letters, and files that need headings, tables, or page numbers. Claude Code Claude.ai 206,304installs xlsx official anthropics Creates, reads, edits, and converts spreadsheet files. Use it when the requested deliverable is an Excel workbook or another tabular file. Claude Code Claude.ai 187,223installs brand-guidelines official anthropics Applies Anthropic's official brand colors and fonts to documents, slides and other artifacts. Useful whenever something needs to match the company look. Claude Code Claude.ai 109,043installs theme-factory official anthropics Applies preset color palettes and font pairs to slides, documents, and HTML pages. Use it when an artifact needs one consistent visual style. Claude Code Claude.ai 94,921installs

Questions about gws-sheets

How do I install gws-sheets in Claude Code?

Run npx skills add googleworkspace/cli --skill gws-sheets -a claude-code. The skill file is placed at ~/.claude/skills/gws-sheets/SKILL.md.

What does gws-sheets do?

It lets an agent read and edit Google Sheets through gws. It also supports spreadsheet creation and batch updates.

What does gws-sheets require?

It requires the gws binary and the shared file ../gws-shared/SKILL.md for auth settings, global flags, and security rules.

Source text

SKILL.md · Apache-2.0 
---
name: gws-sheets
description: "Google Sheets: Read and write spreadsheets."
metadata:
  version: 0.22.5
  openclaw:
    category: "productivity"
    requires:
      bins:
        - gws
    cliHelp: "gws sheets --help"
---

# sheets (v4)

> **PREREQUISITE:** Read `../gws-shared/SKILL.md` for auth, global flags, and security rules. If missing, run `gws generate-skills` to create it.

```bash
gws sheets <resource> <method> [flags]
```

## Helper Commands

| Command | Description |
|---------|-------------|
| [`+append`](../gws-sheets-append/SKILL.md) | Append a row to a spreadsheet |
| [`+read`](../gws-sheets-read/SKILL.md) | Read values from a spreadsheet |

## API Resources

### spreadsheets

  - `batchUpdate` — Applies one or more updates to the spreadsheet. Each request is validated before being applied. If any request is not valid then the entire request will fail and nothing will be applied. Some requests have replies to give you some information about how they are applied. The replies will mirror the requests. For example, if you applied 4 updates and the 3rd one had a reply, then the response will have 2 empty replies, the actual reply, and another empty reply, in that order.
  - `create` — Creates a spreadsheet, returning the newly created spreadsheet.
  - `get` — Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within grids is not returned. You can include grid data in one of 2 ways: * Specify a [field mask](https://developers.google.com/workspace/sheets/api/guides/field-masks) listing your desired fields using the `fields` URL parameter in HTTP * Set the includeGridData URL parameter to true.
  - `getByDataFilter` — Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. For more information, see [Read, write, and search metadata](https://developers.google.com/workspace/sheets/api/guides/metadata). This method differs from GetSpreadsheet in that it allows selecting which subsets of spreadsheet data to return by specifying a dataFilters parameter. Multiple DataFilters can be specified.
  - `developerMetadata` — Operations on the 'developerMetadata' resource
  - `sheets` — Operations on the 'sheets' resource
  - `values` — Operations on the 'values' resource

## Discovering Commands

Before calling any API method, inspect it:

```bash
# Browse resources and methods
gws sheets --help

# Inspect a method's required params, types, and defaults
gws schema sheets.<resource>.<method>
```

Use `gws schema` output to build your `--params` and `--json` flags.

© googleworkspace · Apache-2.0 · googleworkspace/cli

See also

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor