Gws Sheets
Gws Sheets automates Google Sheets tasks like data extraction & manipulation, streamlining workflows and boosting productivity within your Workspace.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add gws-sheets npx -- -y @trustedskills/gws-sheets
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"gws-sheets": {
"command": "npx",
"args": [
"-y",
"@trustedskills/gws-sheets"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
The gws-sheets skill enables AI agents to interact with Google Sheets, allowing them to read from and write to spreadsheets programmatically. It supports operations like retrieving data, updating cells, formatting rows, and managing sheet structures.
When to use it
- Automating data entry or updates in a shared team spreadsheet.
- Generating reports by pulling data from multiple sheets and compiling results.
- Syncing external data sources with Google Sheets for real-time tracking.
Key capabilities
- Read and write cell values
- Format rows and columns
- Create, rename, or delete sheets
- Handle range-based operations
Example prompts
- "Update the sales figures in column B of Sheet1 with the latest numbers from this CSV file."
- "Format all cells in row 5 to bold text and light gray background."
- "Create a new sheet called 'Q4 Reports' and copy data from the 'Summary' sheet into it."
Tips & gotchas
- Ensure your AI agent has proper access permissions to the Google Sheets API.
- Be mindful of rate limits when performing high-volume operations on large sheets.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.