google-sheets

Read, append, and update Google Sheets cell ranges via gws CLI and Sheets v4 API.

1.7k|523|Updated May 5, 2026

Search Tags:#spreadsheet automation #google sheets #data logging #gws cli #batch update #oauth scopes #cell ranges

Ready to run

npx skills add https://github.com/Lilac-Labs/gini-agent --skill google-sheets-lilac-labs

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: google-sheets
Source: https://github.com/Lilac-Labs/gini-agent/tree/main/skills/google/google-sheets
Command: npx skills add https://github.com/Lilac-Labs/gini-agent --skill google-sheets-lilac-labs

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It eliminates manual spreadsheet copy-paste by letting you programmatically read and write cell ranges in Google Sheets through a consistent command interface.

Core Features & Use Cases

Read cell ranges and whole sheets: Pull values from specific tabs and ranges so you can use the data elsewhere.
Append and update rows/cells: Add new entries to tracking sheets or overwrite specific ranges with computed results.
Perform structured batch edits: Apply atomic structure changes like adding tabs or freezing rows using Sheets v4 batchUpdate.

Quick Start

Ask the agent to append a row to your spreadsheet by specifying the spreadsheet and the values you want added.

Frequently Asked Questions about google-sheets

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

FAQPage Schema

How do I automate Google Sheets updates without manual copy-paste?▼

Google Sheets cell range updates are automated using the gws CLI and the Sheets v4 API. It enables programmatic reading, appending, and overwriting of spreadsheet data, eliminating manual copy-paste through a consistent command interface for tracking logs and computed results.

Can I append new rows to a Google Sheets tracking log automatically?▼

Yes, you can append new rows to a Google Sheets tracking log automatically. The Skill supports appending entries to tracking sheets via the gws CLI, allowing you to add new values to specific spreadsheets programmatically without manual data entry.

What do I need to read and write Google Sheets cell ranges programmatically?▼

To read and write Google Sheets cell ranges, you need an authenticated gws setup with appropriate Sheets OAuth scopes configured. This environment provides the necessary authorization to execute lookup, append, and targeted range overwrite operations via the v4 API.

Does the Sheets v4 API support atomic batch updates for adding tabs and freezing rows?▼

The Sheets v4 API supports atomic batch updates for adding tabs and freezing rows. The Skill applies these structured spreadsheet changes using spreadsheets.batchUpdate and values.batchUpdate operations through the gws CLI interface.

What is the best way to pull values from specific Google Sheets tabs for use elsewhere?▼

The best way to pull values from specific Google Sheets tabs is using the gws CLI to read targeted cell ranges and whole sheets. This extracts data programmatically via the Sheets v4 API so you can use the values in other downstream processes.