Gws Sheets Read
Google Sheets: Read values from a spreadsheet.
$ npx claude-code-templates@latest --command="google-workspace/gws-sheets-read" --yesRequires Claude Code. The command adds this command to your project's .claudedirectory — nothing runs on ToolZip's servers.
What's inside this command
Component source
Google Workspace Sheets Read
Execute Google Workspace Sheets Read operations: $ARGUMENTS
Prerequisites
- Google Workspace CLI (
gws) must be installed - Authentication configured: Run
gws auth statusto verify - Review
gws sheets-read --helpfor all available commands
Available Resources and Methods
sheets +read
PREREQUISITE: Read../gws-shared/SKILL.mdfor auth, global flags, and security rules. If missing, rungws generate-skillsto create it.
Read values from a spreadsheet
Usage
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
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 — Global flags and auth
- gws-sheets — All read and write spreadsheets commands
Usage
# List available resources and methods
gws sheets-read --help
# Inspect method schema before calling
gws schema sheets-read.<resource>.<method>
# Execute command with arguments
gws sheets-read $ARGUMENTS
Task
Execute the requested Sheets Read operation: $ARGUMENTS
- Verify Prerequisites
gws is installed: gws --version
- Verify authentication: gws auth status
- Review available commands: gws sheets-read --help
- Inspect Method Schema
- Use gws schema to understand required fields
- Review parameter types and constraints
- Execute Operation
- Use --params for query/path parameters
- Use --json for request body
- Handle pagination with --max-results or --page-token
- Error Handling
- Review API quotas and rate limits
- Handle authentication issues
- Retry transient failures
License: Apache License 2.0 Source: Google Workspace CLI Original Skill:
gws-sheets-readRelated Claude Code Commands
Gws Events Renew
Google Workspace Events: Renew/reactivate Workspace Events subscriptions.
Gws Calendar Insert
Google Calendar: Create a new event.
Gws Gmail Watch
Gmail: Watch for new emails and stream them as NDJSON.
Gws Sheets Append
Google Sheets: Append a row to a spreadsheet.
Gws Alertcenter
Google Workspace Alert Center: Manage Workspace security alerts.
Gws Apps Script
Google Apps Script: Manage and execute Apps Script projects.
Catalog data and component content are sourced from the open-source davila7/claude-code-templates project (MIT license). ToolZip curates the listing and writes original descriptions; every component links back to its original source. Claude Code is a product of Anthropic. ToolZip is an independent catalog and is not affiliated with or endorsed by Anthropic.