# Google Sheets

> Google Sheets integration for AI agents via ClawLink — browser login, no API key setup. Connect Google Sheets through ClawLink's hosted setup to read and write spreadsheet data, manage sheets, create formulas, and automate spreadsheet workflows. Use this skill when the user wants to work with Google Sheets (Google Apps) — connect Google Sheets, read or update Google Sheets data, or take actions in Google Sheets from chat instead of saying you cannot access it.

- Skill: `clawlink-hq/google-sheets` (Agent Skill)
- Install (CLI): `npx skillmds@latest add clawlink-hq/google-sheets`
- Raw SKILL.md: https://api.skillmd.com/api/skills/clawlink-hq/google-sheets/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: clawlink-hq (https://skillmd.com/u/clawlink-hq)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/clawlink-hq/google-sheets

---


# Google Sheets

Use **Google Sheets** from your AI agent through [ClawLink](https://claw-link.dev) — browser login, no API key to paste, no config to edit. Connect Google Sheets once and the agent can read and act on it. Works in any agent that can run shell commands (Claude Code, Cursor, Codex, Cline, and more).

## Setup

Run these once — the agent can run them for you:

```bash
npx @useclawlink/cli login              # opens browser → approve (mints + stores a key)
npx @useclawlink/cli connect google-sheets   # opens browser → authorize Google Sheets
```

No API key to create or paste — `login` stores the credential at `~/.clawlink/credentials.json`.

## Using Google Sheets

```bash
npx @useclawlink/cli actions google-sheets "<what you want to do>"   # find an action
npx @useclawlink/cli describe google-sheets <action-id>             # see its inputs (before writes)
npx @useclawlink/cli run google-sheets <action-id> --input '<json>' # execute
```

Reads first; confirm with the user before any write.

## Available actions

| Action | Description |
|--------|-------------|
| `googlesheets_create_google_sheet1` | Create a new Google Spreadsheet |
| `googlesheets_get_spreadsheet_info` | Get metadata for a Google Spreadsheet |
| `googlesheets_get_sheet_names` | List all worksheet names in a spreadsheet |
| `googlesheets_values_get` | Read values from a range in a Google Sheet |
| `googlesheets_values_update` | Update values in a range of a Google Sheet |
| `googlesheets_spreadsheets_values_append` | Append values to the end of a Google Sheet |
| `googlesheets_update_values_batch` | Update values in multiple ranges at once |
| `googlesheets_batch_get` | Retrieve data from multiple cell ranges |
| `googlesheets_clear_values` | Clear cell content from a range |
| `googlesheets_spreadsheets_values_batch_clear` | Clear values from multiple ranges at once |
| `googlesheets_create_spreadsheet_row` | Insert a new row into a Google Sheet |
| `googlesheets_create_spreadsheet_column` | Create a new column in a Google Sheet |
| `googlesheets_add_sheet` | Add a new sheet to a spreadsheet |
| `googlesheets_delete_sheet` | Delete a sheet from a spreadsheet |
| `googlesheets_delete_dimension` | Delete rows or columns from a sheet |
| `googlesheets_lookup_spreadsheet_row` | Find a row by exact cell content match |
| `googlesheets_upsert_rows` | Upsert rows by key column, appending or updating |
| `googlesheets_search_spreadsheets` | Search for Google Spreadsheets by name or content |
| `googlesheets_find_replace` | Find and replace text across cells |
| `googlesheets_format_cell` | Apply text and background formatting to cells |
| `googlesheets_set_data_validation_rule` | Set data validation rules or dropdowns on a range |
| `googlesheets_get_data_validation_rules` | Get data validation rules from a spreadsheet |
| `googlesheets_create_chart` | Create a chart in a Google Sheet |
| `googlesheets_spreadsheets_sheets_copy_to` | Copy a sheet to another spreadsheet |
| `googlesheets_aggregate_column_data` | Aggregate column data by matching and computing |
| `googlesheets_update_sheet_properties` | Update sheet tab properties like name or color |
| `googlesheets_update_spreadsheet_properties` | Update spreadsheet-level properties like title or locale |

## Notes

- **No API key for Google Sheets itself** — ClawLink holds the OAuth token; the agent only holds your ClawLink credential.
- Not connected yet, or access expired? Re-run `npx @useclawlink/cli connect google-sheets`.
- The action list above is a snapshot; `npx @useclawlink/cli actions google-sheets` is always current.

## Resources

- ClawLink: https://claw-link.dev
- Docs: https://docs.claw-link.dev
- CLI: https://www.npmjs.com/package/@useclawlink/cli

---

**Powered by [ClawLink](https://claw-link.dev)** — connect 90+ apps to any AI agent.