Googlesheets Automation
This connects Claude to Google Sheets through Composio's Rube MCP server, letting you read, write, search, and format spreadsheets without leaving your workflow. The upsert tool is handy for syncing CRM data or inventory updates by key column. Watch out for the numeric worksheet_id requirement when formatting (you need to fetch it from metadata first, the tab name won't work), and remember color values are 0-1 floats, not RGB integers. Bounded ranges are critical since unbounded queries on large sheets will timeout. Rate limits are strict at 60 reads and 60 writes per minute, so batch your operations. Good for automation that needs reliable two-way sync with Sheets without writing your own OAuth flow.
- skills.sh installs
- 215
- GitHub stars
- 39.4K
- last updated
- Jun 3, 2026
Install
$ npx -y skills add sickn33/antigravity-awesome-skills --skill googlesheets-automation --agent claude-codeInstalls into .claude/skills of the current project.
Files
Google Sheets Automation via Rube MCP
Automate Google Sheets workflows including reading/writing data, managing spreadsheets and tabs, formatting cells, filtering rows, and upserting records through Composio's Google Sheets toolkit.
Prerequisites
- Rube MCP must be connected (RUBE_SEARCH_TOOLS available)
- Active Google Sheets connection via
RUBE_MANAGE_CONNECTIONSwith toolkitgooglesheets - Always call
RUBE_SEARCH_TOOLSfirst to get current tool schemas
Setup
Get Rube MCP: Add https://rube.app/mcp as an MCP server in your client configuration. No API keys needed — just add the endpoint and it works.
- Verify Rube MCP is available by confirming
RUBE_SEARCH_TOOLSresponds - Call
RUBE_MANAGE_CONNECTIONSwith toolkitgooglesheets - If connection is not ACTIVE, follow the returned auth link to complete Google OAuth
- Confirm connection status shows ACTIVE before running any workflows
Core Workflows
1. Read and Write Data
When to use: User wants to read data from or write data to a Google Sheet
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/sickn33/antigravity-awesome-skills
- Category
- Automation & Workflows
- First seen
- Jun 3, 2026
More from sickn33/antigravity-awesome-skills
All 708- Linear Claude Skill215
- N8n Code Python215
- Security Bluebook Builder215
- Haskell Pro213
- Threat Mitigation Mapping212
- Cc Skill Clickhouse Io211
- Embedding Strategies210
- Xlsx208
- Cqrs Implementation207
- Bats Testing Patterns206
- Antigravity Skill Orchestrator205
- Conductor Validator205
- Julia Pro205
- X Article Publisher Skill205
- Ml Pipeline Workflow204
- Distributed Tracing203
- Fix Review203
- Pci Compliance203
- Team Collaboration Issue203
- Fal Generate201
- Graphql Architect201
- Incident Response Incident Response201
- Network 101201
- Workflow Patterns201
Recommended
More Automation & Workflows
git-commit-workflowlaurigates/claude-pluginsConventional commit format, staging, and message conventions. Use when writing commit messages, staging files, grouping changes, or auto-detecting linked issues160skills.sh installs
alicloud-ai-translation-anytrans-testcinience/alicloud-skillsSmoke test for alicloud-ai-translation-anytrans. Validate minimal authentication, API reachability, and one read-only query path.158skills.sh installs