skills.rest
oresttokovenko
oresttokovenkoCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

gws-sheets-read

Read cell values from Google Sheets spreadsheets via the gws CLI.

Updated Nov 9, 2023
Search Tags:#productivity#cli#spreadsheet#google sheets#range#gws#read values
One-click install
npx skills add https://github.com/oresttokovenko/dot-files --skill gws-sheets-read-oresttokovenko
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: gws-sheets-read
Source: https://github.com/oresttokovenko/dot-files/tree/main/chezmoi/dot_agents/skills/gws-sheets-read
Command: npx skills add https://github.com/oresttokovenko/dot-files --skill gws-sheets-read-oresttokovenko

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Retrieving data from Google Sheets normally requires writing API client code or opening the spreadsheet manually. This Skill lets you read any range of cell values directly from the command line using the gws CLI, with no custom code required. ## Core Features & Use Cases - Range-Based Reading: Fetch any cell range (e.g. 'Sheet1!A1:D10') or an entire sheet from a spreadsheet by ID. - Read-Only Safety: The command never modifies the spreadsheet, making it safe for inspection and reporting workflows. - Use Case: You need to pull the latest metrics from a shared tracking spreadsheet into a script or report. Run a single gws command with the spreadsheet ID and range to get the values instantly. ## Quick Start Ask the AI to read the range Sheet1!A1:D10 from your Google Sheets spreadsheet by providing its spreadsheet ID.

Frequently Asked Questions about gws-sheets-read

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I read values from a Google Sheets spreadsheet from the command line?▼

Use the gws CLI command gws sheets +read with the --spreadsheet flag for the spreadsheet ID and --range for the A1-notation range, such as Sheet1!A1:D10. The command returns the cell values without modifying the spreadsheet.

How do I read an entire sheet instead of a specific range?▼

Pass just the sheet name as the range, for example gws sheets +read --spreadsheet ID --range Sheet1. Omitting the cell bounds returns all values in that sheet.

Does reading a Google Sheet with gws modify the spreadsheet?▼

No, the sheets +read command is strictly read-only and never modifies the spreadsheet. It only retrieves values from the specified range.

What do I need before using gws sheets +read?▼

You need the gws binary installed and configured with authentication, as described in the gws-shared skill. You also need the target spreadsheet ID and a valid range in A1 notation.

What are the limitations of the gws sheets read command?▼

The command only reads values and cannot write, format, or restructure spreadsheet data. For advanced options beyond basic range reads, use the raw values.get API instead.

Related Skills

Explore More Software Engineering Skills→
cellarwoodcellarwood

recipe-sync-contacts-to-sheet

Export Google Workspace directory contacts to a Google Sheets spreadsheet.

Official
Basic
cellarwoodcellarwood

gws-sheets-read

Read cell values from Google Sheets via the gws CLI.

Official
Basic
niclasmartinsson-sysniclasmartinsson-sys
8

gws-sheets

Automate Google Sheets operations from the command line via the Sheets API.

Community
Intermediate
AissenLiuAissenLiu

google-workspace

Automate Gmail, Calendar, Drive, Contacts, Sheets, and Docs tasks via Hermes-managed OAuth.

Community
Advanced