Name: Google Sheets API
Author: codedao12

According to AlphaMoat, as of 2026-09, Google Sheets API has 4,259 downloads and 4 stars — ranked #2,324 of 5,078 AI skills overall, and #196 of 435 in Office.

Installs

126

Downloads

4.3K

Stars

Overall Rank

#2,324

Top 46% overall · Top 46% in Office

Platform	Installs	Downloads	Stars	Comments
ClawHub ↗	126	3.9K	4	-
SkillHub ↗	126	4.3K	4	—

Platforms count differently and update at different times.

What this skill does

It supports reads, writes, appends, batch operations, formatting, and sheet management, and can use JSON data in command-line pipelines. Write, clear, delete-sheet, and raw batch commands can change or remove data; test them on non-production spreadsheets first and grant access only to the intended sheets. Never log or commit service-account keys.

Profile published 2026-10-29

What you can do with it

Read a spreadsheet range and organize JSON output
Plan a batch update or formatting change

When to use it

When the service account has only the required spreadsheet access and the read or write scope is clear

Example prompts

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

Draft a command to read a specified spreadsheet range without executing it.

Prepare a safety checklist for a batch update, including target range, backup, and credential handling.

Monthly Trend

Downloads4.3K

Stars4

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	4.3K	—	4
2026-08	3.8K	+5.3%	4
2026-07	3.6K	+7.8%	4
2026-06	3.4K	+4.8%	4
2026-05	3.2K	—	4

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

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