sheets-cli

gmickel's avatarfrom gmickel

Read, write, and update Google Sheets data via CLI. Use when the user asks to read spreadsheet data, update cells, append rows, or work with Google Sheets. Triggers on mentions of spreadsheets, sheets, Google Sheets, tabular data in the cloud, or specific sheet names like "Projects" or "Tasks".

⭐7stars🔀0forks📁View on GitHub🕐Updated Dec 28, 2025⬇️1downloads

When & Why to Use This Skill

The sheets-cli skill empowers Claude to interact directly with Google Sheets through a powerful command-line interface. It enables seamless reading, writing, and updating of cloud-based tabular data, allowing users to automate spreadsheet management, perform batch operations, and synchronize project data without leaving the chat interface. This skill is ideal for users looking to bridge the gap between AI reasoning and structured data storage.

Use Cases

  • Project Tracking: Automatically update task statuses, owner names, or deadlines in a 'Projects' or 'Tasks' spreadsheet based on project updates.
  • Data Logging: Append new rows of information, such as meeting notes, research findings, or lead generation data, directly into a centralized Google Sheet.
  • Inventory Management: Search for specific items by ID or key to retrieve current stock levels or update pricing and availability in real-time.
  • Automated Reporting: Read data from multiple sheets to summarize performance metrics, generate status reports, or identify trends in tabular data.
  • Data Cleaning and Maintenance: Perform batch updates to correct formatting, fill in missing values, or synchronize data across different sheets using dry-run previews for safety.
namesheets-cli
descriptionRead, write, and update Google Sheets data via CLI. Use when the user asks to read spreadsheet data, update cells, append rows, or work with Google Sheets. Triggers on mentions of spreadsheets, sheets, Google Sheets, tabular data in the cloud, or specific sheet names like "Projects" or "Tasks".

sheets-cli

CLI for Google Sheets. Read tables, append rows, update cells by key or index, batch operations.

Installation: Already installed in PATH. Run commands directly.

Quick Start

sheets-cli sheets find --name "Projects"                    # Find spreadsheet
sheets-cli read table --spreadsheet <id> --sheet "Sheet1"   # Read data
sheets-cli update key --spreadsheet <id> --sheet "Tasks" \
  --key-col "ID" --key "TASK-42" --set '{"Status":"Done"}'  # Update by key

Workflow

Always: read → decide → dry-run → apply

sheets-cli read table --sheet "Tasks" --limit 100
sheets-cli update key ... --dry-run   # Preview first
sheets-cli update key ...             # Then apply

For complete command reference, see reference.md.