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.
SkillScore64Maintained
Automatic
◆Data Engineer pack
Last verified 8/28/2026
What it changes
Passed 10 of 16 test cases with the skill, and 7 of 16 without it.
Without skill45%
With skill64%
Checks it passed that the model alone missed
Recommends calling RUBE_SEARCH_TOOLS to retrieve current tool schemas.
Recommends GOOGLESHEETS_FIND_WORKSHEET_BY_TITLE to check tab existence.
Recommends using GOOGLESHEETS_SEARCH_SPREADSHEETS to locate the spreadsheet by title.
and 2 more in the full report
4 fixed10 passed either way8 still failing0 broke
Pass-rate lift
+18 pp
Tokens
+163%
Agent turns
0%
Response time
-30%
Model gemini-3.6-flashMeasured 8/28/2026v1 · latest is v214 of 22 cases passed with skill · 16 comparable
Tokens, turns and time describe resource use, not a dollar price.
This benchmark measured an earlier version of the skill.
See it in action
One of 4 test cases the skill fixed. Same model, same prompt, with and without the skill.
1 of 4
Prompt
I need to update a Google Sheet known only by its title '2024 Budget'. Which tool should be called first to discover its spreadsheet_id?
What was checked, without and with the skill
Checked
Without skill
With skill
Recommends using GOOGLESHEETS_SEARCH_SPREADSHEETS to locate the spreadsheet by title.
Missed
Passed
case-19 · gemini-3.6-flash · 8/28/2026 · answers are capped and redacted
What's inside
The instructions your model reads when the skill loads.
SKILL.md203 linessingle file
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_CONNECTIONS with toolkit googlesheets
Always call RUBE_SEARCH_TOOLS 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.
Verify Rube MCP is available by confirming RUBE_SEARCH_TOOLS responds
Call RUBE_MANAGE_CONNECTIONS with toolkit googlesheets
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
Tool sequence:
GOOGLESHEETS_SEARCH_SPREADSHEETS - Find spreadsheet by name if ID unknown [Prerequisite]
GOOGLESHEETS_GET_SHEET_NAMES - Enumerate tab names to target the right sheet [Prerequisite]
GOOGLESHEETS_BATCH_GET - Read data from one or more ranges [Required]
GOOGLESHEETS_BATCH_UPDATE - Write data to a range or append rows [Required]
GOOGLESHEETS_VALUES_UPDATE - Update a single specific range [Alternative]
GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND - Append rows to end of table [Alternative]
Key parameters:
spreadsheet_id: Alphanumeric ID from the spreadsheet URL (between '/d/' and '/edit')
ranges: A1 notation array (e.g., 'Sheet1!A1:Z1000'); always use bounded ranges
sheet_name: Tab name (case-insensitive matching supported)
values: 2D array where each inner array is a row
first_cell_location: Starting cell in A1 notation (omit to append)
valueInputOption: 'USER_ENTERED' (parsed) or 'RAW' (literal)