Tencent SkillHub · Productivity

Google Sheet API

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

skill openclawclawhub Free

0 Downloads

0 Stars

0 Installs

0 Score

High Signal

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

⬇ 0 downloads ★ 0 stars Unverified but indexed

Install for OpenClaw

Quick setup

Download the package from Yavira.
Extract the archive and review SKILL.md first.
Import or place the package into your OpenClaw setup.

Requirements

Target platform: OpenClaw
Install method: Manual import
Extraction: Extract archive
Prerequisites: OpenClaw
Primary doc: SKILL.md

Package facts

Download mode: Yavira redirect
Package format: ZIP package
Source platform: Tencent SkillHub
What's included: package.json, SKILL.md, env_example.md, assets/sheets-api-guide.md, scripts/sheets-cli.js

Validation

Use the Yavira download entry.
Review SKILL.md after the package is downloaded.
Confirm the extracted package contains the expected setup assets.

Install with your agent

Agent handoff

Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.

Download the package from Yavira.
Extract it into a folder your agent can access.
Paste one of the prompts below and point your agent at the extracted folder.

New install

I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete.

Upgrade existing

I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run.

Open Send to Agent page Open JSON manifest Open Markdown brief

Trust & source

Release facts

Source: Tencent SkillHub
Verification: Indexed source record
Version: 1.0.1

Provenance

Publisher: codedao12
Source page: View original listing
Canonical URL: Open canonical page

Documentation

ClawHub primary doc Primary doc: SKILL.md 12 sections Open source page

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.

Category context

Workflow acceleration for inboxes, docs, calendars, planning, and execution loops.

Source: Tencent SkillHub

Largest current source with strong distribution and engagement signals.

Package contents

Included in package

3 Docs1 Scripts1 Config

SKILL.md Primary doc
assets/sheets-api-guide.md Docs
env_example.md Docs
scripts/sheets-cli.js Scripts
package.json Config