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

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

Reads cell values and sheets from Google Spreadsheets via CLI. Useful when an agent needs spreadsheet data without risk of altering it.

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

What gws-sheets-read does

Part of the googleworkspace/cli package version 0.22.5, this skill runs gws sheets +read to fetch data from Google Spreadsheets. It requires the --spreadsheet flag with the target ID and the --range flag. For the range, pass a sheet name such as Sheet1 or specific cells like Sheet1!A1:B2 and Sheet1!A1:D10.

The gws binary must be installed. You also need ../gws-shared/SKILL.md for authentication and security rules. If it is missing, create it by running gws generate-skills. The skill is strictly read-only and never modifies your spreadsheet.

If you need advanced query options, Google recommends using the raw values.get API instead. Install this skill if you want safe spreadsheet inspection without worrying about accidental edits.

What it helps with

  • read cell values from a Google Spreadsheet
  • extract data from a specific sheet by name
  • inspect spreadsheet rows without risk of accidental edits

Example prompts for the agent

  • Read range `Sheet1!A1:D10` from spreadsheet ID
  • Fetch values from `Sheet1` in spreadsheet ID
  • Show cells `Sheet1!A1:B2` from spreadsheet ID using gws

How to install gws-sheets-read

1Skills CLI (Vercel)

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

2Manually: put the files in place

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

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

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-sheets official googleworkspace 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. Claude Code CX Codex Cursor +1 58,800installs 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-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

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-read

How do I install gws-sheets-read in Claude Code?

Run npx skills add googleworkspace/cli --skill gws-sheets-read -a claude-code. You can also place the skill file directly at ~/.claude/skills/gws-sheets-read/SKILL.md.

What does gws-sheets-read do?

It executes gws sheets +read to retrieve spreadsheet values. The command takes a spreadsheet ID and a cell range, returning the contents to your agent.

Can gws-sheets-read overwrite spreadsheet contents?

No, the command is read-only and cannot edit files. For advanced retrieval options, the documentation points to the raw values.get API.

Source text

SKILL.md · Apache-2.0 
---
name: gws-sheets-read
description: "Google Sheets: Read values from a spreadsheet."
metadata:
  version: 0.22.5
  openclaw:
    category: "productivity"
    requires:
      bins:
        - gws
    cliHelp: "gws sheets +read --help"
---

# sheets +read

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

Read values from a spreadsheet

## Usage

```bash
gws sheets +read --spreadsheet <ID> --range <RANGE>
```

## Flags

| Flag | Required | Default | Description |
|------|----------|---------|-------------|
| `--spreadsheet` | ✓ | — | Spreadsheet ID |
| `--range` | ✓ | — | Range to read (e.g. 'Sheet1!A1:B2') |

## Examples

```bash
gws sheets +read --spreadsheet ID --range "Sheet1!A1:D10"
gws sheets +read --spreadsheet ID --range Sheet1
```

## Tips

- Read-only — never modifies the spreadsheet.
- For advanced options, use the raw values.get API.

## See Also

- [gws-shared](../gws-shared/SKILL.md) — Global flags and auth
- [gws-sheets](../gws-sheets/SKILL.md) — All read and write spreadsheets commands

© 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