nsheaps/sheets
plugins/google-workspace-cli/skills/sheets/SKILL.md
Use this skill when the user asks about reading, writing, or managing Google Sheets data via the Google Workspace CLI. Trigger on spreadsheet tasks like reading cell ranges, updating data, creating sheets, or working with formulas.
$ install --global
skillsauthnpx skillsauth add nsheaps/ai-mktpl 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 22, 2026, 4:10 PM65.8s1 file scanned
SKILL.md
- name:
- sheets
- description:
- >
Google Sheets via Google Workspace CLI
Use gws sheets to interact with Google Sheets from the command line.
Common Operations
Read Data
# Read a range of cells
gws sheets get <spreadsheet-id> --range "Sheet1!A1:D10"
# Read entire sheet
gws sheets get <spreadsheet-id> --range "Sheet1"
# Read as JSON
gws sheets get <spreadsheet-id> --range "Sheet1!A1:D10" --format json
# Read with value render option
gws sheets get <spreadsheet-id> --range "Sheet1!A1:D10" --value-render "FORMATTED_VALUE"
Write Data
# Update a range
gws sheets update <spreadsheet-id> --range "Sheet1!A1" --values '[["Name","Email"],["Alice","[email protected]"]]'
# Append rows to a sheet
gws sheets append <spreadsheet-id> --range "Sheet1!A1" --values '[["Bob","[email protected]"]]'
# Clear a range
gws sheets clear <spreadsheet-id> --range "Sheet1!A1:D10"
Create Spreadsheets
# Create a new spreadsheet
gws sheets create --title "Budget 2026"
# Create with initial sheet names
gws sheets create --title "Budget 2026" --sheets "Q1,Q2,Q3,Q4"
Manage Sheets (Tabs)
# List sheets in a spreadsheet
gws sheets list <spreadsheet-id>
# Add a new sheet
gws sheets add-sheet <spreadsheet-id> --title "New Tab"
# Delete a sheet
gws sheets delete-sheet <spreadsheet-id> --sheet-id <sheet-id>
# Rename a sheet
gws sheets rename-sheet <spreadsheet-id> --sheet-id <sheet-id> --title "Renamed"
Batch Operations
# Batch update multiple ranges
gws sheets batchUpdate <spreadsheet-id> --data '[
{"range": "Sheet1!A1", "values": [["Header1", "Header2"]]},
{"range": "Sheet1!A2", "values": [["Data1", "Data2"]]}
]'
# Batch get multiple ranges
gws sheets batchGet <spreadsheet-id> --ranges "Sheet1!A1:B5,Sheet2!A1:C3"
Value Input Options
| Option | Behavior |
| -------------- | --------------------------------------------------- |
| RAW | Values stored as-is (no parsing) |
| USER_ENTERED | Values parsed as if user typed them (formulas work) |
# Write with formula support
gws sheets update <spreadsheet-id> --range "Sheet1!C1" \
--values '[["=SUM(A1:B1)"]]' --value-input "USER_ENTERED"
Common Patterns
Export to CSV
gws drive files export <spreadsheet-id> --mime-type "text/csv" --output ./data.csv
Read and Process with jq
# Get values as JSON and extract specific column
gws sheets get <spreadsheet-id> --range "Sheet1!A:A" --format json | jq '.[].values[][]'
Tips
- Spreadsheet IDs are in the URL:
docs.google.com/spreadsheets/d/<SPREADSHEET_ID>/edit - Use
A1notation for ranges:Sheet1!A1:D10,Sheet1!A:A(full column),Sheet1(full sheet) - Use
--value-input USER_ENTEREDwhen writing formulas - Use
gws drive files listto find spreadsheets by name
Related Skills
nsheaps/github-app-session-env
tools
VerifiedTrustedCommunity
Manually reproduce what the github-app plugin's SessionStart hook does to make a GitHub App installation token usable in the current session — materialize the PEM, generate the token, isolate GH_CONFIG_DIR, write the runtime env file, and wire CLAUDE_ENV_FILE so every Bash call sees GH_TOKEN/GITHUB_TOKEN. Use when the hook did not run, the token is missing from the environment, or a shell/teammate needs the token wired up by hand. <example>GH_TOKEN isn't set even though github-app is configured</example> <example>the github-app SessionStart hook didn't run, set up the token manually</example> <example>wire the github app token into CLAUDE_ENV_FILE</example> <example>gh keeps falling back to the wrong account, isolate GH_CONFIG_DIR</example>
3SKILL.mdUpdated Jun 9, 2026
nsheaps/github-app-git-identity
tools
VerifiedTrustedCommunity
Manually configure the GitHub App bot git identity the way the github-app plugin's SessionStart hook does — resolve the app slug and bot user ID, build the <slug>[bot] name and noreply email, set GIT_AUTHOR_*/GIT_COMMITTER_* env vars, and write an isolated GIT_CONFIG_GLOBAL with the gh auth git-credential helper. Use when commits are attributed to the wrong account, "Author identity unknown" appears, or git identity must be set up by hand. <example>my commits are showing up as the handler, not the bot</example> <example>git says Author identity unknown after the github-app hook ran</example> <example>configure the github app bot git identity manually</example> <example>set up the gh credential helper for git push</example>
3SKILL.mdUpdated Jun 9, 2026
nsheaps/spec-management
tools
VerifiedTrustedCommunity
Manages spec files for requirements capture and validation
3SKILL.mdUpdated Jun 7, 2026
nsheaps/plugins/bash-command-rejection/skills/bash-chaining-alternatives
tools
VerifiedTrustedCommunity
# Bash Chaining Alternatives This skill teaches you how to work around the bash command chaining restriction enforced by this plugin. ## Why Chaining is Blocked The `bash-command-rejection` plugin blocks these operators: | Operator | Name | Why Blocked | | -------- | ---------- | ----------------------------------------------------------------------------------- | | `&&` | AND chain | Runs cmd2 only if cmd1 su
3SKILL.mdUpdated Jun 7, 2026