What are the API rate limits for Google Sheets automation?

Google Sheets enforces limits of approximately 60 reads and 60 writes per minute. The skill recommends batch operations to optimize performance.

Does this skill support bulk data updates?

Yes, it utilizes GOOGLESHEETS_BATCH_UPDATE and GOOGLESHEETS_BATCH_GET to efficiently handle multiple ranges and stay within API limits.

Can I format cells with specific colors and styles?

Absolutely. The skill supports formatting via GOOGLESHEETS_FORMAT_CELL, allowing you to set bold, italics, font sizes, and background colors using RGB floats.

What is an 'upsert' in the context of Google Sheets?

An upsert operation checks for an existing unique key (like an Email or SKU) in a column; if it exists, the row is updated; if not, a new row is appended.

How do I connect my Google account to this skill?

You must use the RUBE_MANAGE_CONNECTIONS tool with the 'googlesheets' toolkit. Claude will provide an OAuth link for you to authorize the connection.

Google Sheets Automation

Name: Google Sheets Automation
Author: davepoon

bydavepoon

•

2,589

•

生産性とワークフロー

Automates Google Sheets workflows including data manipulation, formatting, and spreadsheet management via Rube MCP.

This skill enables Claude to programmatically interact with Google Sheets using the Rube MCP (Composio) toolkit. It allows for complex data operations such as reading and writing to specific ranges, appending rows, and performing 'upserts' based on unique keys. Beyond simple data entry, it supports advanced spreadsheet management like creating new tabs, applying cell formatting (colors, fonts), and managing filters. It is ideal for developers and business users looking to sync CRM data, generate reports, or automate administrative spreadsheet tasks directly within their coding environment.

主な機能

01Manage spreadsheet structure by creating, renaming, and reordering tabs

02Apply professional cell formatting including colors, bolding, and font sizes

03Read and write data using A1 notation with batch operation support

04Search and filter specific rows or values across large datasets

052,589 GitHub stars

06Perform intelligent row upserts using unique key columns to prevent duplicates

ユースケース

01Automating the generation and formatting of weekly business performance reports

02Synchronizing application data or CRM records with a centralized Google Sheet

03Bulk updating inventory or product lists using key-based row lookups

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add davepoon/buildwithclaude googlesheets-automation

For use in Claude.ai and ChatGPT

Download Skill