beam-ai-team/google-sheets
skills/integrations/google/google-sheets/SKILL.md
Read and write Google Sheets data. Load when user mentions 'google sheets', 'spreadsheet', 'update sheet', 'read sheet', 'append to sheet', or references extracting data to update a tracking sheet.
development
Updated May 13, 2026
$ install --global
skillsauthnpx skillsauth add beam-ai-team/beam-next-skills google-sheetsInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: May 13, 2026, 3:56 AM147.3s2 files scanned
SKILL.md
- name:
- google-sheets
- type:
- skill
- version:
- 1.2
- description:
- Read and write Google Sheets data. Load when user mentions 'google sheets',
- author:
- Fredrik Falk
- category:
- integrations
- platform:
- Google Workspace
- updated:
- 2026-02-24
- visibility:
- public
Google Sheets
Read, write, and manage Google Sheets via OAuth authentication.
Pre-Flight Check (ALWAYS FIRST)
uv run python 00-system/skills/google/google-master/scripts/google_auth.py --check --service sheets
Exit codes:
- 0: Ready - proceed with user's request
- 1: Need login - run
python3 00-system/skills/google/google-master/scripts/google_auth.py --login - 2: Missing deps - see ../google-master/references/setup-guide.md
Quick Reference
Read Data
uv run python 00-system/skills/google/google-sheets/scripts/sheets_operations.py read <spreadsheet_id> "Sheet1!A1:D10"
Write Data
uv run python 00-system/skills/google/google-sheets/scripts/sheets_operations.py write <spreadsheet_id> "Sheet1!A1" --values '[["Name", "Amount"], ["Contract A", 5000]]'
Append Rows
uv run python 00-system/skills/google/google-sheets/scripts/sheets_operations.py append <spreadsheet_id> "Sheet1!A:D" --values '[["New Row", "Data", "Here", "Now"]]'
Get Sheet Info
uv run python 00-system/skills/google/google-sheets/scripts/sheets_operations.py info <spreadsheet_id>
List Spreadsheets
uv run python 00-system/skills/google/google-sheets/scripts/sheets_operations.py list --query "tracking"
Create Spreadsheet
uv run python 00-system/skills/google/google-sheets/scripts/sheets_operations.py create "New Spreadsheet" --sheets "Data" "Summary"
Common Workflows
Extract Data -> Update Sheet
from sheets_operations import append_rows
data = [
["Contract A", "2024-01-15", 5000, "Active"],
["Contract B", "2024-02-01", 7500, "Pending"]
]
result = append_rows(spreadsheet_id, "Contracts!A:D", data)
print(f"Added {result['updated_rows']} rows")
Batch Update Multiple Cells
from sheets_operations import batch_update
data = [
{"range": "Sheet1!A1", "values": [["Header 1"]]},
{"range": "Sheet1!B1", "values": [["Header 2"]]},
]
batch_update(spreadsheet_id, data)
Spreadsheet ID
The spreadsheet ID is in the URL:
https://docs.google.com/spreadsheets/d/[SPREADSHEET_ID]/edit
A1 Notation
| Example | Meaning |
|---------|---------|
| A1 | Single cell |
| A1:B5 | Range from A1 to B5 |
| Sheet1!A1:B5 | Range in specific sheet |
| A:A | Entire column A |
| 1:1 | Entire row 1 |
Available Operations
| Operation | Function | Description |
|-----------|----------|-------------|
| Read | read_range() | Read data from range |
| Write | write_range() | Write data to range |
| Append | append_rows() | Append rows to sheet |
| Clear | clear_range() | Clear values (keep formatting) |
| Batch | batch_update() | Update multiple ranges |
| Create | create_spreadsheet() | Create new spreadsheet |
| Info | get_spreadsheet_info() | Get metadata and sheets |
| List | list_spreadsheets() | List accessible spreadsheets |
Error Handling
See ../google-master/references/error-handling.md for common errors and solutions.
Setup
First-time setup: ../google-master/references/setup-guide.md
Quick start:
pip install google-auth google-auth-oauthlib google-api-python-client- Create OAuth credentials in Google Cloud Console (enable Google Sheets API & Drive API, choose "Desktop app")
- Add to
.envfile at Beam Next root:GOOGLE_CLIENT_ID=your-client-id.apps.googleusercontent.com GOOGLE_CLIENT_SECRET=your-client-secret GOOGLE_PROJECT_ID=your-project-id - Run
python3 00-system/skills/google/google-master/scripts/google_auth.py --login
Related Skills
beam-ai-team/skills/general/taste-skill
development
VerifiedTrustedCommunity
--- name: taste-skill type: skill version: '1.0' author: Leonxlnx (packaged by Zhichao Li) category: general tags: - frontend - design - anti-slop - landing-page updated: '2026-06-11' visibility: public description: Anti-slop frontend skill for landing pages, portfolios, and redesigns. The agent reads the brief, infers the right design direction, and ships interfaces that do not look templated. Real design systems when applicable, audit-first on redesigns, strict pre-flight check. license: MIT.
SKILL.mdUpdated Jun 12, 2026
beam-ai-team/numbers
development
VerifiedTrustedCommunity
Use when communicating quantitative information in any form — Slack updates, emails, reports, decks, dashboards, landing pages, product UI, public talks. Covers two integrated layers: (1) making numbers semantically meaningful (translation, anchoring, simplification, story-pairing) and (2) showing numbers cleanly (chart vs table vs prose, chart-by-message, pre-attentive emphasis, color discipline, decluttering). Distilled and integrated from *Show Me the Numbers* (Stephen Few) and *Make Numbers Count* (Chip Heath & Karla Starr). Not for raw data analysis or statistics — this is about communication of numbers, not their derivation.
SKILL.mdUpdated Jun 12, 2026
beam-ai-team/impeccable
development
VerifiedTrustedCommunity
Use when the user wants to design, redesign, shape, critique, audit, polish, clarify, distill, harden, optimize, adapt, animate, colorize, extract, or otherwise improve a frontend interface. Covers websites, landing pages, dashboards, product UI, app shells, components, forms, settings, onboarding, and empty states. Handles UX review, visual hierarchy, information architecture, cognitive load, accessibility, performance, responsive behavior, theming, anti-patterns, typography, fonts, spacing, layout, alignment, color, motion, micro-interactions, UX copy, error states, edge cases, i18n, and reusable design systems or tokens. Also use for bland designs that need to become bolder or more delightful, loud designs that should become quieter, live browser iteration on UI elements, or ambitious visual effects that should feel technically extraordinary. Not for backend-only or non-UI tasks.
SKILL.mdUpdated Jun 12, 2026
beam-ai-team/beam-teach
tools
VerifiedTrustedCommunity
Stateful multi-session tutor adapted for Beam — teach a stakeholder to understand, trust, and operate a specific agent, or teach a Solution Engineer a client's business process for delivery. Grounds every lesson in Knowledge Hub sources (real agent graphs, real tasks, transcripts, Linear) before any web resource. Also works for any general topic. Trigger on "teach me", "beam teach", "教我", "onboard <person> on <agent>", "help <stakeholder> understand the agent", "learn this client's process".
SKILL.mdUpdated Jun 12, 2026