A production-ready CLI for managing Google Sheets via service accounts, supporting advanced formatting and batch operations.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install google-sheets-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-sheets-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 Skill?
This Google Sheets API skill provides a robust, professional-grade interface for interacting with spreadsheets directly from your terminal or automated workflows. As a core part of the Openclaw Skills ecosystem, it enables developers to move beyond basic data entry by offering deep control over cell formatting, sheet layout, and high-performance batch operations. Designed specifically for headless environments, this tool leverages service account authentication to ensure seamless integration into CI/CD pipelines and backend services without requiring manual user consent.
Google Sheets API Skill Use Cases
- Automating the export of pipeline results and analytics to shared team spreadsheets.
- Managing inventory or product data at scale using batch update operations.
- Generating formatted financial reports with custom borders, frozen rows, and merged cells.
- Synchronizing local JSON-based data sources with cloud-based Google Sheets for collaborative editing.
- Clearing or restructuring sheets as part of a scheduled data maintenance routine.
How Google Sheets API Skill Works
- The skill begins by resolving authentication credentials through environment variables or local JSON key files.
- You provide commands to the CLI specifying the target spreadsheet ID and the desired range or operation.
- Input data is accepted either as inline JSON or loaded from external files using the @-prefix convention.
- The tool translates these commands into Google Sheets API requests, handling the underlying JSON transformations.
- Results from the API are returned to stdout in a structured JSON format, allowing for further processing in shell scripts.
Google Sheets API Skill Setup
To get started with this skill in the Openclaw Skills framework, follow these steps:
- Enable the Google Sheets API in your Google Cloud Project.
- Create a service account and download the JSON key file.
- Share your target spreadsheets with the service account's email address.
- Install the skill dependencies:
cd google-sheet-api
npm install
- Run a test command to verify connectivity:
export GOOGLE_APPLICATION_CREDENTIALS='./path/to/key.json'
node scripts/sheets-cli.js info <your_spreadsheet_id>
Google Sheets API Skill Data Schema & Taxonomy
The skill utilizes standard JSON structures for data exchange, ensuring compatibility with most data pipelines.
| Input Type | Format | Description |
|---|---|---|
| Data Arrays | 2D Array | A list of lists representing rows and columns, e.g., [["A1", "B1"], ["A2", "B2"]]. |
| Credentials | JSON Key | Standard Google Service Account JSON file structure. |
| File Loading | @path String | Use @data.json to load payload content from a local file. |
| API Output | JSON Object | The raw response from the Google Sheets API is returned to stdout. |
Google Sheets API Skill Advanced Features
- Comprehensive formatting suite including cell borders, merging, unmerging, and alignment controls.
- Batch processing capabilities for
batchGetandbatchWriteto minimize API latency and handle large datasets. - Automatic layout management including column resizing, auto-resizing, and row freezing.
- Flexible sheet management allowing for the programmatic creation, renaming, and deletion of individual sheets within a workbook.
- Multi-source credential resolution supporting multiple environment variables and default local file paths for easier deployment.
SKILL.md
Loading
Related Openclaw Skills
Google Sheets API CLI
A production-grade command-line interface for performing advanced read, write, and formatting operations on Google Sheets using service accounts.
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.
Meeting to Action
Converts raw meeting transcripts and notes into structured summaries, clear decisions, and actionable follow-up items.
Facebook Messenger API Skill
A professional toolkit for integrating Facebook Messenger Platform workflows, including bot-style messaging and secure webhook handling.
Featured*
