Agent skill · writing content · aiskillstore
googlesheets-automation
Automate Google Sheets operations (read, write, format, filter, manage spreadsheets) via Rube MCP (Composio). Read/write data, manage tabs, apply formatting, and search rows programmatically.
Why this skill is useful
Adds specific commands and workflows for automating Google Sheets operations that the AI wouldn't reliably generate on its own.
What it needs
Requires google-sheets account access. About 6k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
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 (RUBESEARCHTOOLS available) Active Google Sheets connection via RUBEMANAGECONNECTIONS with toolkit googlesheets Always call RUBESEARCHTOOLS first 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. 1. Verify Rube MCP is available by confirming RUBESEARCHTOOLS responds 2. Call RUBEMANAGECONNECTIONS with toolkit googlesheets 3. If connection is not ACTIVE, follow the returned auth link to complete Google OAuth 4. 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 Tool sequence: 1. GOOGLESHEETSSEARCHSPREADSHEETS - Find spreadsheet by name if ID unknown [Prerequisite] 2. GOOGLESHEETSGETSHEETNAMES - Enumerate tab names to target the right sheet [Prerequisite] 3. GOOGLESHEETSBATCHGET - Read data from one or more ranges [Required] 4. GOOGLESHEETSBATCHUPDATE - Write data to a range or append rows [Required] 5. GOOGLESHEETSVALUESUPDATE - Update a single specific range [Alternative] 6. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/googlesheets-automation