Now liveThe Skillselion MCP - thousands of ranked skills, loaded into your agent mid-task. No install.Get it →
googleworkspace avatar

Gws Sheets Read

  • 40.1k installs
  • 30k repo stars
  • Updated July 22, 2026
  • googleworkspace/cli

gws-sheets-read is a Google Workspace CLI skill that reads cell values from a Google Sheet via gws sheets +read using a spreadsheet ID and range.

About

gws-sheets-read documents the gws sheets +read command of the Google Workspace CLI, which reads cell values from a Google Sheet. It takes a required --spreadsheet ID and a required --range such as Sheet1!A1:D10, and is read-only so it never modifies the sheet. A developer wires it into agents, scripts, or dashboards to pull live spreadsheet data without writing custom Google Sheets API code.

  • Wraps the gws sheets +read CLI command
  • Requires --spreadsheet ID and --range
  • Read-only: never modifies the spreadsheet
  • Feeds agents, scripts, and dashboards with live data
  • Requires the gws binary and gws-shared auth

Gws Sheets Read by the numbers

  • 40,132 all-time installs (skills.sh)
  • +1,373 installs in the week ending Jul 28, 2026 (Skillselion tracking)
  • Ranked #22 of 2,742 Automation & Workflows skills by installs in the Skillselion catalog
  • Security screen: LOW risk (skills.sh audit)
  • Data as of Jul 28, 2026 (Skillselion catalog sync)
At a glance

gws-sheets-read capabilities & compatibility

Requires the gws binary plus Google Workspace OAuth credentials (see gws-shared); no separate paid key stated.

Capabilities
sheets read · data fetch · cli integration
Works with
google drive · excel
Use cases
data analysis · orchestration
Runs
Runs locally
Pricing
Bring your own API key
From the docs

What gws-sheets-read says it does

Read values from a spreadsheet
SKILL.md
Read-only — never modifies the spreadsheet.
SKILL.md
gws sheets +read --spreadsheet <ID> --range <RANGE>
SKILL.md
npx skills add https://github.com/googleworkspace/cli --skill gws-sheets-read

Add your badge

Show developers this skill is listed on Skillselion. Paste this into your README.

Listed on Skillselion
Installs40.1k
repo stars30k
Security audit3 / 3 scanners passed
Last updatedJuly 22, 2026
Repositorygoogleworkspace/cli

How do I read live Google Sheets data from a script or agent without building a Sheets API integration?

Read values from a Google Sheet via the gws CLI to feed agents, scripts, or dashboards.

Who is it for?

Developers who need agents, scripts, or dashboards to pull live Google Sheets data without writing custom Sheets API glue.

Skip if: Writing to or modifying spreadsheets; it is strictly read-only and defers advanced options to the raw values.get API.

When should I use this skill?

An agent, dashboard, or shell pipeline needs to read values from a specific Google Sheet range.

What you get

Returns cell values from the given spreadsheet ID and range for use in agents, scripts, or dashboards.

  • Google Sheets cell values for a given range

By the numbers

  • 2 required flags (--spreadsheet, --range)

Files

SKILL.mdMarkdownGitHub ↗

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

gws sheets +read --spreadsheet <ID> --range <RANGE>

Flags

FlagRequiredDefaultDescription
--spreadsheetSpreadsheet ID
--rangeRange 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

How it compares

Choose gws-sheets-read over hand-rolled Sheets API clients when your stack already uses `gws` and you only need a quick range read from the shell.

FAQ

What does gws sheets +read do?

It reads values from a Google Sheet given a required --spreadsheet ID and --range like Sheet1!A1:D10.

Can it modify the spreadsheet?

No. It is read-only and never modifies the spreadsheet; for advanced options it points to the raw values.get API.

Is Gws Sheets Read safe to install?

skills.sh reports 3 of 3 security scanners passed. Review the Security Audits panel on this page before installing in production.

Automation & Workflowspipelinesanalytics

This week in AI coding

Five minutes, every Monday - the tools, releases and tactics for developers.

unsubscribe anytime.