# Automate Google Sheets Workflows

Manual spreadsheet updates are slow and error-prone. This skill guides Claude, Codex, and Claude Code through Rube MCP tools for reliable Google Sheets operations.

## Install

```bash
npx skillstore add sickn33/googlesheets-automation
```

## Metadata

- Status: approved
- Slug: sickn33-googlesheets-automation
- Skillstore revision: r2
- Version status: missing
- Tree hash: fe0a2baa45084034d6c8839fa86d64242d146c3e19214514babc75484b240ed5
- Author: sickn33
- GitHub username: sickn33
- License: MIT
- Repository: https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/googlesheets-automation
- Ref: 88a8e9a07f4c54ab105c1c41b6267c287146b07b
- 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
- Quality score: 50
- Quality tier: warning
- Public page: https://skillstore.pages.dev/skills/sickn33-googlesheets-automation
- Manifest: https://skillstore.pages.dev/api/skills/sickn33-googlesheets-automation/manifest

## Capabilities

- Search spreadsheets and list available tabs.
- Read bounded ranges and handle empty results.
- Update ranges, append records, and upsert rows by a key column.
- Create spreadsheets and manage worksheet properties.
- Apply filters, sorting, cell formatting, and value clearing.

## Use Cases

- Refresh Operations Reports: Read source tabs, append new records, and update recurring operational reports.
- Synchronize Customer Records: Upsert customer rows by email or another unique header while preserving existing records.
- Maintain Inventory Sheets: Update product rows, apply filters, and format stock reports for routine review.

## Prompt Templates

### Read a Sheet Range

```
Find the spreadsheet named [name]. Read [tab and bounded range], then summarize the rows without changing the sheet.
```

### Append New Records

```
Append these records to [spreadsheet and tab]. Verify the headers and report the updated range after writing.
```

### Create a Structured Workbook

```
Create a spreadsheet named [name] with tabs [tabs]. Add headers, freeze the first row, and format each header range.
```

### Upsert and Validate a Dataset

```
Upsert [records] into [sheet] using [key header]. Read the affected bounded range, verify changes, and apply [filter or sort].
```

## Limitations

- Requires Rube MCP and an active Google OAuth connection.
- Can access only spreadsheets permitted by the connected Google account.
- Large or unbounded ranges can time out or exceed Google Sheets rate limits.
- Row and column deletion is irreversible and needs careful confirmation.

## Best Practices

- Read the target range and verify tab names before writing.
- Use bounded ranges and batch operations to reduce timeouts and rate-limit errors.
- Confirm keys, headers, and affected ranges before upserts or destructive changes.

## Anti Patterns

- Do not use unbounded ranges on large spreadsheets.
- Do not use column letters as upsert key headers.
- Do not delete rows or columns without explicit confirmation.

## Security Audit

- Audited at: 2026-07-24T00:45:26.111\+00:00
- Summary: All 88 external-command alerts are false positives caused by Markdown backticks around tool names, parameters, and examples. The Rube MCP endpoint is a confirmed network dependency that mediates Google Sheets access. Third-party OAuth access and irreversible deletion require clear safeguards.

## Stats

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