← Back to Skills Marketplace
221
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install porteden-sheets-writer
Description
Automated Google Sheets Data Writer — Append rows, update cells, and automate spreadsheet data pipelines with a pre-configured target sheet.
Usage Guidance
This skill appears coherent, but before installing: 1) Verify you trust the 'porteden' project and the Homebrew tap or GitHub module (confirm the repo and release integrity). 2) Limit the API key's permissions (grant only what the CLI needs; ensure Drive/Sheets scopes are narrow). 3) Prefer browser-based auth (system keyring) over placing PE_API_KEY in shell profiles or .env if you want less secret exposure. 4) If you must store PE_SHEET_ID in shell startup files, be aware those files are readable by processes that can read your environment. 5) After testing, rotate or revoke the token if you no longer use the skill. If you want a deeper check, provide the Homebrew formula URL or the GitHub repo contents so they can be audited for unexpected behavior.
Capability Analysis
Type: OpenClaw Skill
Name: porteden-sheets-writer
Version: 1.0.0
The skill is a legitimate integration for the Porteden CLI to automate Google Sheets operations. It provides clear instructions for authentication, searching for files, and writing data using the `porteden` binary. No malicious patterns, such as unauthorized data access, exfiltration, or harmful prompt injection, were identified in SKILL.md or _meta.json.
Capability Assessment
Purpose & Capability
The name/description (Google Sheets writer) match the declared requirements: a porteden CLI binary, PE_API_KEY (primary credential) and PE_SHEET_ID. These are exactly what a CLI-based Sheets automation tool would need.
Instruction Scope
SKILL.md contains direct CLI instructions for authenticating, locating a spreadsheet, reading, writing, and appending ranges. It does not instruct the agent to read unrelated system files or other secrets. It does recommend persisting PE_SHEET_ID in shell profiles or using system keyring for tokens — standard for a CLI tool but user-visible and explicit.
Install Mechanism
Install options are a Homebrew formula (porteden/tap/porteden) or a Go 'go install' module matching github.com/porteden/cli. Both are typical installation methods for a CLI and are proportionate to the skill's stated needs. No arbitrary downloads or unknown short URLs are used.
Credentials
Requested environment variables (PE_API_KEY as primary, PE_SHEET_ID and optional PE_PROFILE/PE_FORMAT/etc.) align with the functionality. The skill requires Drive access scopes for Google tokens (documented). It does not request unrelated credentials or system secrets.
Persistence & Privilege
The skill is not always-enabled and does not request elevated platform privileges. It stores tokens in the system keyring (per SKILL.md), which is a normal behavior for CLIs. Model invocation remains allowed (default), which is expected for an invocable skill.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install porteden-sheets-writer - After installation, invoke the skill by name or use
/porteden-sheets-writer - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
- Initial release of the porteden-sheets-writer skill.
- Automates appending rows and updating cells in a pre-configured Google Sheet via the `porteden` CLI.
- Supports authentication with browser login or API key, and easy target sheet configuration using environment variables.
- Includes commands for appending from JSON/CSV, updating specific cells, and verifying writes.
- Provides best practices for safe automation and guidance on range formats and environment variable usage.
Metadata
Frequently Asked Questions
What is Google Sheets File Automation?
Automated Google Sheets Data Writer — Append rows, update cells, and automate spreadsheet data pipelines with a pre-configured target sheet. It is an AI Agent Skill for Claude Code / OpenClaw, with 221 downloads so far.
How do I install Google Sheets File Automation?
Run "/install porteden-sheets-writer" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Google Sheets File Automation free?
Yes, Google Sheets File Automation is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Google Sheets File Automation support?
Google Sheets File Automation is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Google Sheets File Automation?
It is built and maintained by PortEden (@porteden); the current version is v1.0.0.
More Skills