gws-sheets-read
Enables the agent to read information from a Google Sheets spreadsheet. Essential for extracting data and using it in other tasks.
What it does
This tool reads information from a Google Sheet. You specify which sheet and which part of it you want to see.
When to use it
- ✓When you need to find specific data in a list.
- ✓To check information in a table without opening it.
- ✓When you want to copy values from a spreadsheet elsewhere.
Example of what to ask your AI
“Show me the names in the 'My List' sheet from column A.”
Want more? Open the sections below.
How to use
The easiest way: copy the message below and paste it into Claude, ChatGPT, Cursor or any AI. It reads the skill and follows the instructions.
Skill link
Ready-to-paste message
How it works
You provide the sheet's ID and the area (like 'page1!A1:B5'). The tool fetches and gives you the values from that area.
Installation
Easiest way: copy the skill link and paste it into Claude, ChatGPT or Cursor asking it to follow the instructions.
In the terminal (Claude Code, Codex, Cursor), in your project folder:
npx skills add googleworkspace/cli --skill gws-sheets-readOr download just the file:
curl -L https://raw.githubusercontent.com/googleworkspace/cli/main/skills/gws-sheets-read/SKILL.md -o SKILL.mdTechnical content (original SKILL.md)
Original text by the author, straight from GitHub.
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
FAQ
Does this tool change the spreadsheet?
No, it only reads information and makes no changes.
What is 'Spreadsheet ID'?
It's a unique code that identifies your spreadsheet in Google Drive.
What is 'Range'?
It's the specific area of the spreadsheet you want to read, like 'Sheet1!A1:C10' (from cell A1 to C10 on Sheet1).
Details
Original description by the author
Google Sheets: Read values from a spreadsheet.
repo: googleworkspace/cli
Popularity
- GitHub stars
- 32k
- Ranking position
- #6284
- License
- Apache-2.0
- Updated
- 10/6/2026
Comments
- …
More skills from this repository
gws-admin-reports
Helps your agent get activity reports from Google Workspace. It collects audit and usage data.
googleworkspace/cli
gws-calendar-agenda
Helps your agent see upcoming events across all calendars. It's useful for organizing your schedule and knowing what's coming up.
googleworkspace/cli
gws-calendar-insert
Lets your agent create new events in Google Calendar. It's useful for scheduling appointments and meetings.
googleworkspace/cli
gws-calendar
Allows your agent to manage calendars and events. It's useful for organizing your life and work.
googleworkspace/cli
Similar skills
google-workspace-ops
Operates with Google Workspace documents (Drive, Docs, Sheets, Slides) as a unified workflow. It makes it easy to find, summarize, and edit your files without leaving the tool.
affaan-m/ECC
Dynamics 365 Automation
Helps your agent manage customer information in Dynamics 365. It can handle contacts, sales, and cases, making work more organized.
ComposioHQ/awesome-claude-skills
Excel Automation
Helps your agent work with spreadsheets in Excel and Google Sheets. It can create, edit, and format files.
ComposioHQ/awesome-claude-skills