excel-automationlisted

# 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](https://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 `RUBE_MANAGE_CONNECTIONS`. --- ## Core Workflows ### 1. Create a New Excel Workbook Use `EXCEL_CREATE_WORKBOOK` to generate a new `.xlsx` file and upload it to OneDrive. **Tool:** `EXCEL_CREATE_WORKBOOK` **Steps:** 1. Call `EXCEL_CREATE_WORKBOOK` 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 `GOOGLESHEETS_BATCH_UPDATE` to write values to a specific range or append rows. **Tool:** `GOOGLESHEETS_BATCH_UPDATE` **Key Parameters:** - `spreadsheet_id` (required) -- The spreadsheet ID from the URL (44-char alphanumeric string) - `sheet_name` (required) -- Tab name, e.g., `"Sheet1"`, `"Sales Data"` - `values` (required) -- 2D array of cell values, e.g., `[["Name","Amount"],["Alice",100]]` - `first_cell_location` -- Starting cell in A1 notation (e.g., `"A1"`, `"D3"`). Omit to a