Name: Google Sheet API
Author: codedao12

According to AlphaMoat, as of 2026-09, Google Sheet API has 3,296 downloads and 3 stars — ranked #3,439 of 5,078 AI skills overall, and #251 of 435 in Office.

Installs

158

Downloads

3.3K

Stars

Overall Rank

#3,439

Top 68% overall · Top 58% in Office

Platform	Installs	Downloads	Stars	Comments
ClawHub ↗	94	2.9K	3	-
SkillHub ↗	158	3.3K	3	—

Platforms count differently and update at different times.

What this skill does

The CLI supports read/write, append, batch operations, formatting and sheet management with service-account authentication for repeatable automation. It does not use end-user OAuth flows. Clear, deleteSheet and batch operations may change data; restrict service-account access and review writes before execution. Requires Node, reviewed dependencies/lockfile, an enabled Google Sheets API and sharing the target with the service-account email. Prefer explicit credential configuration over automatic file discovery, and keep private keys out of logs.

Profile published 2026-10-27

What you can do with it

Read or update Google Sheets data
Write batches or adjust sheet formatting

When to use it

When the target spreadsheet is shared with a least-privilege service account and writes are reviewed

Example prompts

Generated from the skill’s documentation as examples; not results of actual runs.

Read this range and show the returned data first.

Draft a batch update, but wait for confirmation before writing it.

Monthly Trend

Downloads3.3K

Stars3

The counting method changed in 2026-09: skills with the same name are now counted separately by author, and the full catalog is covered. Dashed lines show months before the change; they are not compared with later months, and no growth is computed across the change.

Month	Downloads	MoM	Stars
2026-09	3.3K	—	3
2026-08	3.0K	+5.9%	3
2026-07	2.8K	+9.6%	3
2026-06	2.5K	+5.6%	3
2026-05	2.4K	—	3
2026-03	2.0K	—	3

SKILL.md (original)

The author’s original file, shown as plain text without edits or review by AlphaMoat. Links are not clickable; check commands before running them. Fetched 2026-10-23.

2.6 KB · ClawHub v1.0.1

---
name: google-sheet-api
description: OpenClaw skill that installs a Google Sheets CLI with setup steps and commands for read/write, batch, formatting, and sheet management.
---

# Google Sheets API Skill (Advanced)

## Purpose
Provide a production-ready Google Sheets CLI for OpenClaw. This skill supports data reads/writes, batch operations, formatting, and sheet management with service account authentication.

Show all (89 lines)

## Best fit
- You need a repeatable CLI for automation tasks.
- You want JSON-in/JSON-out for pipelines.
- You need more than basic read/write (formatting, sheet ops, batch updates).

## Not a fit
- You must use end-user OAuth consent flows (this skill is service-account focused).
- You only need lightweight, one-off edits.

## One-time setup
1. Create or select a Google Cloud project.
2. Enable the Google Sheets API.
3. Create a service account and download its JSON key.
4. Share target spreadsheets with the service account email.

## Install
```bash
cd google-sheet-api
npm install
```

## Run
```bash
node scripts/sheets-cli.js help
node scripts/sheets-cli.js read <spreadsheetId> "Sheet1!A1:C10"
node scripts/sheets-cli.js append <spreadsheetId> "Sheet1!A:B" '@data.json'
```

You can also use npm:
```bash
npm run sheets -- read <spreadsheetId> "Sheet1!A1:C10"
```

## Credentials
Supported sources (first match wins):
- `GOOGLE_SHEETS_CREDENTIALS_JSON` (inline JSON string)
- `GOOGLE_SERVICE_ACCOUNT_KEY` (file path)
- `GOOGLE_SHEETS_KEY_FILE` (file path)
- `GOOGLE_APPLICATION_CREDENTIALS` (file path)
- `./service-account.json`, `./credentials.json`, `./google-service-account.json`
- `~/.config/google-sheets/credentials.json`

## Input conventions
- JSON values can be inline or loaded from file using `@path`.
- Write/append expect a 2D array of values.

Example `data.json`:
```json
[["Name","Score"],["Alice",95]]
```

## Command map (high level)
Data:
- `read`, `write`, `append`, `clear`, `batchGet`, `batchWrite`

Formatting:
- `format`, `getFormat`, `borders`, `merge`, `unmerge`, `copyFormat`

Layout:
- `resize`, `autoResize`, `freeze`

Sheets:
- `create`, `info`, `addSheet`, `deleteSheet`, `renameSheet`

Advanced:
- `batch` (raw `spreadsheets.batchUpdate` requests)

## Operational guidance
- Prefer read-only scope for read workflows when possible.
- Add retry with exponential backoff for `429` and transient `5xx` errors.
- Keep request payloads small to avoid limit issues.

## Expected output
- JSON to stdout; non-zero exit code on errors.

## Security notes
- Never log or commit service account keys.
- Share spreadsheets only with the service account email required by this skill.