google-sheets

Read, append, update, and create Google Sheets via the gws CLI.

10|1|Updated Feb 5, 2026
One-click install
npx skills add https://github.com/pbc-os/agent-skills-public --skill google-sheets-pbc-os
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: google-sheets
Source: https://github.com/pbc-os/agent-skills-public/tree/main/skills/tier-3-business-ops/google-sheets
Command: npx skills add https://github.com/pbc-os/agent-skills-public --skill google-sheets-pbc-os

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates tedious spreadsheet operations, allowing you to manage sales data, inventory, expenses, and more without manual data entry or complex formula writing.

Core Features & Use Cases

  • Data Entry & Updates: Append new rows, update specific cells, or batch update multiple ranges in your Google Sheets.
  • Data Retrieval: Read specific ranges or entire sheets to get the data you need.
  • Spreadsheet Creation: Generate new spreadsheets with predefined sheets and titles.
  • Data Export: Export your sheet data in CSV or Excel formats.
  • Use Case: Automatically log daily sales figures by appending a new row to your "Daily Sales Tracker" spreadsheet.

Quick Start

Use the google-sheets skill to append a new row with today's date, product name 'Widget X', and quantity '10' to the 'Inventory' sheet in your 'Product Inventory' spreadsheet.

Frequently Asked Questions about google-sheets

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

FAQPage Schema
How do I automate sales tracking and inventory management in Google Sheets?

You can automate sales tracking and inventory management by using this skill to append new rows, update specific cells, or batch update ranges in your Google Sheets without manual data entry. It handles daily sales figures and product quantities automatically.

How do I export Google Sheets data to CSV or Excel formats?

Exporting Google Sheets data to CSV or Excel formats is supported directly through the skill's data export features. You can retrieve specific ranges or entire sheets and convert them into your desired file format for offline analysis.

Do I need the gws CLI installed to automate spreadsheet operations?

Yes, the gws CLI must be installed and authenticated with Google Workspace scopes to perform spreadsheet operations. This dependency is required for the skill to read, append, update, and create spreadsheets.

Can I automatically create new spreadsheets with predefined sheets and titles?

Creating new spreadsheets with predefined sheets and titles is a core feature of this skill. You can generate entirely new spreadsheets programmatically to organize expense reporting, inventory, or sales data.

What is the best way to batch update multiple ranges in a spreadsheet?

The best way to batch update multiple ranges in a spreadsheet is using this skill's data entry and update features. It allows you to append new rows, update specific cells, or batch update multiple ranges simultaneously.

Are there limitations when using this skill for expense reporting and data management?

The main limitation for expense reporting and data management is the strict dependency on the gws CLI. If the gws CLI is not installed or lacks the proper Google Workspace authentication scopes, all spreadsheet operations will fail.