Index of every page on this site: llms.txt
All skills
googleworkspace avatar

/gws-sheets-append

@cd3697e
by Google Workspacegoogleworkspace/cli32k stars
1,997
Run it yourself

Google Sheets: Append a row to a spreadsheet.

Use this Skill: https://skilld.dev/gh/googleworkspace/cli/gws-sheets-append

Nothing lands on disk. Nothing to clean up.

Fork this Skill

Edit a local copy. It keeps the author and licence.

SKILL.md

≈16 tokens for metadata: the name and description. ≈333 when used: this file.

How this Skill uses context

Before choosing a Skill, your Agent reads its name and description. All available Skills share that space.

In our Claude Code example, all Skill names and descriptions share 8,000 characters. This Skill uses ≈65 characters, or 0.8%.

Your model, settings, and other Skills decide how much text your Agent can read.

Example settings and source

The example uses a 200k-token context and default Claude Code settings. The count includes the name, description, separators, and when_to_use when present. Codex also counts local file paths.

Skit's source and limits: Codex 0.160.1, Claude Code 2.1.292.

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

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

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

Source: SKILL.md on GitHub

skilld matched fixed text patterns in SKILL.md and file names. Patterns miss obfuscated code.

skilld run checks every file with the same patterns. It asks for approval before it loads a Skill with a behavior marked Needs approval.

No alerts2mo5 checks · Risk SAFE
  • Gen Agent Trust Hub2mo

    The skill provides instructions for appending rows to Google Sheets using the vendor-specific gws CLI. It is generally safe but carries a minor risk of indirect prompt injection due to the handling of external data.

  • Socket2mo

    No alerts

  • Snyk2mo

    Risk: LOW · No issues

  • Runlayer8mo

    1 file scanned · No issues

  • ZeroLeaks7mo

    Score: 93/100 · 2 sections analyzed

Signed by skilld at cd3697e. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub 3 weeks ago.

Activeupdated 8 months ago
Other metadata
metadata
{
  "version": "0.22.5",
  "openclaw": {
    "category": "productivity",
    "requires": {
      "bins": [
        "gws"
      ]
    },
    "cliHelp": "gws sheets +append --help"
  }
}
  • CLI
  • google-sheets
  • google-workspace
  • append
  • spreadsheet
  • gws

README badge

README badge for googleworkspace/cli/gws-sheets-append

Appends one or more rows to a Google Sheet via the gws CLI, supporting both single-row and bulk multi-row inserts with optional sheet tab targeting. Use this skill when you need to programmatically add data to a specific spreadsheet by ID.

Generated from the current SKILL.md.

Does this require Google Workspace authentication?
Yes. You must complete the auth setup in gws-shared/SKILL.md before using this skill.
Can I append to a specific sheet tab instead of the default sheet?
Yes. Use the --range flag with the sheet name, e.g. --range "Sheet2!A1" to append to a different tab.
What's the difference between --values and --json-values?
--values appends a single row of comma-separated strings; --json-values appends multiple rows using a JSON array format like [["a","b"],["c","d"]].
Is this a destructive operation?
Yes. This is a write command that modifies the spreadsheet, so you should confirm with the user before executing it.

Generated from the current SKILL.md. These answers refresh after source changes.