# Append Rows to Google Sheets

Manual spreadsheet entry is slow and inconsistent. This skill appends simple or structured rows to a selected Google Sheets range through gws.

## Install

```bash
npx skillstore add googleworkspace/gws-sheets-append
```

## Metadata

- Status: approved
- Slug: googleworkspace-gws-sheets-append
- Version: 0.23.0
- Author version: 0.23.0
- Skillstore revision: r2
- Version status: valid
- Tree hash: 7176093a30b081eda3935490f79ce2b92d0ee561a80a4f2013da5c6bb6004d11
- Author: googleworkspace
- GitHub username: googleworkspace
- License: MIT
- Repository: https://github.com/googleworkspace/cli/tree/main/skills/gws-sheets-append/
- Ref: 286d37c9c189ddd1aafd3548415fb031d1df79d5
- Supported tools: Claude, Codex, Claude Code
- Audit status: complete
- Agent install advisory: allowed
- Manual install advisory: allowed
- Artifact signature: available
- Audit attestation: unavailable
- Human verification: not\_verified
- Risk factors: external\_commands, filesystem
- Quality score: 80
- Quality tier: silver
- Public page: https://skillstore.pages.dev/skills/googleworkspace-gws-sheets-append
- Manifest: https://skillstore.pages.dev/api/skills/googleworkspace-gws-sheets-append/manifest

## Capabilities

- Appends one row using comma-separated values.
- Appends multiple rows using structured JSON values.
- Selects the destination spreadsheet by its identifier.
- Targets a sheet tab or range with A1 notation.
- Requests user confirmation before executing the write command.

## Use Cases

- Record Sales Leads: Append a confirmed lead record to a shared tracking spreadsheet.
- Add Research Results: Insert several collected observations into a designated worksheet range.
- Log Project Updates: Add dated status entries to a team reporting sheet.

## Prompt Templates

### Append One Row

```
Append these values to spreadsheet [ID]: [values]. Ask for confirmation before writing.
```

### Choose a Sheet Tab

```
Append [values] to range [Sheet2!A1] in spreadsheet [ID]. Confirm the destination and values first.
```

### Append Multiple Rows

```
Append these rows to spreadsheet [ID]: [rows]. Validate their column count and ask for confirmation.
```

### Prepare a Verified Batch

```
Review [rows] for consistent columns, target [range] in spreadsheet [ID], summarize the write, then request confirmation before appending.
```

## Limitations

- Requires the gws command-line tool and its shared authentication guidance.
- Requires permission to write to the selected Google spreadsheet.
- Does not document reading, updating, formatting, or deleting existing cells.
- Comma-separated input is intended for simple strings; structured input is needed for bulk rows.

## Best Practices

- Verify the spreadsheet identifier, target range, and row values before confirmation.
- Use structured values for multiple rows or values containing commas.
- Confirm that every row has the expected number and order of columns.

## Anti Patterns

- Do not execute a write without explicit user confirmation.
- Do not place sensitive data in a spreadsheet without checking access permissions.
- Do not use simple comma-separated values for complex or ambiguous data.

## Security Audit

- Audited at: 2026-08-05T11:26:40.17\+00:00
- Summary: All static findings are false positives caused by Markdown code formatting or fixed links to sibling skill documentation. No prompt injection, data exfiltration intent, or unsafe user-controlled path handling was found.

## Stats

- Views: 84
- Downloads: 9
- Favorites: 0
- Popularity score: 0