skills.rest
Lilac-Labs
Lilac-LabsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/Lilac-Labs/gini-agent --skill google-sheets-lilac-labs
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
devMoezdevMoez
1

google-workspace

Access Gmail, Calendar, Drive, Sheets, and Docs with OAuth.

Community
Advanced
cellarwoodcellarwood

gws-sheets-read

Read cell values from Google Sheets via the gws CLI.

Official
Basic
cellarwoodcellarwood

gws-sheets

Automate Google Sheets CRUD and batch updates via gws CLI.

Official
Intermediate
temple-slopetemple-slope

recipe-log-deal-update

Append deal status updates to a Google Sheets sales pipeline.

Community
Intermediate