What problem does it solve?
This Skill eliminates manual spreadsheet work by enabling programmatic reading, writing, formatting, filtering, and upserting of Google Sheets data through the Rube MCP composio toolkit, reducing repetitive tasks and synchronization errors.
Core Features & Use Cases
- Read & Write Data: Batch read ranges, update ranges, and append rows efficiently to avoid rate limits.
- Manage Sheets & Tabs: Create spreadsheets, add or rename tabs, and adjust sheet properties programmatically.
- Search, Filter & Upsert: Locate rows by key, apply basic filters, and perform upserts to sync CRM or inventory data.
- Formatting & Metadata: Apply cell formats and retrieve numeric worksheet IDs for precise updates.
- Use case: Syncing a CRM export into a master Google Sheet with upserts by email, creating a new tab for unmatched rows and applying header formatting automatically.
Quick Start
Open the spreadsheet "Sales Q1", read Sheet1 rows where column B > 100, and write those rows to a new tab named "Large Sales" with the header row bolded.
