Skills
.Work. You
Rest

sheets-cli

Community

Manage Google Sheets from the CLI

Data & Analytics#spreadsheet#update#read#google-sheets#append#dry-run#sheets-cli
Authorgmickel
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Manipulating tabular data in Google Sheets via the browser or manual CSV edits is slow and error-prone; this Skill provides a reproducible command-line workflow to read, append, and update spreadsheets programmatically with previews and structured JSON I/O.

Core Features & Use Cases

  • Authentication & Access: Login and manage credentials for Google Drive and Sheets API access.
  • Discover & Inspect: Find spreadsheets by name and list sheets/tabs with metadata.
  • Read & Update Workflows: Read table rows with absolute row numbers, append rows, update by key or by row index, and set arbitrary ranges.
  • Batch & Safety: Batch operations, dry-run previews, and JSON-formatted inputs for predictable changes.
  • Use Case: Update a project tracker by finding the "Tasks" spreadsheet, reading rows to find a task ID, previewing the change, and applying a key-based status update.

Quick Start

Read the Tasks sheet, preview an update to set Status to Done for TASK-42 using a dry-run, then apply the update if the preview looks correct.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: sheets-cli
Download link: https://github.com/gmickel/claude-code-config/archive/main.zip#sheets-cli

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.