An AI-optimized CLI utility to securely manage, read, write, and structure Google Sheets databases.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install google-sheets-skill
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-skill 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 porteden-sheets?
The porteden-sheets tool is designed to provide secure, structured, and developer-friendly access to Google Sheets directly from CLI interfaces and agentic environments. As part of the ecosystem of Openclaw Skills, it enables programmatic control over spreadsheet files without exposing insecure credentials, utilizing system keyrings or environment variables for token storage.
With features like AI-optimized output formatting, atomic batch writing, and single-call multi-tab extraction, this skill serves as an ideal database and reporting integration for automated scripts and software agents requiring spreadsheet access.
porteden-sheets Use Cases
- Securely extracting reports and raw data from multiple spreadsheet tabs in a single workflow step.
- Generating and seeding new spreadsheets with local CSV files for dynamic reporting.
- Safely sharing sheets or modifying user permissions automatically through automated pipelines.
- Writing complex updates to multiple ranges atomically to prevent partial database states.
- Managing operational spreadsheets directly from terminal sessions using Openclaw Skills environments.
How porteden-sheets Works
- Authentication: The command uses either the PE_API_KEY environment variable or reads securely stored credentials from the system keyring verified via OAuth.
- Optimization: Commands with -jc flags strip metadata noise and truncate excess cells to compress tokens for downstream processing.
- Execution: The client maps high-level commands (like read, write, append) to Google Sheets API requests, executing operations such as atomic multi-range batch writes.
- Data Handling: Large datasets are automatically clipped with structured markers, returning clear paths for target drilling when datasets exceed standard limits.
porteden-sheets Setup
Install the prerequisite CLI tool first using Homebrew or Go:
# Install via Homebrew
brew install porteden/tap/porteden
# Or install via Go
go install github.com/porteden/cli/cmd/porteden@latest
Configure your authentication session:
# Recommended: interactive browser login
porteden auth login
# Or configure via token
porteden auth login --token <your_token>
# Verify your auth status
porteden auth status
To run non-interactively in production, set the PE_API_KEY environment variable in your Openclaw Skills runtime environment.
porteden-sheets Data Schema & Taxonomy
This tool handles spreadsheet data utilizing specific schema rules and structure types:
| Feature | Parameter / Format | Details |
|---|---|---|
| Resource IDs | google:FILE_ID |
Identifiers must always be prefixed with the provider. |
| Row Limits | 200 rows x 26 columns | Default cap for content command to prevent token bloat. Larger sets are flagged with clipped: true. |
| Batch Writes | Up to 50 ranges / 50,000 cells | Atomic batch update array with keys range and values. |
| CSV Naming | Filename-based Tab Name | Spreadsheets seeded with CSVs name the first tab after the source file, not Sheet1. |
porteden-sheets Advanced Features
- Token-Optimized Formatting: The -jc (--json --compact) flag reduces downstream context size, a key technique for scaling Openclaw Skills.
- Atomic Batch Writes: Execute up to 50 multi-range updates in a single network request to protect database integrity.
- Metadata-Aware Truncation: Automatic calculation of
fullRangelimits allows automated agents to seamlessly paginate overflow tabs. - System Keyring Persistence: Securely stores access tokens locally without exposing plaintext keys in configuration files.
SKILL.md
Loading
Related Openclaw Skills
Deep Researcher
Generate rigorous 30-40 page academic research papers with comprehensive citations using a structured 7-stage AI workflow.
Google Drive Secure Management
A secure CLI tool integration for searching, reading, modifying, copying, and sharing Google Drive files and folders optimized for AI agents.
Uncle Matt's Bot Battle Room
An interactive playground skill for OpenClaw agents to join operator-owned chat rooms, assume unique personas, and engage in tactical banter, alliances, rap battles, and side games.
ClawQueue
ClawQueue turns GitHub Issues and Project Boards into a lightweight, local-first agent task queue for seamless human-agent collaboration.
AI Full-Stack Content Factory
An automated, multi-agent AI pipeline that handles everything from trend scouting and high-quality deep article writing to visual card design and multi-platform publishing.
Google Analytics MCP Server
An AI coding agent skill that enables secure, per-workspace querying of Google Analytics 4 report and property data without global credential sharing.
Australian BAS & GST Advisor
An AI agent skill designed to triage Australian BAS preparation, classify complex GST transactions, and proactively identify tax reporting anomalies.
METADATA
Featured*
