# Zoho Sheet CLI Agent Skill
A comprehensive skill definition for AI agents to create, edit, and analyze spreadsheets via **zs-cli**—the Zoho Sheet command-line interface.
## Overview
This repository contains the agent-ready skill definition for `zs-cli`, enabling AI assistants (Claude, Gemini, and others) to manipulate spreadsheets entirely from the terminal. The skill includes:
- **Mandatory design guidelines** — Zoho Sheet green theme color palette, typography rules, and layout standards
- **Complete command reference** — 100+ commands for file I/O, data manipulation, formatting, pivots, charts, and more
- **Decision trees and patterns** — When to use Tables vs. styled ranges, standard formatting workflows, and best practices
- **Installation scripts** — Easy setup for Claude and Gemini environments
## What You Get
### `SKILL.md`
The main skill definition file (~86 KB) containing:
- **Design Guidelines & Formatting Rules** — Hardcoded color values (Zoho green theme), typography rules, structure and layout rules, and mandatory formatting application order
- **Table vs. Normal Formatting** — Decision matrix to choose between structured Tables and styled ranges
- **Setup Instructions** — Three-step installation (check → npm install → fallback to .zs scripts)
- **Full Command Reference** — Organized by category:
- File operations (`open`, `save`, `close`)
- Worksheet management (`add`, `rename`, `hide`, `reorder`)
- Cell operations (`get`, `set`, `hyperlink`, `note`)
- Row & column management (`insert`, `resize`, `hide`)
- Data operations (`copy`, `move`, `merge`, `sort`, `filter`)
- Table operations (`create`, `rename`, `style`, `options`)
- Pivot tables (full lifecycle: create, filter, group, aggregate, sort)
- Charts (insert, style, customize, position)
- Number formatting (currency, accounting, percentage, date, time, custom)
- Conditional formatting (classic, color scale, data bar rules)
### `get_skill.sh`
Installation script that clones this repository into:
- Claude: `~/.claude/skills/zs-cli`
- Gemini: `~/.gemini/skills/zs-cli`
## Quick Start
### For Agents (Claude / Gemini)
```bash
./get_skill.sh both