skills.rest
leolionart
leolionartCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

google-sheets

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

1|Updated Mar 7, 2026
Search Tags:#automation#cli#spreadsheet#read#google-sheets#write#gws
One-click install
npx skills add https://github.com/leolionart/claude-skills --skill google-sheets-leolionart
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: google-sheets
Source: https://github.com/leolionart/claude-skills/tree/main/plugins/google-sheets/skills/google-sheets
Command: npx skills add https://github.com/leolionart/claude-skills --skill google-sheets-leolionart

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Read, write, and manage Google Sheets via the Google Workspace CLI (gws), enabling automation of common spreadsheet tasks and reducing manual data handling.

Core Features & Use Cases

  • Read specific ranges or entire sheets to extract data for processing
  • Append rows and update data programmatically to keep sheets in sync with workflows
  • Create new spreadsheets and use Sheets as a data store for automation pipelines

Quick Start

Ask me to read ranges, append rows, or create spreadsheets using gws to automate Google Sheets workflows.

Frequently Asked Questions about google-sheets

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

FAQPage Schema
How do I automate Google Sheets tasks from the command line?▼

Automate Google Sheets tasks from the command line using the gws CLI to read ranges, append rows, and create spreadsheets programmatically. This approach reduces manual data handling and integrates spreadsheet management into your automation pipelines.

What do I need to read and write Google Sheets via the gws CLI?▼

To read and write Google Sheets via the gws CLI, you need gws installed and authenticated with the OAuth scope for spreadsheets. If you use the helper script, Python 3.8 or higher is also required for execution.

Can I use Google Sheets as a data store for automation pipelines?▼

Yes, you can use Google Sheets as a data store for automation pipelines by creating new spreadsheets and appending rows programmatically via the gws CLI. This allows workflows to sync data and maintain state directly within a spreadsheet.

Does Google Sheets CLI automation support read-only access?▼

Yes, Google Sheets CLI automation supports read-only access by authenticating with the spreadsheets.readonly OAuth scope. This restricts operations to reading specific ranges or entire sheets without granting write permissions.

How do I extract specific data ranges from a spreadsheet for processing?▼

You extract specific data ranges from a spreadsheet for processing by executing read commands through the gws CLI. This allows your scripts to pull targeted rows and columns directly from Google Sheets for downstream data manipulation.

Related Skills

Explore More Data & Analytics Skills→
AissenLiuAissenLiu

google-workspace

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

Community
Advanced
vikingokftvikingokft

gws-sheets-append

Insert rows into a Google Sheets spreadsheet using the gws tool.

Official
Intermediate
CygnusfearCygnusfear
5

devflow

Automate end-to-end agent development workflows with phase-driven coordination and issue extraction.

Community
Advanced
73ai73ai
4

gws-sheets

Read and write Google Sheets data via the Sheets API.

Official
Advanced