gws-sheets

Automate Google Sheets CRUD and batch updates via gws CLI.

Updated Apr 6, 2026
One-click install
npx skills add https://github.com/cellarwood/figurio --skill gws-sheets-cellarwood
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: gws-sheets
Source: https://github.com/cellarwood/figurio/tree/main/skills/gws-sheets
Command: npx skills add https://github.com/cellarwood/figurio --skill gws-sheets-cellarwood

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill enables automated reading and writing of Google Sheets so teams and agents can avoid manual spreadsheet edits, centralize data capture, and integrate sheet-based data into workflows.

Core Features & Use Cases

  • Append rows to spreadsheets using a dedicated append helper for quick data ingestion.
  • Read ranges and values to retrieve structured data for reports, analysis, or downstream processing.
  • Sheet management including batchUpdate, create, get, developerMetadata, sheets, and values operations for comprehensive automation.
  • Use Case: Automatically append new order details from a storefront into a master spreadsheet and read ranges to generate nightly sales reports.

Quick Start

Ask the skill to append a row with name, email, and order details to the target spreadsheet using the append helper.

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 reading and writing Google Sheets programmatically by using a Skill that wraps the Sheets API to append rows, read ranges, and perform batch updates without manual edits. It requires authenticated Google Workspace credentials and the gws CLI in PATH.

Can I append rows to a Google Sheets spreadsheet automatically?

Yes, you can append rows to a Google Sheets spreadsheet automatically using a dedicated append helper designed for quick data ingestion. This allows workflows or AI agents to continuously add new entries like order details into a master spreadsheet.

How do I read ranges and values from Google Sheets for reports?

To read ranges and values from Google Sheets for reports, you can use automated sheet operations to retrieve structured data. This fetched data can then be used for analysis, nightly sales reports, or downstream processing in your workflows.

Do I need authenticated Google Workspace credentials to use the Sheets API?

Yes, you need authenticated Google Workspace credentials to use the Sheets API for automated spreadsheet management. You also need the gws CLI available in your PATH and method-specific parameters built from the gws schema for correct API calls.

What Google Sheets management operations are available for automation?

Available Google Sheets management operations for automation include batchUpdate, create, get, developerMetadata, sheets, and values operations. These provide comprehensive coverage for integrating sheet management operations into automated workflows or AI agents.

Can I integrate Google Sheets operations into AI agents?

Yes, you can integrate Google Sheets operations into AI agents by programmatically managing spreadsheet data and updates. Agents can read ranges, append rows, and perform batch updates to centralize data capture and avoid manual spreadsheet edits.