--- name: google-sheets description: Read, write, append, and manage Google Sheets via the Google Sheets API (Node.js SDK). Use when you need to interact with spreadsheets — reading data, writing/updating cells, appending rows, clearing ranges, formatting cells, managing sheets. Requires a Google Cloud service account with Sheets API enabled. ---

Google Sheets Skill

Interact with Google Sheets using a service account.

Setup (One-time)

1. Google Cloud Console:

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

1. 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

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

1. Install dependencies:

```bash 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 |