skills.rest
haberlah
haberlahCOMMUNITY
Explore all skills by this author →
GitHub

gws-sheets

Automates reading and writing of Google Sheets data for applications such as inventory, CRMs, and task lists.

8|3|Updated Feb 8, 2026
Search Tags:#automation#api#spreadsheet#read#google-sheets#write
One-click install
npx skills add https://github.com/haberlah/dotfiles-claude --skill gws-sheets-haberlah
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: gws-sheets
Source: https://github.com/haberlah/dotfiles-claude/tree/main/skills/gws-sheets
Command: npx skills add https://github.com/haberlah/dotfiles-claude --skill gws-sheets-haberlah

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Read and write data in Google Sheets programmatically to automate data pipelines, reduce manual entry, and improve consistency.

Core Features & Use Cases

  • Read values from spreadsheets and ranges programmatically
  • Write and update cells, ranges, and perform batch updates
  • Retrieve metadata and manage sheets for reporting and data integration
  • Use cases: automated data ingestion, syncing across apps, and dynamic dashboard updates

Quick Start

Install and configure gws-sheets then prompt it to operate on your target sheet to begin automating your data workflow.

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 data programmatically?▼

You can automate Google Sheets data by using API endpoints for reading values and performing batch updates. This skill programmatically handles cell updates, data retrieval, and cross-sheet synchronization to reduce manual entry.

Can I sync data across spreadsheets using batch updates?▼

Yes, batch updates support cross-sheet synchronization and automated reporting across teams. The skill applies batchUpdate operations to programmatically write and update cells, ranges, and metadata for consistent data integration.

Do I need authentication to access the Google Sheets API for automated reporting?▼

Yes, accessing Google Sheets API endpoints requires authentication and the gws CLI. You must configure these prerequisites to retrieve metadata, manage sheets, and execute automated data ingestion workflows securely.

What is the best way to retrieve spreadsheet metadata for dynamic dashboard updates?▼

Retrieving spreadsheet metadata for dynamic dashboards is achieved through the get and getByDataFilter API endpoints. This skill programmatically fetches metadata to manage sheets and integrate data for reporting pipelines.

Does this approach work for automated data ingestion from Google Sheets?▼

Yes, automated data ingestion is a primary use case. By programmatically reading values from spreadsheets and ranges, the skill satisfies API access to integrate data across apps and update dashboards dynamically.

Related Skills

Explore More Data & Analytics Skills→
lanejlanej
40

gspace

Automate Google Workspace file and data management via gspace CLI and MCP tools.

Community
Intermediate
rafazshrafazsh

XLSX Processor

Extract and convert XLSX spreadsheet data into Markdown, CSV, or JSON.

Community
Intermediate
telagodtelagod
238

data-engineering

Orchestrates batch and streaming data pipelines with quality validation.

Community
Intermediate
wuyyyyyouwuyyyyyou

recipe-log-deal-update

Append deal status updates to a Google Sheets Pipeline spreadsheet.

Community
Intermediate