gws-sheets-read
googleworkspace/cli
Read values from Google Sheets spreadsheets via command line.
What is gws-sheets-read?
This skill retrieves data from a specified range in a Google Sheet. Use it when you need to extract spreadsheet values for processing, analysis, or integration with other tools.
- Read cell values from any range in a Google Sheet
- Specify ranges using standard notation (e.g., 'Sheet1!A1:D10')
- Support for reading entire sheets or specific cell ranges
- Read-only operation—never modifies the spreadsheet
- Access raw values via the Google Sheets API
How to install gws-sheets-read
npx skills add null --skill gws-sheets-read- Google Workspace CLI (gws) installed
- Valid Google authentication configured (see gws-shared documentation)
- Access permissions to the target spreadsheet
How to use gws-sheets-read
- 1.Identify the Spreadsheet ID from the sheet's URL
- 2.Determine the range you want to read (e.g., 'Sheet1!A1:B2' or just 'Sheet1')
- 3.Run: gws sheets +read --spreadsheet <ID> --range <RANGE>
- 4.Process the returned values as needed in your workflow
Use cases
- Extract data from a tracking sheet for reporting or analysis
- Retrieve configuration values stored in a spreadsheet
- Fetch a list of items from a sheet for batch processing
- Pull data from a shared sheet for integration with other systems
- Read survey or form responses collected in a Google Sheet
- Data analysts needing to extract spreadsheet data
- Developers automating workflows with Google Sheets
- Teams managing shared data in spreadsheets
- Anyone building scripts that consume spreadsheet values
gws-sheets-read FAQ
No, this is a read-only operation. It never changes any data in the spreadsheet.
Standard Google Sheets notation like 'Sheet1!A1:D10' for specific ranges, or 'Sheet1' to read the entire sheet.
The Spreadsheet ID is in the URL of your Google Sheet: docs.google.com/spreadsheets/d/{SPREADSHEET_ID}/edit
You need valid Google authentication configured through the gws-shared setup. See the gws-shared documentation for details.
Full instructions (SKILL.md)
Source of truth, from googleworkspace/cli.
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.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
Related skills
More from googleworkspace/cli and the wider catalog.
gws-gmail
Send, read, and manage Gmail emails via Google Workspace CLI.
gws-drive
Manage Google Drive files, folders, and shared drives via CLI.
gws-docs
Read and write Google Docs via command line.
gws-calendar
Manage Google Calendar events, calendars, and access control via CLI.
gws-sheets
Read and write Google Sheets spreadsheets via CLI.
gws-gmail-send
Send emails via Gmail with attachments, CC/BCC, HTML support, and draft options.