A production-grade command-line interface for performing advanced read, write, and formatting operations on Google Sheets using service accounts.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install google-sheet-api
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install google-sheet-api using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Google Sheets API CLI?
The google-sheet-api skill is a high-performance CLI designed for developers who need to integrate spreadsheet management into their automation pipelines using Openclaw Skills. Unlike basic tools, this skill is focused on service account authentication, making it ideal for server-to-server interactions and headless environments where user consent flows are impractical. It provides a robust interface for manipulating Google Sheets data with precision and speed.
By utilizing this skill within the Openclaw Skills ecosystem, users can programmatically manage spreadsheet layouts, apply complex formatting, and execute batch updates. It is specifically built for reliability, offering a JSON-centric workflow that fits perfectly into modern DevOps and data engineering stacks.
Google Sheets API CLI Use Cases
- Automating the generation of weekly performance reports directly into shared Google Sheets.
- Building data ingestion pipelines that sync JSON data from external APIs into spreadsheets.
- Programmatically formatting large datasets, including cell merging, border styling, and column resizing.
- Managing spreadsheet architecture by creating, renaming, or deleting sheets based on dynamic triggers.
How Google Sheets API CLI Works
- The skill authenticates with the Google Sheets API using a predefined service account JSON key for secure access.
- Users interact with the skill through a Node.js-based CLI, passing commands such as read, write, or batch.
- Input data is provided as 2D arrays, either directly in the command line or loaded from external JSON files using the @path convention.
- The skill processes the request and communicates with the Google Sheets API, ensuring that all operations within the Openclaw Skills environment are handled efficiently.
- Results and confirmation data are returned as standard JSON to stdout, allowing for easy integration with other tools and scripts.
Google Sheets API CLI Setup
- Create a project in the Google Cloud Console and enable the Google Sheets API.
- Create a Service Account, download the JSON credentials file, and share your target spreadsheets with the service account email address.
- Install the skill dependencies:
cd google-sheet-api
npm install
- Set up your authentication by defining the
GOOGLE_SHEETS_CREDENTIALS_JSONenvironment variable or placing yourcredentials.jsonfile in the project root. - Verify the installation by running the help command:
node scripts/sheets-cli.js help
Google Sheets API CLI Data Schema & Taxonomy
| Feature | Description |
|---|---|
| Input Format | Supports inline JSON or file-based input using the @data.json syntax. |
| Value Structure | Write and Append operations expect a 2D array: [["Row1Col1", "Row1Col2"], ["Row2Col1", "Row2Col2"]]. |
| Authentication | Prioritizes GOOGLE_SHEETS_CREDENTIALS_JSON env var, followed by local file paths like ./service-account.json. |
| Output | All successful operations return JSON to stdout; errors result in a non-zero exit code. |
Google Sheets API CLI Advanced Features
- Batch processing capabilities for executing multiple read or write requests in a single API call to minimize latency.
- Granular layout control including the ability to freeze rows/columns and auto-resize cells.
- Deep formatting support for applying custom borders, colors, and text styles programmatically.
- Flexible input handling that allows Openclaw Skills to pull data dynamically from local environments for spreadsheet updates.
SKILL.md
Loading
Related Openclaw Skills
Facebook Graph API Skill
A production-ready skill designed for automating Facebook Page publishing and comment moderation through direct Graph API HTTPS calls.
ElevenLabs AI Skill
A production-ready skill for integrating ElevenLabs advanced audio APIs directly via HTTPS without requiring an SDK.
Discord Hub Bot API Skill
A production-oriented framework for building Discord bot workflows via REST API and Interactions without heavy SDK dependencies.
Community Mod Pack
An AI-driven moderation assistant designed to summarize community activity and identify potential rule violations without automated enforcement.
Google Sheets API Skill
A production-ready CLI for managing Google Sheets via service accounts, supporting advanced formatting and batch operations.
Meeting to Action
Converts raw meeting transcripts and notes into structured summaries, clear decisions, and actionable follow-up items.
Featured*
