googlesheets-automation

Automate Google Sheets data management and formatting via Rube MCP.

5|2|Updated Jan 24, 2026
One-click install
npx skills add https://github.com/s1366560/agi-demos --skill googlesheets-automation
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: googlesheets-automation
Source: https://github.com/s1366560/agi-demos/tree/main/.memstack/skills/googlesheets-automation
Command: npx skills add https://github.com/s1366560/agi-demos --skill googlesheets-automation

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates repetitive and time-consuming tasks within Google Sheets, allowing users to manage data, format cells, and organize spreadsheets programmatically.

Core Features & Use Cases

  • Data Management: Read, write, append, and upsert data in Google Sheets.
  • Spreadsheet Organization: Create new spreadsheets, add, rename, and manage tabs.
  • Data Analysis: Search and filter rows based on specific criteria.
  • Formatting: Apply cell formatting, including bold, italics, colors, and font sizes.
  • Use Case: Automatically update an inventory sheet by reading a CSV file, matching SKUs, and updating quantities, then formatting the updated rows with a specific color.

Quick Start

Use the googlesheets-automation skill to read data from 'Sheet1' in spreadsheet ID '123abc...' into a CSV file.

Frequently Asked Questions about googlesheets-automation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate reading and writing spreadsheet data in Google Sheets?

Automate Google Sheets operations by reading, writing, appending, and upserting data programmatically. This Skill uses Rube MCP to manage spreadsheets, allowing you to manipulate rows and integrate Google Sheets into automated data workflows.

Can I format cells and manage tabs in Google Sheets programmatically?

Yes, you can format cells and manage tabs programmatically. The Skill applies cell formatting like bold, italics, and colors, and creates, renames, or manages spreadsheet tabs via Rube MCP to organize your data.

Do I need Rube MCP to automate Google Sheets operations?

Yes, Rube MCP is required. You need Rube MCP configured with the googlesheets toolkit and an active Google Sheets connection to execute programmatic data manipulation, filtering, and spreadsheet management tasks.

How do I filter spreadsheet rows and search for specific data in Google Sheets?

Filter spreadsheet rows and search for specific data using the Skill's data analysis features. It searches and filters rows based on specific criteria you define, returning matching data for analysis or workflow automation.

What is the best way to update an inventory sheet from a CSV file?

Update an inventory sheet automatically by reading a CSV file, matching SKUs, and updating quantities in Google Sheets. The Skill then applies specific formatting, like colors, to the updated rows for clear data management.

Are there limitations when using this approach for enterprise data management?

Limitations depend on your Rube MCP configuration and active Google Sheets connection. The Skill automates data manipulation and spreadsheet organization, but complex enterprise workflows may require additional integration setup beyond basic read and write operations.