Xpersona
agentCLAWHUBUnverified

Google Sheets File Automation

Google Sheets Data Writer. Use when the user wants to append rows, update cells, or automate spreadsheet data pipelines against a pre-configured target sheet. Skill: Google Sheets File Automation Owner: porteden Summary: Google Sheets Data Writer. Use when the user wants to append rows, update cells, or automate spreadsheet data pipelines against a pre-configured target sheet. Tags: latest:1.0.8 Version history: v1.0.8 | 2026-05-29T01:56:33.577Z | user **Added safety guidance and streamlined configuration options.** - Expanded documentation on safety precautions, especiall

OpenClaw
View on ClawHubHomepage

Rank

62

Safety

84

Downloads

1.4k

Updated

Oct 10, 2026

Version

1.0.8

Source

CLAWHUB

About

What it does, and when to use it.

Capability contract not published. No trust telemetry is available yet. 1.4K downloads reported by the source. Last updated 10/10/2026.

Avoid when

  • Contract metadata is missing or unavailable for deterministic execution.

Risk flags: missing_or_unavailable_contract, trust_data_unavailable, schema_references_missing

Public facts

Every fact links back to the source it came from.

Vendor
Clawhubvendor · observed Oct 10, 2026
Protocol compatibility
OpenClawcompatibility · observed Oct 10, 2026
Adoption signal
1.4K downloadsadoption · observed Oct 10, 2026
Latest release
1.0.8release · observed May 29, 2026
Handshake status
UNKNOWNsecurity

Install and run

Setup complexity: low.

clawhub skill install s17bsdgb41z4bpwzdr5zqz5pah83xy13:sheets-writer
  1. Setup complexity is LOW. This package is likely designed for quick installation with minimal external side-effects.
  2. Final validation: Expose the agent to a mock request payload inside a sandbox and trace the network egress before allowing access to real customer data.

Contract: missing

curl -s "https://www.xpersona.co/api/v1/agents/clawhub-porteden-sheets-writer/snapshot"

Documentation

CLAWHUB

19,766 characters of source documentation, loaded on request.

Extracted files

3 files captured from the source.

SKILL.md

---
name: sheets-writer
description: Google Sheets Data Writer. Use when the user wants to append rows, update cells, or automate spreadsheet data pipelines against a pre-configured target sheet.
version: 1.0.8
metadata: {"openclaw":{"emoji":"🤖","homepage":"https://porteden.com","requires":{"bins":["porteden"]},"primaryEnv":"PE_API_KEY","envVars":[{"name":"PE_API_KEY","required":false,"description":"API key; if unset, credentials are read from the system keyring via `porteden auth login`"},{"name":"PE_SHEET_ID","required":false,"description":"Target spreadsheet ID; if unset, the skill finds the sheet by name (see body)"}],"install":[{"id":"brew","kind":"brew","formula":"porteden/tap/porteden","bins":["porteden"],"label":"Install porteden (brew)"},{"id":"go","kind":"go","module":"github.com/porteden/cli/cmd/porteden@latest","bins":["porteden"],"label":"Install porteden (go)"}]}}
---

# porteden sheets-writer

Automate Google Sheets updates with `porteden sheets`. This skill configures a **target spreadsheet** via environment variable so agents can append rows and write data without repeating the file ID. **Use `-jc` flags** for AI-optimized output.

If `porteden` is not installed: `brew install porteden/tap/porteden` (or `go install github.com/porteden/cli/cmd/porteden@latest`).

## Setup

### 1. Authenticate (once)

- **Browser login (recommended):** `porteden auth login` — opens browser, credentials stored in system keyring
- **Direct token:** `porteden auth login --token <key>` — stored in system keyring
- **Verify:** `porteden auth status`
- If `PE_API_KEY` is set in the environment, the CLI uses it automatically (no login needed).
- Drive access requires a token with `driveAccessEnabled: true` and a connected Google account with Drive scopes. Prefer a Google account that only has access to the target spreadsheet/workspace — token authority extends to whatever that account can reach.

### 2. Set the target spreadsheet (one-time)

**If `PE_SHEET_ID` is already set**, skip to step 3 — the target sheet is configured.

**If `PE_SHEET_ID` is not set**, find the spreadsheet by name:

```bash
porteden drive files -q "Q1 Budget" --mime-type application/vnd.google-apps.spreadsheet -jc
```

Copy the `id` field from the result (already provider-prefixed, e.g., `google:1BxiMVs0XRA5...`) and set it:

```bash
export PE_SHEET_ID="google:1BxiMVs0XRA5nFMdKvBdBZjgmU..."
```

To persist across sessions, add to your shell profile (`~/.bashrc`, `~/.zshrc`) or `.env` file. Once set, this step does not need to be repeated.

### 3. Test the connection (one-time)

```bash
porteden sheets info $PE_SHEET_ID -jc
```

Expected: returns spreadsheet title, sheet tabs, and dimensions. If this fails, verify the file ID and that your token has Drive access. Once verified, skip this step in future runs.

## Safety

- **Confirm before destructive writes.** `write` replaces existing cell values and cannot be undone from the CLI. Before any `write` covering more than a single cel

_meta.json

{
  "ownerId": "kn7e5ew0ajkvk0py7e85pv595x81hvh9",
  "slug": "sheets-writer",
  "version": "1.0.8",
  "publishedAt": 1780019793577
}

skill-card.md

## Description:

Google Sheets Data Writer. Use when the user wants to append rows, update cells, or automate spreadsheet data pipelines against a pre-configured target sheet.

This skill is ready for commercial/non-commercial use.

## Publisher:

[porteden](https://clawhub.ai/user/porteden)

### License/Terms of Use:

MIT-0

## Use Case:

Developers and automation agents use this skill to configure PortEden authentication, identify a target Google Sheet, append new rows, update specific cells, and verify spreadsheet writes.

### Deployment Geography for Use:

Global

## Known Risks and Mitigations:

Risk: The PortEden CLI dependency and persisted credentials can access Google Drive resources available to the authenticated account.

Mitigation: Install only from a trusted or reviewed source, use a dedicated Google account or profile limited to the required spreadsheet workspace, and remove persisted credentials when finished.

Risk: Cell write operations can overwrite existing spreadsheet data and cannot be undone from the CLI.

Mitigation: Prefer append for new rows, read target ranges before multi-cell writes, and require explicit confirmation of the range and values before overwriting cells.

Risk: Untrusted values may be interpreted as spreadsheet formulas when written to cells.

Mitigation: Use raw-value writes for user, agent, or external inputs and read the range back after writing to verify the stored values.

## Reference(s):

- [ClawHub skill page](https://clawhub.ai/porteden/skills/sheets-writer)
- [PortEden homepage](https://porteden.com)

## Skill Output:

**Output Type(s):** [Guidance, Shell commands, Configuration, Code]

**Output Format:** [Markdown with inline bash command examples and JSON or CSV value examples]

**Output Parameters:** [1D]

**Other Properties Related to Output:** [Uses compact JSON command output flags for read and info operations when appropriate.]

## Skill Version(s):

1.0.8 (source: frontmatter and release evidence)

## Ethical Considerations:

Users should evaluate whether this skill is appropriate for their environment, review any generated or modified files before relying on them, and apply their organization's safety, security, and compliance requirements before deployment.

Related agents

Same protocol, similar job.

Github ReposUpdated 21h agoRank 70

AionUi

Free, local, open-source 24/7 Cowork app and OpenClaw for Gemini CLI, Claude Code, Codex, OpenCode, Qwen Code, Goose CLI, Auggie, and more | 🌟 Star if you like it!

MCPOPENCLAW
Github ReposUpdated 6mo agoRank 70

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

OPENCLAW
Github ReposUpdated 6mo agoRank 70

cherry-studio

AI productivity studio with smart chat, autonomous agents, and 300+ assistants.

MCPOPENCLAW
Github ReposUpdated 7mo agoRank 70

CopilotKit

The Frontend for Agents & Generative UI. React + Angular

OPENCLAW

Machine-readable data

The same record, as JSON, for agents and crawlers.

{
  "facts": [
    {
      "factKey": "vendor",
      "category": "vendor",
      "label": "Vendor",
      "value": "Clawhub",
      "href": "https://clawhub.ai/porteden/skills/sheets-writer",
      "sourceUrl": "https://clawhub.ai/porteden/skills/sheets-writer",
      "sourceType": "profile",
      "confidence": "medium",
      "observedAt": "2026-10-10T14:31:54.369Z",
      "isPublic": true
    },
    {
      "factKey": "protocols",
      "category": "compatibility",
      "label": "Protocol compatibility",
      "value": "OpenClaw",
      "href": "https://www.xpersona.co/api/v1/agents/clawhub-porteden-sheets-writer/contract",
      "sourceUrl": "https://www.xpersona.co/api/v1/agents/clawhub-porteden-sheets-writer/contract",
      "sourceType": "contract",
      "confidence": "medium",
      "observedAt": "2026-10-10T14:31:54.369Z",
      "isPublic": true
    },
    {
      "factKey": "traction",
      "category": "adoption",
      "label": "Adoption signal",
      "value": "1.4K downloads",
      "href": "https://clawhub.ai/porteden/sheets-writer",
      "sourceUrl": "https://clawhub.ai/porteden/sheets-writer",
      "sourceType": "profile",
      "confidence": "medium",
      "observedAt": "2026-10-10T14:31:54.369Z",
      "isPublic": true
    },
    {
      "factKey": "latest_release",
      "category": "release",
      "label": "Latest release",
      "value": "1.0.8",
      "href": "https://clawhub.ai/porteden/sheets-writer",
      "sourceUrl": "https://clawhub.ai/porteden/sheets-writer",
      "sourceType": "release",
      "confidence": "medium",
      "observedAt": "2026-05-29T01:56:33.577Z",
      "isPublic": true
    },
    {
      "factKey": "handshake_status",
      "category": "security",
      "label": "Handshake status",
      "value": "UNKNOWN",
      "href": "https://www.xpersona.co/api/v1/agents/clawhub-porteden-sheets-writer/trust",
      "sourceUrl": "https://www.xpersona.co/api/v1/agents/clawhub-porteden-sheets-writer/trust",
      "sourceType": "trust",
      "confidence": "medium",
      "observedAt": null,
      "isPublic": true
    }
  ],
  "events": [
    {
      "eventType": "release",
      "title": "Release 1.0.8",
      "description": "**Added safety guidance and streamlined configuration options.** - Expanded documentation on safety precautions, especially around destructive `write` actions and account scoping. - Added explicit confirmation steps before cell-overwriting writes. - Clarified use of a dedicated Google account for minimized access when authenticating. - Updated environment variable handling: `PE_API_KEY` and `PE_SHEET_ID` are now optional; the skill can locate the sheet by name if unset. - Improved metadata and installer information. - General rewording for clarity and concise instructions.",
      "href": "https://clawhub.ai/porteden/sheets-writer",
      "sourceUrl": "https://clawhub.ai/porteden/sheets-writer",
      "sourceType": "release",
      "confidence": "medium",
      "observedAt": "2026-05-29T01:56:33.577Z",
      "isPublic": true
    }
  ]
}

Record generated Oct 10, 2026.

Sponsored

Ads related to Google Sheets File Automation and adjacent AI workflows.