abdullahbeam/google-sheets
00-system/skills/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.
$ install --global
skillsauthnpx skillsauth add abdullahbeam/nexus-design-abdullah 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: Apr 1, 2026, 1:37 AM55.7s2 files scanned
SKILL.md
- name:
- google-sheets
- description:
- 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.
- version:
- 1.2
Google Sheets
Read, write, and manage Google Sheets via OAuth authentication.
Pre-Flight Check (ALWAYS FIRST)
python3 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
python3 00-system/skills/google/google-sheets/scripts/sheets_operations.py read <spreadsheet_id> "Sheet1!A1:D10"
Write Data
python3 00-system/skills/google/google-sheets/scripts/sheets_operations.py write <spreadsheet_id> "Sheet1!A1" --values '[["Name", "Amount"], ["Contract A", 5000]]'
Append Rows
python3 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
python3 00-system/skills/google/google-sheets/scripts/sheets_operations.py info <spreadsheet_id>
List Spreadsheets
python3 00-system/skills/google/google-sheets/scripts/sheets_operations.py list --query "tracking"
Create Spreadsheet
python3 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 Nexus 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
abdullahbeam/mental-models
development
VerifiedTrustedCommunity
Load when user says "mental model", "think through this", "structured thinking", "help me decide", "analyze this problem", "first principles", "pre-mortem", "stakeholder mapping", "what framework should I use", or any specific model name. Provides 59 thinking frameworks for decision-making, problem decomposition, and strategic analysis.
2SKILL.mdUpdated Mar 30, 2026
abdullahbeam/generate-philosophy-doc
development
VerifiedTrustedCommunity
Generate comprehensive philosophy and standards documents for any domain (UX design, landing pages, email outbound, API design, etc.). Load when user says "create philosophy doc", "generate standards for [domain]", "build best practices guide", or "create benchmarking document". Conducts deep research, synthesizes findings, and produces structured philosophy documents with principles, frameworks, anti-patterns, checklists, case studies, and metrics.
2SKILL.mdUpdated Mar 30, 2026
abdullahbeam/validate-system
development
VerifiedTrustedCommunity
Validate Nexus-v3 system integrity and fix common issues automatically. Load when user mentions "validate system", "check system", or "fix problems". Runs comprehensive checks on folder structure, metadata files, and framework consistency with auto-repair capabilities.
2SKILL.mdUpdated Mar 30, 2026
abdullahbeam/validate-docs-implementation
development
VerifiedTrustedCommunity
Load when user says "validate docs", "check documentation consistency", "docs vs implementation", or "find documentation mismatches". Systematically compares implementation code against documentation to identify and fix inconsistencies.
2SKILL.mdUpdated Mar 30, 2026