Agent skill · operations · composiohq
Excel Automation
Excel Automation: create workbooks, manage worksheets, read/write cell data, and format spreadsheets via Microsoft Excel and Google Sheets integration
Why this skill is useful
Adds specific commands for automating Excel and Google Sheets operations that the AI wouldn't reliably generate on its own.
What it needs
Requires rube account access. About 4k tokens when loaded. Last updated 2026-07-24. 71,973 stars on the source repository.
What this skill does
Excel Automation Automate spreadsheet operations including creating workbooks, writing data, formatting cells, upserting rows, and managing worksheets. Works with Microsoft Excel (OneDrive) and Google Sheets. Toolkit docs: composio.dev/toolkits/excel --- Setup This skill requires the Rube MCP server connected at https://rube.app/mcp. Before executing any tools, ensure an active connection exists for the excel (and optionally googlesheets) toolkit. If no connection is active, initiate one via RUBEMANAGECONNECTIONS. --- Core Workflows 1. Create a New Excel Workbook Use EXCELCREATEWORKBOOK to generate a new .xlsx file and upload it to OneDrive. Tool: EXCELCREATEWORKBOOK Steps: 1. Call EXCELCREATEWORKBOOK with worksheet names and data 2. The tool creates a .xlsx file and uploads it to OneDrive 3. Use the returned file path/URL for subsequent operations --- 2. Write Data to a Spreadsheet Use GOOGLESHEETSBATCHUPDATE to write values to a specific range or append rows. Tool: GOOGLESHEETSBATCHUPDATE Key Parameters: spreadsheetid (required) -- The spreadsheet ID from the URL (44-char alphanumeric string) sheetname (required) -- Tab name, e.g., "Sheet1", "Sales Data" values (required) -- 2D array of cell values, e.g., [["Name","Amount"],["Alice",100]] firstcelllocation -- Starting cell in A1 notation (e.g., "A1", "D3"). Omit to append rows valueInputOption -- "USERENTERED" (default, parses formulas) or "RAW" (stores as-is) Example: --- 3. Upsert Rows by Key Column Use GOOGLESHEETSUPSERTROWS to update existing rows by matching a key column, or append new rows if no match is found. Ideal for CRM syncs, inventory updates, and deduplication. Tool: GOOGLESHEETSUPSERTROWS Key Parameters: spreadsheetId (required) -- The spreadsheet ID sheetName (required) -- Tab name rows (required) -- 2D array of data rows (min 1 row). …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills composiohq/excel-automation