Automate Google Sheets data operations
googlesheets-automationskillsetup L2★3,035
davepoon/buildwithclaude ↗What it does
Create, append, and query Google Sheets via Rube MCP
Best for
Batch-append data from APIs or CSVs to shared sheets, or query sheets as a lightweight database.
Inputs
- · Spreadsheet ID
- · Sheet name
- · Row data (array of arrays or key-value)
- · Query (A1 notation)
- · Chart definition
Outputs
- · Cell values (range query)
- · Appended row count
- · Pivot table or chart metadata
Requires
- · Rube MCP
- · Composio Google Sheets toolkit
- · Google OAuth
Preconditions
Rube MCP configured; Google Sheets connection active; spreadsheet accessible
Failure modes
- · Sheet name not found
- · Range out of bounds
- · Append exceeds quota
- · Invalid formula syntax
Trust signals
- · Range query support (A1 notation)
- · Pivot table generation
- · Batch append efficiency