gws-sheets-read
Google Sheets: Read values from a spreadsheet.
Only events from users who opted in to optional analytics are recorded. Views are deduplicated by account, Skill, and Shanghai calendar day. Downloads are deduplicated by account, Skill, version, and Shanghai calendar day; a count means the client successfully delivered the package, not that it was saved to disk. Installs are recorded only after the client successfully writes the Skill, and are deduplicated per account and Skill for 90 days. Withdrawing consent clears personal deduplication records, so an install after opting in again may count again. “This week” means the last 7 Shanghai calendar days. Favorites show the current total.
Skill steps
---
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
Version history
Published versions remain available for verification and restoration.
Imported from googleworkspace/cli@ZIP c7094cd9f725caab6c54b1c016f3f1737d82a26baf623ffdc00be833557a78a4