---
name: gws-sheets
version: 1.0.0
description: "Google Sheets: Read and write spreadsheets."
metadata:
  openclaw:
    category: "productivity"
    requires:
      bins: ["gws"]
    cliHelp: "gws sheets --help"
---

# sheets (v4)

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

```bash
gws sheets <resource> <method> [flags]
```

## Helper Commands

| Command                                    | Description                    |
| ------------------------------------------ | ------------------------------ |
| [`+append`](../gws-sheets-append/SKILL.md) | Append a row to a spreadsheet  |
| [`+read`](../gws-sheets-read/SKILL.md)     | Read values from a spreadsheet |

## API Resources

### spreadsheets

- `batchUpdate` — Applies one or more updates to the spreadsheet.
- `create` — Creates a spreadsheet, returning the newly created spreadsheet.
- `get` — Returns the spreadsheet at the given ID. Use `fields` parameter or `includeGridData` to include grid data.
- `getByDataFilter` — Returns the spreadsheet filtered by data filters.
- `developerMetadata` — Operations on the 'developerMetadata' resource
- `sheets` — Operations on the 'sheets' resource
- `values` — Operations on the 'values' resource

## Discovering Commands

Before calling any API method, inspect it:

```bash
# Browse resources and methods
gws sheets --help

# Inspect a method's required params, types, and defaults
gws schema sheets.<resource>.<method>
```

Use `gws schema` output to build your `--params` and `--json` flags.
