Google Sheets Skill

Interact with Google Sheets using a service account.

Setup (One-time)

Google Cloud Console:

- Create/select a project
- Enable "Google Sheets API"
- Create a Service Account (IAM → Service Accounts → Create)
- Download JSON key

Configure credentials (one of these):

- Set env: GOOGLE_SERVICE_ACCOUNT_KEY=/path/to/key.json
- Place service-account.json or credentials.json in the skill directory
- Place in ~/.config/google-sheets/credentials.json

Share sheets with the service account email (found in JSON key as client_email)

Install dependencies:

cd skills/google-sheets && npm install

Usage

node scripts/sheets.js <command> [args]

Commands

Data Operations

Command

Args

Description

read		Read cells
write		Write data
append		Append rows
clear		Clear range

Formatting

Command

Args

Description

format		Format cells
getFormat		Get cell formats
borders	[styleJson]	Add borders
copyFormat		Copy format between ranges
merge		Merge cells
unmerge		Unmerge cells

Layout

Command

Args

Description

resize		Resize columns/rows
autoResize		Auto-fit columns
freeze	[rows] [cols]	Freeze rows/columns

Sheet Management

Command

Args

Description

create