# Manage Google Sheets with the gws CLI

Google Sheets API commands can be difficult to discover and structure correctly. This skill guides Claude and Codex through supported gws resources, methods, and flags.

## Install

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

## Metadata

- Status: approved
- Slug: googleworkspace-gws-sheets
- Version: 0.23.0
- Author version: 0.23.0
- Skillstore revision: r2
- Version status: valid
- Tree hash: 362ffe83e434ea4d225787b8d8686300507abe6eb67ed2da69befd544874634e
- Author: googleworkspace
- GitHub username: googleworkspace
- License: MIT
- Repository: https://github.com/googleworkspace/cli/tree/main/skills/gws-sheets/
- 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, network, filesystem
- Quality score: 82
- Quality tier: silver
- Public page: https://skillstore.pages.dev/skills/googleworkspace-gws-sheets
- Manifest: https://skillstore.pages.dev/api/skills/googleworkspace-gws-sheets/manifest

## Capabilities

- Discover Google Sheets resources and methods through gws help commands.
- Inspect required parameters, types, and defaults with gws schema.
- Create spreadsheets through the Sheets API.
- Retrieve spreadsheets by identifier or data filter.
- Apply validated spreadsheet updates with batchUpdate.
- Direct users to helper skills for reading values and appending rows.

## Use Cases

- Inspect spreadsheet data: Find the correct read command and parameters for a known spreadsheet.
- Create operational spreadsheets: Build a new spreadsheet and verify the returned spreadsheet details.
- Automate structured updates: Inspect batchUpdate requirements before applying multiple validated changes.

## Prompt Templates

### List available Sheets commands

```
Show the gws command that lists Google Sheets resources and methods. Explain what I should inspect next.
```

### Read a spreadsheet range

```
Help me read {range} from spreadsheet {spreadsheet_id}. Inspect the method schema before preparing the command.
```

### Create a spreadsheet

```
Prepare a gws command to create a spreadsheet named {title}. Verify required parameters and explain the expected result.
```

### Plan a batch update

```
Inspect the batchUpdate schema for spreadsheet {spreadsheet_id}. Prepare validated changes for {update_goal} and identify any atomic failure risks.
```

## Limitations

- Requires the gws CLI and its generated shared authentication skill.
- Requires valid Google Workspace credentials and permission for each target spreadsheet.
- Provides command guidance but does not document every method parameter.
- Spreadsheet changes remain subject to Google Sheets API validation and quotas.

## Best Practices

- Inspect each method schema before building params or request bodies.
- Use the narrowest spreadsheet range, field mask, or data filter needed.
- Confirm the spreadsheet identifier and update intent before write operations.

## Anti Patterns

- Do not guess parameter names or request shapes without schema inspection.
- Do not request complete grid data when selected fields are sufficient.
- Do not submit batch updates before validating every included request.

## Security Audit

- Audited at: 2026-08-05T11:24:08.73\+00:00
- Summary: All 23 static alerts are false positives caused by Markdown formatting, fixed documentation links, and legitimate gws CLI examples. No prompt injection, malicious command construction, unauthorized network code, or exploitable path traversal is present in SKILL.md.

## Stats

- Views: 115
- Downloads: 11
- Favorites: 0
- Popularity score: 0