← 返回 Skills 市场
221
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install porteden-sheets-writer
功能描述
Automated Google Sheets Data Writer — Append rows, update cells, and automate spreadsheet data pipelines with a pre-configured target sheet.
安全使用建议
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.
功能分析
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.
能力评估
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.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install porteden-sheets-writer - 安装完成后，直接呼叫该 Skill 的名称或使用
/porteden-sheets-writer触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
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.
元数据
常见问题
Google Sheets File Automation 是什么？
Automated Google Sheets Data Writer — Append rows, update cells, and automate spreadsheet data pipelines with a pre-configured target sheet. 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 221 次。
如何安装 Google Sheets File Automation？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install porteden-sheets-writer」即可一键安装，无需额外配置。
Google Sheets File Automation 是免费的吗？
是的，Google Sheets File Automation 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
Google Sheets File Automation 支持哪些平台？
Google Sheets File Automation 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 Google Sheets File Automation？
由 PortEden（@porteden）开发并维护，当前版本 v1.0.0。
推荐 Skills