Open Skills Logo
Open Skills

googlesheets-automation

Automate Google Sheets operations (read, write, format, filter, manage spreadsheets) via Rube MCP (Composio). Read/write data, manage tabs, apply formatting, and search rows programmatically.

Author

@sickn33

Category

Office Automation

Install

Hot:7

Download and extract to your skills directory

Copy command and send to OpenClaw for auto-install:

Download and install this skill https://openskills.cc/api/download?slug=sickn33-skills-googlesheets-automation&locale=en&source=copy

Google Sheets Automation - A Complete Solution for Automated Spreadsheet Operations

Skills Overview

Google Sheets Automation is a spreadsheet automation tool powered by Rube MCP (Composio). It lets you programmatically read and write data, manage worksheets, apply formatting, search and filter rows, and update records in bulk—without the need to configure any API keys for quick integration.

Use Cases

  • CRM Data Synchronization - Automatically sync customer relationship management data to Google Sheets. Supports de-duplication and updates based on a unique key (e.g., email, SKU) to avoid duplicate records.

  • Inventory and Order Management - Bulk import product data, update inventory information in real time, automatically format price and status columns, and quickly locate specific items using filtering.

  • Automated Report Generation - Periodically extract information from data sources and write it to sheets, set header row formatting, freeze the first row, apply conditional styles, and generate business reports that are easy to read.

    • Core Features

  • Bulk Read/Write Data - Supports reading multiple cell ranges at once, bulk writing 2D array data, appending new rows to the end of a sheet, and updating cell contents within a specified range.

  • Spreadsheet and Worksheet Management - Create new spreadsheets, add or rename worksheet tabs, set frozen rows and column widths, hide or reorder worksheets—fully control the spreadsheet structure.

  • Smart Search and Upsert - Precisely find matching rows based on cell contents, apply filtering and sorting rules, and automatically determine whether to update or insert records based on unique keys for intelligent data synchronization.

    • Common Questions

    How do I connect Google Sheets using Rube MCP?

    Just add https://rube.app/mcp as the MCP server in your client configuration—no API keys required. After connecting, call RUBE_MANAGE_CONNECTIONS to select the googlesheets tool package, then complete Google OAuth authorization to start using it.

    Does Google Sheets Automation have rate limits?

    Yes. The Google Sheets API limits you to a maximum of 60 reads and 60 writes per minute. It’s recommended to use batch operations tools (such as BATCH_GET and BATCH_UPDATE) to improve efficiency and avoid triggering limits.

    What types of formatting operations are supported?

    Supported operations include setting font weight (bold), italics, underline, strikethrough, adjusting font size, and setting background color (using 0.0–1.0 floating-point numbers to represent RGB channels). Formatting requires using the numeric sheet ID obtained from the sheet metadata, not the tab name.

      Google Sheets Automation - Rube MCP Spreadsheet Automation Tool - Open Skills