gws-sheets

Automate Google Sheets CRUD operations using the Google Sheets API.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires gws, and includes scripts (resource) components.

What problem does it solve?

Streamline your Google Sheets operations by automating read and write tasks, eliminating manual data entry, and ensuring accuracy in your spreadsheets.

Core Features & Use Cases

  • Read & Write: Execute CRUD operations on Google Sheets.
  • Batch Updates: Apply multiple updates to a spreadsheet in a single request.
  • Data Filtering: Fetch specific data subsets using data filters.
  • Use Case: Suppose you have a sales report spread across multiple sheets, and you need to calculate the total sales amount across them. Use this Skill to read the data, perform calculations, and output the result in a new sheet.

Quick Start

Use the gws sheets command to append the data from the current list of tasks into the 'sales_report' sheet.

Frequently Asked Questions about gws-sheets

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

FAQPage Schema
How do I automate Google Sheets data management without manual data entry?

Automate Google Sheets data management by using the Google Workspace API to execute CRUD operations, handle batch updates, and apply data filters, eliminating manual data entry and ensuring spreadsheet accuracy.

What is the best way to read and write multiple updates to a Google Sheets spreadsheet?

The best way to apply multiple updates to a Google Sheets spreadsheet is using batch updates via the Google Workspace API, allowing you to execute read and write operations in a single request.

Do I need Google Workspace API authentication to perform Google Sheets operations?

Yes, you need Google Workspace API authentication to perform Google Sheets operations. The API handles authentication and data processing for creating, updating, and reading spreadsheet data.

How to fetch specific data subsets from Google Sheets using data filters?

Fetch specific data subsets from Google Sheets by applying data filters through the Google Workspace API, enabling targeted reads of spreadsheet data for calculations or reporting.

Can I calculate total sales amounts across multiple Google Sheets automatically?

Yes, you can calculate total sales amounts across multiple Google Sheets by using the Google Workspace API to read the data, perform calculations, and output the result in a new sheet.