Skip to main content
affpapa.org
RU EN
skill Claude Code CX Codex Cursor GitHub Copilot official · Google

gws-sheets-append — Claude Code skill

This skill appends rows to Google Sheets through the gws CLI. Use it when an agent needs to write structured results into a spreadsheet.

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓ 
npx skills add googleworkspace/cli --skill gws-sheets-append -a claude-code
Open on GitHub

What gws-sheets-append does

gws-sheets-append adds one or more rows to Google Sheets with gws sheets +append. Simple values go through --values; --json-values accepts a JSON array of rows. Use --range to target a specific tab, such as Sheet2!A1.

The command requires the gws binary and the shared gws-shared skill for authentication, global flags, and security rules. The default target range is A1, which selects the first sheet. This is a write operation, so the agent should confirm with the user before running it.

Install it when your coding agent needs to append table data from the command line. Choose gws-sheets as well when the workflow needs other spreadsheet operations.

What it helps with

  • append a row to Google Sheets
  • insert multiple rows from a JSON array
  • write data to a selected sheet tab
  • send agent results to a spreadsheet through the CLI

Example prompts for the agent

  • Append `Alice,100,true` to the spreadsheet with `gws sheets +append`.
  • Use `--json-values` to insert these rows into Google Sheets.
  • Append the data to `Sheet2` with the range `Sheet2!A1`.

How to install gws-sheets-append

1Skills CLI (Vercel)

npx skills add googleworkspace/cli --skill gws-sheets-append -a claude-code

2Manually: put the files in place

~/.claude/skills/gws-sheets-append/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/gws-sheets-append/

From the same set95

The whole set →
gws-gmail official googleworkspace This skill hands your agent Gmail: send mail, read the inbox, reply in a thread. Useful when email work already runs through the gws CLI. Claude Code CX Codex Cursor +1 81,900installs gws-gmail-send official googleworkspace A skill that teaches your agent to send Gmail from the terminal: recipients, subject, body, attachments and drafts. Claude Code CX Codex Cursor +1 74,700installs gws-drive official googleworkspace This skill hands your agent Google Drive through the gws CLI: files, folders, shared drives, comments and access requests. Useful when docs move through code. Claude Code CX Codex Cursor +1 74,500installs gws-shared official googleworkspace This skill gives agents shared rules for gws CLI authentication, flags, and output formats. Use it when working with gws commands. Claude Code CX Codex Cursor +1 66,000installs gws-calendar official googleworkspace Manage Google Calendar events, access rules, and schedules through the gws CLI tool. Claude Code CX Codex Cursor +1 61,100installs gws-sheets official googleworkspace This skill lets an agent read and edit Google Sheets through the CLI. Use it when a coding workflow needs spreadsheet data or table updates. Claude Code CX Codex Cursor +1 58,800installs gws-docs official googleworkspace This skill lets an agent read and update Google Docs through gws. Use it when document changes should happen from an agent chat. Claude Code CX Codex Cursor +1 58,300installs gws-sheets-read official googleworkspace Reads cell values and sheets from Google Spreadsheets via CLI. Useful when an agent needs spreadsheet data without risk of altering it. Claude Code CX Codex Cursor +1 50,600installs

Similar

analytics coreyhaines31 Helps design tracking plans, implement events for GA4, GTM, Mixpanel, or Segment, and audit data collection accuracy. Claude Code CX Codex Cursor +1 83,700installs attribution coreyhaines31 Works out which channel actually drives conversions and revenue, picks an attribution model, and reconciles numbers that disagree across tools. Claude Code CX Codex Cursor +1 38,000installs notion openclaw This skill connects an agent to Notion through the ntn CLI and API, for reading and editing pages, querying data sources, and uploading files. Claude Code CX Codex Cursor +1 5,600installs songsee openclaw Turns an audio file into a spectrogram or a feature panel with mel, chroma, MFCC and more. Useful when you want to see a track instead of just hearing it. Claude Code CX Codex Cursor +1 5,100installs xlsx official anthropics Creates, reads, edits, and converts spreadsheet files. Use it when the requested deliverable is an Excel workbook or another tabular file. Claude Code Claude.ai 187,223installs google-agents-cli-observability official Google This skill guides you through tracing and monitoring AI agents, including ADK agents. Use it when you need to inspect agent execution or monitor a deployed agent. Claude Code CX Codex Cursor +1 509,900installs caveman-evidence-review JuliusBrussee A read-only skill reviews Caveman Cloud evidence on LLM spend, traces, and routing. Use it to see where a project’s model budget goes. Claude Code CX Codex Cursor +1 103,500installs migration JuliusBrussee Enforces reversible, compatibility-safe transitions for schema, data, and API updates. Useful whenever data loss or rollout downtime is unacceptable. Claude Code CX Codex Cursor +1 102,900installs

Questions about gws-sheets-append

How do I install gws-sheets-append in Claude Code?

Run npx skills add googleworkspace/cli --skill gws-sheets-append -a claude-code. The skill file will be placed at ~/.claude/skills/gws-sheets-append/SKILL.md.

What does gws-sheets-append do?

It appends rows to Google Sheets through gws sheets +append. The skill supports simple values, JSON row arrays, and a selected sheet tab through an A1 range.

When should I use `--values` or `--json-values`?

Use --values for a simple single-row append such as Alice,100. Use --json-values when you need to insert multiple rows as a JSON array.

Source text

SKILL.md · Apache-2.0 
---
name: gws-sheets-append
description: "Google Sheets: Append a row to a spreadsheet."
metadata:
  version: 0.22.5
  openclaw:
    category: "productivity"
    requires:
      bins:
        - gws
    cliHelp: "gws sheets +append --help"
---

# sheets +append

> **PREREQUISITE:** Read `../gws-shared/SKILL.md` for auth, global flags, and security rules. If missing, run `gws generate-skills` to create it.

Append a row to a spreadsheet

## Usage

```bash
gws sheets +append --spreadsheet <ID>
```

## Flags

| Flag | Required | Default | Description |
|------|----------|---------|-------------|
| `--spreadsheet` | ✓ | — | Spreadsheet ID |
| `--values` | — | — | Comma-separated values (simple strings) |
| `--json-values` | — | — | JSON array of rows, e.g. '[["a","b"],["c","d"]]' |
| `--range` | — | `A1` | Target range in A1 notation (e.g. 'Sheet2!A1') to select a specific tab |

## Examples

```bash
gws sheets +append --spreadsheet ID --values 'Alice,100,true'
gws sheets +append --spreadsheet ID --json-values '[["a","b"],["c","d"]]'
gws sheets +append --spreadsheet ID --range "Sheet2!A1" --values 'Alice,100'
```

## Tips

- Use --values for simple single-row appends.
- Use --json-values for bulk multi-row inserts.
- Use --range to append to a specific sheet tab (default: A1, i.e. first sheet).

> [!CAUTION]
> This is a **write** command — confirm with the user before executing.

## See Also

- [gws-shared](../gws-shared/SKILL.md) — Global flags and auth
- [gws-sheets](../gws-sheets/SKILL.md) — All read and write spreadsheets commands

© googleworkspace · Apache-2.0 · googleworkspace/cli

See also

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor