Google Sheets
This skill enables reading, writing, and managing Google Sheets spreadsheets through five tools: sheets:read for extracting cell ranges, sheets:write for updating specific areas, sheets:append for adding rows to tables, sheets:create for establishing new spreadsheets, and sheets:get_metadata for retrieving spreadsheet structure. Use this skill when building workflows that require data storage, retrieval, or manipulation within Google Sheets.
git clone --depth 1 https://github.com/outworked/outworked /tmp/google-sheets && cp -r /tmp/google-sheets/electron/skills/google-sheets ~/.claude/skills/google-sheetsSKILL.md
# Google Sheets Skill
You can read, write, and manage Google Sheets spreadsheets.
## Tools
- **sheets:read** — Read a range of cells (e.g. `Sheet1!A1:D10`)
- **sheets:write** — Write values to a specific range
- **sheets:append** — Append rows to the end of a table
- **sheets:create** — Create a new spreadsheet with custom sheet names
- **sheets:get_metadata** — Get spreadsheet info (sheet names, dimensions)
## Tips
- The `spreadsheetId` is the long ID in the URL: `docs.google.com/spreadsheets/d/{spreadsheetId}/edit`
- Ranges use A1 notation: `Sheet1!A1:D10`, `Sheet1!A:A` (whole column), `Sheet1!1:1` (whole row)
- When writing, `values` is an array of rows: `[["Name", "Age"], ["Alice", 30], ["Bob", 25]]`
- `sheets:append` is best for log-style data — it finds the last row and adds below it
- Use `sheets:get_metadata` first if you don't know the sheet namesBrowse the web, take screenshots, interact with pages, fill forms. Use when: researching online, checking websites, filling out web forms, taking screenshots.
Read, search, send, and manage emails via Gmail API. Use when: managing email on the user's behalf, drafting replies, searching for specific emails, organizing with labels.
View, create, update, and delete Google Calendar events. Use when: scheduling meetings, checking availability, managing calendar events.
Search, read, upload, and share files in Google Drive
Search, read, create, and manage Notion pages and databases
Create and manage scheduled tasks with cron, interval, or one-time execution
Search messages, manage channels, reactions, pins, and users in Slack