Pull data from a Google Sheet into Claude

Reads rows, columns, or ranges from any Google Sheet you own and passes the data to Claude for analysis, sorting, or transformation.

Best for: Automating the "copy-paste my sheet into a spreadsheet tool" step.

Operations / process-automationatomicfor-opsneeds-integrationfrom-csv

Topics

agent-skillsai-agentautomationclidiscovery-apigemini-cli-extensiongoogle-admingoogle-apigoogle-calendargoogle-chatgoogle-docsgoogle-drivegoogle-sheetsgoogle-workspaceoauth2rust

Source

Creator's repository · googleworkspace/cli

View on GitHub ↗

License: Apache-2.0

Skill file

Preview skill file↓↑

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