Is cell formatting supported?

Absolutely. You can apply bold, italics, font sizes, and custom background colors to specific cell ranges using the formatting tools.

Can I update specific rows based on a unique ID?

Yes, the GOOGLESHEETS_UPSERT_ROWS tool allows you to update existing rows or append new ones by matching a specific key column like Email or SKU.

What is the Rube MCP server requirement?

This skill requires the Rube MCP server connected at rube.app/mcp to handle authentication and secure connection management for spreadsheet providers.

How does Claude handle large datasets in spreadsheets?

The skill supports batch updates and recommends chunking large writes (around 500 rows per call) to stay within API rate limits and optimize performance.

Does this skill support both Google Sheets and Microsoft Excel?

Yes, it integrates with Google Sheets via the Google API and Microsoft Excel via OneDrive through the Rube MCP server connection.

Excel & Google Sheets Automation

Name: Excel & Google Sheets Automation
Author: EricGrill

byEricGrill

•

생산성 및 워크플로

Automates complex spreadsheet operations across Microsoft Excel and Google Sheets, including data entry, formatting, and row management.

This skill empowers Claude to interact directly with Microsoft Excel (via OneDrive) and Google Sheets, enabling complex spreadsheet workflows without manual intervention. It provides a robust set of tools for creating workbooks, writing data in batches, upserting rows based on unique keys, and applying professional formatting to cells and ranges. Whether you are syncing CRM data, generating financial reports, or managing inventory, this skill streamlines data management by bridging the gap between AI reasoning and structured spreadsheet environments through the Rube MCP server.

주요 기능

0111 GitHub stars

02Data retrieval and verification to ensure accuracy before updates

03Seamless integration with both Microsoft Excel (OneDrive) and Google Sheets

04Advanced data operations including batch updates and key-based row upserts

05Automated workbook creation and worksheet/tab management

06Dynamic formatting capabilities for headers, colors, and font styles

사용 사례

01Generating formatted financial reports or invoices in Excel via OneDrive

02Batch updating inventory levels or product catalogs from external data sources

03Automated CRM data synchronization and deduplication in Google Sheets

주요 기능

0111 GitHub stars

02Data retrieval and verification to ensure accuracy before updates

03Seamless integration with both Microsoft Excel (OneDrive) and Google Sheets

04Advanced data operations including batch updates and key-based row upserts

05Automated workbook creation and worksheet/tab management

06Dynamic formatting capabilities for headers, colors, and font styles

사용 사례

01Generating formatted financial reports or invoices in Excel via OneDrive

02Batch updating inventory levels or product catalogs from external data sources

03Automated CRM data synchronization and deduplication in Google Sheets