Google Sheets API Skill (Advanced)

---

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.

Best fit

Not a fit

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

cd google-sheet-api
npm install

Run

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:

npm run sheets -- read <spreadsheetId> "Sheet1!A1:C10"

Credentials

Supported sources (first match wins):

Input conventions

Example `data.json`:

[["Name","Score"],["Alice",95]]

Command map (high level)

Data:

Formatting:

Layout:

Sheets:

Advanced:

Operational guidance

Expected output

Security notes