skills.rest
omriariav
omriariavCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

gws-sheets

Read, write, and manage Google Sheets data via the gws CLI.

7|2|Updated Jan 22, 2026
Search Tags:#automation#cli#data management#spreadsheet#google sheets#gws
One-click install
npx skills add https://github.com/omriariav/workspace-cli --skill gws-sheets-omriariav
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: gws-sheets
Source: https://github.com/omriariav/workspace-cli/tree/main/skills/sheets
Command: npx skills add https://github.com/omriariav/workspace-cli --skill gws-sheets-omriariav

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides command-line access to Google Sheets, enabling users to read, write, and manage spreadsheets directly from their terminal without needing to open the Google Sheets web interface.

Core Features & Use Cases

  • Data Manipulation: Read, write, append, clear, and format cell data.
  • Sheet Management: Create, delete, rename, duplicate, and list sheets.
  • Advanced Operations: Handle batch operations, named ranges, filters, charts, and conditional formatting.
  • Use Case: Automatically update a sales report spreadsheet with new data fetched from another source, or quickly extract specific data ranges for analysis.

Quick Start

Use the gws-sheets skill to read the data from the range 'Sheet1!A1:D10' in the spreadsheet with ID '1abc123xyz'.

Frequently Asked Questions about gws-sheets

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

FAQPage Schema
How do I manage Google Sheets from the terminal?▼

You can manage Google Sheets from the terminal by using a CLI tool to read, write, and manipulate spreadsheet data programmatically via the Google Sheets API without opening the web interface.

What advanced spreadsheet operations are supported by command line interfaces?▼

Command line spreadsheet interfaces support advanced operations including batch processing, cell formatting, named ranges, filters, charting, and conditional formatting directly through API calls.

Do I need OAuth2 authentication to read and write spreadsheet data via CLI?▼

Yes, OAuth2 authentication is required to interface with the Google Sheets API and securely execute CLI commands for reading, writing, and managing your spreadsheet data.

Can I automate updating a Google Sheets spreadsheet with data from another source?▼

Yes, you can automate updating a Google Sheets spreadsheet by using CLI commands to append and write new data fetched from external sources directly into specific cell ranges.

What is the best way to extract specific data ranges from Google Sheets for analysis?▼

The best way to extract specific data ranges is using CLI commands to read targeted cell values, such as querying a defined range like 'Sheet1!A1:D10', and outputting the data for analysis.

Related Skills

Explore More Software Engineering Skills→
Oruga420Oruga420

gws-installer

Install and configure the Google Workspace CLI for terminal access.

Community
Advanced
zeroix07zeroix07

xlsx

Create, edit, analyze, and convert Excel files with Python and openpyxl.

Community
Advanced
clearclownclearclown
3

orchestrator

Coordinates 5-phase AIDA pipeline workflows with Leader and Player subagent delegation.

Community
Advanced
ClawLink-HQClawLink-HQ
117

google-sheets-spreadsheets

Automate spreadsheet creation, data reading/writing, and chart generation via the Google Sheets API.

Official
Intermediate