Google Sheets
This skill lets you interact with and manipulate data within Google Sheets, streamlining spreadsheet tasks and analysis.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add sanjay3290-google-sheets npx -- -y @trustedskills/sanjay3290-google-sheets
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"sanjay3290-google-sheets": {
"command": "npx",
"args": [
"-y",
"@trustedskills/sanjay3290-google-sheets"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill allows AI agents to interact with and manipulate data stored in Google Sheets. It can read, write, update, and delete data within specified spreadsheets and ranges. The agent can also perform calculations and format cells based on instructions provided through prompts.
When to use it
- Automated Reporting: Generate reports by pulling data from a Google Sheet and formatting it into a specific output (e.g., email body).
- Inventory Management: Update inventory levels in a spreadsheet when sales are recorded or new stock is received.
- Data Entry Automation: Populate a Google Sheet with information extracted from documents or websites.
- Financial Tracking: Automatically record transactions and update balances within a budget spreadsheet.
Key capabilities
- Read data from Google Sheets
- Write data to Google Sheets
- Update existing data in Google Sheets
- Delete data from Google Sheets
- Perform calculations within cells
- Format cell values
Example prompts
- "Get the sales figures for January from Sheet1."
- "Add a new row to Sheet2 with these details: [customer name], [product], [quantity]."
- "Update the 'Total Cost' column in Sheet3 based on the formula in cell B2."
Tips & gotchas
- Ensure the AI agent has appropriate permissions (access) to the Google Sheets you intend to use.
- Be specific with sheet names and ranges within your prompts for accurate results.
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.