Excel Automation

Excel Automation - Excel and Google Sheets Automation Skills

Skill Overview

Excel Automation is a spreadsheet automation skill implemented via Rube MCP. It supports creating workbooks, managing worksheets, reading and writing cell data, and formatting Microsoft Excel and Google Sheets spreadsheets.

Use Cases

1. CRM Data Synchronization and Inventory Management

Using the GOOGLESHEETS_UPSERT_ROWS tool, you can automatically update existing data or append new records based on key columns (such as Email, SKU). This enables CRM customer information synchronization, inventory status updates, and other business scenarios while avoiding duplicate data.

2. Bulk Report Generation and Data Entry

Using EXCEL_CREATE_WORKBOOK or GOOGLESHEETS_BATCH_UPDATE, you can quickly create standardized business reports and write hundreds or thousands of rows of data into specified cell ranges. This is suitable for scenarios where tables need to be generated regularly, such as financial reports and sales summaries.

3. Automated Spreadsheet Formatting

Using GOOGLESHEETS_FORMAT_CELL to automatically apply formatting such as bold titles, font size, and background color. Combined with data-writing operations, it supports an end-to-end report generation workflow, including creating new worksheet tabs and setting header styles.

Core Features

Workbook and Worksheet Management

Supports creating new .xlsx workbooks and uploading them to OneDrive, or adding new worksheet tabs to existing Google Sheets. By using GOOGLESHEETS_GET_SHEET_NAMES and GOOGLESHEETS_FIND_WORKSHEET_BY_TITLE, you can verify whether a worksheet already exists to prevent duplicate creation.

Data Read/Write and Updates

Provides GOOGLESHEETS_BATCH_UPDATE for bulk cell data writing, GOOGLESHEETS_UPSERT_ROWS for intelligently updating or appending rows based on key columns, and GOOGLESHEETS_BATCH_GET for reading data from a specified range for validation and further processing.

Cell Formatting

Uses GOOGLESHEETS_FORMAT_CELL to apply text formatting (bold, italic, font size) and background color to a specified cell range. Supports A1 notation and RGB color settings (0.0–1.0 floating-point numbers).

Common Issues

What dependencies are required for the Excel Automation skill?

This skill requires a Rube MCP server connection to https://rube.app/mcp, and ensures that the excel and optional googlesheets tool packages have established active connections. Before first use, initialize the connection via RUBE_MANAGE_CONNECTIONS.

How do I fix the HTTP 403 error when creating a Google Sheets file?

An HTTP 403 error is usually caused by missing Drive creation permissions. Solutions include reusing an existing spreadsheetId, or using EXCEL_CREATE_WORKBOOK as an alternative to generate a local .xlsx file and upload it to OneDrive.

What are the usage limits of Excel Automation?

Google Sheets has a limit of about 5 million cells per single sheet. Writing too frequently may trigger HTTP 429 rate limiting. It’s recommended to perform batch operations and split large files into chunks (about 500 rows per batch). When formatting, ensure RGB colors use 0.0–1.0 floating-point values instead of 0–255 integers. Since worksheet titles may not be unique, it’s recommended to prioritize the numeric sheetId for identifying worksheets.