skills.rest
niclasmartinsson-sys
niclasmartinsson-sysCOMMUNITY
Explore all skills by this author →
GitHub

gws-sheets

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

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automate everyday spreadsheet tasks by reading and writing Google Sheets from the command line, enabling repeatable workflows and data synchronization.

Core Features & Use Cases

  • CLI access to Google Sheets: create, read, update, and query spreadsheets and cells.
  • Helper Commands: +append appends a row, +read reads values from a spreadsheet.
  • API Resources: spreadsheets.batchUpdate, create, get, getByDataFilter, developerMetadata, sheets, values.
  • Use Case: Automate monthly reporting by reading data from multiple sheets, aggregating, and updating target spreadsheets.

Quick Start

Run gws sheets <resource> <method> [flags] to perform a Sheets operation.

Frequently Asked Questions about gws-sheets

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

FAQPage Schema
How do I automate reading and writing Google Sheets from the command line?▼

This Skill exposes a CLI around the Google Sheets API to automate reading and writing spreadsheet data from the command line. It supports creating spreadsheets, updating metadata, and querying across multiple sheets for repeatable workflows.

Can I append a row to a Google Sheets spreadsheet using a CLI?▼

Yes, you can append a row to a Google Sheets spreadsheet using the dedicated helper command. This CLI feature allows automation workflows to add new data entries directly from the command line without manual spreadsheet interaction.

Does the Google Sheets CLI support batch updates and metadata management?▼

Yes, the Google Sheets CLI supports batch updates and metadata management. It exposes API resources like spreadsheets.batchUpdate and developerMetadata, allowing you to configure and update spreadsheet properties within your automation workflows.

What is the best way to aggregate data from multiple sheets for monthly reporting?▼

The best way to aggregate data for monthly reporting is using a CLI to read data from multiple sheets, aggregate the values, and update target spreadsheets. This automates synchronization and eliminates manual data compilation.

Do I need authentication setup to query Google Sheets via command line?▼

Yes, you need proper authentication and configuration via the shared setup to query Google Sheets via command line. This ensures secure access to the Sheets API for reading values and executing operations.

Related Skills

Explore More Data & Analytics Skills→
HuskyDannyHuskyDanny

google-workspace

Integrates Google Workspace APIs for browsing and editing via Laravel's Tinker REPL.

Community
Advanced
aws-samplesaws-samples
90

file-processing

Process and analyze CSV, JSON, and text data files with automated cleaning and transformation.

Official
Advanced
nieomylniejanieomylnieja
3

gws-sheets

Automate reading and writing Google Sheets data via the gws CLI.

Community
Advanced
juandaniel190juandaniel190
1

gws-sheets-read

Read values from a specified Google Sheets range using the gws CLI.

Community
Basic