How do I install the Sheets CLI skill?

Run npx skillmds@latest add mediar-ai/sheets-cli in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

What does the Sheets CLI skill do?

Google Sheets CLI It is listed under Coding & Dev Tools on SkillMD.

Is Sheets CLI safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Sheets CLI?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Sheets CLI free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Sheets CLI?

mediar-ai (@mediar-ai) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Sheets CLI by mediar-ai — Agent Skill

Name: Sheets CLI
Author: mediar-ai

File contents

Google Sheets CLI

Read, write, and update Google Sheets data via CLI with primitives for tables, rows, and cells.

Prerequisites

sheets-cli installed and in PATH
Google Sheets API credentials configured

Instructions

Quick Reference

# Find spreadsheet by name
sheets-cli sheets find --name "Projects"

# List sheets/tabs
sheets-cli sheets list --spreadsheet <id-or-url>

# Read table data
sheets-cli read table --spreadsheet <id> --sheet "Sheet1" --limit 100

# Update by key column (preferred - rows can shift)
sheets-cli update key --spreadsheet <id> --sheet "Projects" \
  --key-col "Name" --key "Acme" --set '{"Status":"Done"}'

# Append row
sheets-cli append --spreadsheet <id> --sheet "Projects" \
  --values '{"Name":"NewCo","Status":"Active"}'

Workflow Pattern

Always follow read → decide → dry-run → apply:

# 1. Understand current state
sheets-cli read table --sheet "Tasks" --limit 100

# 2. Dry-run first
sheets-cli update key --sheet "Tasks" --key-col "ID" --key "TASK-42" \
  --set '{"Status":"Complete"}' --dry-run

# 3. Apply if dry-run looks correct
sheets-cli update key --sheet "Tasks" --key-col "ID" --key "TASK-42" \
  --set '{"Status":"Complete"}'

Commands

Command	Description
`sheets find`	Find spreadsheet by name
`sheets list`	List tabs in spreadsheet
`read table`	Read table with headers
`update key`	Update row by key column
`update index`	Update row by index
`append`	Add new row
`batch`	Multiple operations

Guidelines

Always read before writing to understand current state
Use key-based updates (rows can shift)
Dry-run before applying changes
Use JSON format for values
Specify spreadsheet by ID or URL

Notes

Pre-installed and available in PATH
Supports batch operations for efficiency
Key-column updates are safer than index-based

Source: gmickel/sheets-cli

---name: sheets-clidescription: Google Sheets CLI---# Google Sheets CLIRead, write, and update Google Sheets data via CLI with primitives for tables, rows, and cells.## Prerequisites- `sheets-cli` installed and in PATH- Google Sheets API credentials configured## Instructions### Quick Reference```bash# Find spreadsheet by namesheets-cli sheets find --name "Projects"# List sheets/tabssheets-cli sheets list --spreadsheet <id-or-url># Read table datasheets-cli read table --spreadsheet <id> --sheet "Sheet1" --limit 100# Update by key column (preferred - rows can shift)sheets-cli update key --spreadsheet <id> --sheet "Projects" \ --key-col "Name" --key "Acme" --set '{"Status":"Done"}'# Append rowsheets-cli append --spreadsheet <id> --sheet "Projects" \ --values '{"Name":"NewCo","Status":"Active"}'```### Workflow PatternAlways follow **read → decide → dry-run → apply**:```bash# 1. Understand current statesheets-cli read table --sheet "Tasks" --limit 100# 2. Dry-run firstsheets-cli update key --sheet "Tasks" --key-col "ID" --key "TASK-42" \ --set '{"Status":"Complete"}' --dry-run# 3. Apply if dry-run looks correctsheets-cli update key --sheet "Tasks" --key-col "ID" --key "TASK-42" \ --set '{"Status":"Complete"}'```### Commands| Command | Description ||---------|-------------|| `sheets find` | Find spreadsheet by name || `sheets list` | List tabs in spreadsheet || `read table` | Read table with headers || `update key` | Update row by key column || `update index` | Update row by index || `append` | Add new row || `batch` | Multiple operations |## Guidelines1. Always read before writing to understand current state2. Use key-based updates (rows can shift)3. Dry-run before applying changes4. Use JSON format for values5. Specify spreadsheet by ID or URL## Notes- Pre-installed and available in PATH- Supports batch operations for efficiency- Key-column updates are safer than index-basedSource: gmickel/sheets-cli

Frequently asked questions

Sheets CLI