Skills/Composio App Automation/Claude Skill/Source: Composio Awesome Claude Skills

Excel Automation

Excel Automation: create workbooks, manage worksheets, read/write cell data, and format spreadsheets via Microsoft Excel and Google Sheets integration

View on GitHub Source Website

Overview

Automate spreadsheet operations including creating workbooks, writing data, formatting cells, upserting rows, and managing worksheets. Works with Microsoft Excel (OneDrive) and Google Sheets.

Core features

Tool Slug

Description

EXCEL_CREATE_WORKBOOK

Create a new .xlsx workbook and upload to OneDrive

GOOGLESHEETS_BATCH_UPDATE

Write values to a range or append new rows

GOOGLESHEETS_UPSERT_ROWS

Update existing rows by key or append new ones

GOOGLESHEETS_FORMAT_CELL

Apply text/background formatting to cell ranges

GOOGLESHEETS_ADD_SHEET

Add a new worksheet tab to a spreadsheet

GOOGLESHEETS_CREATE_GOOGLE_SHEET1

Create a new Google Spreadsheet in Drive

GOOGLESHEETS_GET_SHEET_NAMES

List all worksheet names in a spreadsheet

Target users

AI builders and operators who want Claude, Codex, Cursor, Gemini CLI, or similar agents to automate Excel workflows through Composio.

How to use

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. ---

Effect review

Best for agent workflows that need real app actions with explicit tool discovery, connection checks, and schema-aware execution.

Frequently asked questions

What is Excel Automation?

Excel Automation: create workbooks, manage worksheets, read/write cell data, and format spreadsheets via Microsoft Excel and Google Sheets integration

How do I use Excel Automation?

What does this skill require?

It requires Rube MCP and an active Composio connection for the Excel toolkit before executing app actions.

Quick install

Install command

Add https://rube.app/mcp as an MCP server.
RUBE_MANAGE_CONNECTIONS toolkits: ["excel"]
RUBE_SEARCH_TOOLS before every workflow, then execute with RUBE_MULTI_EXECUTE_TOOL.