sheets-cli

🥈Silver

Composable Google Sheets CLI for humans and agents. Read, write, update cells by key. Integrates with Claude Code and OpenAI Codex. Ideal for operations teams automating spreadsheet tasks.

5620Updated 1mo ago

Intermediate30min to implementautomation

Saves ~60 min per use

Quick InstallView Source

git clone https://github.com/gmickel/sheets-cli.git

Works with:

Claude

Overview

About This Skill

sheets-cli is a fast, deterministic command-line interface for Google Sheets that enables programmatic spreadsheet automation. It provides structured JSON output for reading tables, appending rows, updating cells by key column or row index, and executing batch operations—all without fragile row indices. The tool integrates directly with Claude Code, OpenAI Codex, and VS Code, automatically discovering when you mention spreadsheet tasks. Built on Bun and TypeScript, it's designed for operations teams, data engineers, and AI agents automating routine spreadsheet workflows at scale.

How to Use

Clone the repository and install dependencies using Bun. Enable Google Sheets and Google Drive APIs in Google Cloud Console, create OAuth 2.0 credentials for a Desktop app, then run `sheets-cli auth login` with your credentials file. Set your default spreadsheet ID as an environment variable to avoid passing it with each command, then use read, append, update, and batch commands with JSON input/output.

Use Cases

Append new rows to tracking sheets via CLI from scripts or agents

Update specific cells by key column instead of fragile row numbers

Read Google Sheets as structured JSON for downstream processing

Execute batch spreadsheet operations in a single command

Setup & Installation

Quick Install

No install command available. Check the GitHub repository for manual installation instructions.

Alternative Install (Git Clone)

git clone https://github.com/gmickel/sheets-cli

Requirements

Claude Code or compatible AI agent
Works with: Claude

Quick Start Guide

Install the Skill

Copy the install command above and run it in your terminal.

Open Your AI Agent

Launch Claude Code, Cursor, or your preferred AI coding agent.

Try It Out

Use the prompt template or examples below to test the skill.

Customize

Adapt the skill to your specific use case and workflow.

Usage Examples

Prompt Template

I want to use sheets-cli to automate data entry for [COMPANY] in the [INDUSTRY] sector. I have a Google Sheet with the following structure: [DATA]. Please provide the commands to update specific cells based on this data.

Example Output

```markdown
# Google Sheets Automation Commands

## Command 1: Update Sales Data
```
```bash
sheets-cli update --spreadsheet-id 1AbCdEfGhIjKlMnOpQrStUvWxYz --range "Sales!B2" --value 5000
```

## Command 2: Update Customer Information
```bash
sheets-cli update --spreadsheet-id 1AbCdEfGhIjKlMnOpQrStUvWxYz --range "Customers!A3" --value "New Customer"
```

## Command 3: Read Data from Inventory Sheet
```bash
sheets-cli read --spreadsheet-id 1AbCdEfGhIjKlMnOpQrStUvWxYz --range "Inventory!A1:D10"
```

These commands will help you automate the data entry process for [COMPANY] in the [INDUSTRY] sector.
```