Google Sheets API

OpenClaw skill that installs a Google Sheets CLI with setup steps and commands for read/write, batch, formatting, and sheet management.

Popular

Join 2,687+ developers using this skill

skill

Integrations

intermediate

2,687 installs

View Source

Last updated: April 29, 2026

AI Skill Market Insights

Real data. Real impact.

Popularity

Top 50%

Growing

Active Users

2,687+

Developers

Quick Start

Manual Installation

No automatic installation available. Please visit the source repository for installation instructions.

View Installation Instructions

TEAR & SHARE

3-5hrs/WK

RISING

2.7K+ USING

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

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

Create or select a Google Cloud project.
Enable the Google Sheets API.
Create a service account and download its JSON key.
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):

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

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

Google Sheets API

AI Skill Market Insights

Quick Start

Manual Installation

TEAR & SHARE

Tags

typesafe-mcp

Be Part of the 2,687+ Developer Community

Google Sheets API Skill (Advanced)

Purpose

Best fit

Not a fit

One-time setup

Install

Run

Credentials

Input conventions

Command map (high level)

Operational guidance

Expected output

Security notes

Upgrade Stripe

README

MCP Apps Builder

jev-mcp (jkudish)

Channels

Learn

Compare

Company

Agents