Googlesheets Automation
Skill Verified ActiveAutomate Google Sheets operations (read, write, format, filter, manage spreadsheets) via Rube MCP (Composio). Read/write data, manage tabs, apply formatting, and search rows programmatically.
To automate repetitive Google Sheets tasks, allowing users to efficiently manage their data and workflows through AI.
Features
- Read and write data to Google Sheets
- Manage spreadsheets and tabs
- Apply cell formatting
- Search and filter rows
- Upsert rows by key
- Create new spreadsheets
Use Cases
- Automating data entry and updates in Google Sheets
- Synchronizing data between Google Sheets and other systems
- Programmatically generating reports and dashboards in Google Sheets
- Bulk formatting or cleaning up spreadsheet data
Non-Goals
- Directly interacting with the Google Sheets API without Rube MCP
- Performing complex data analysis beyond filtering and basic operations
- Managing Google Drive file system beyond spreadsheets
Practical Utility
- info:Usage examplesWhile the SKILL.md details tool sequences and parameters, explicit end-to-end, ready-to-use examples with claimed outputs are not provided.
Installation
First, add the marketplace
/plugin marketplace add davepoon/buildwithclaude/plugin install all-skills@buildwithclaudeQuality Score
VerifiedSimilar Extensions
Public Google Drive
100Create public Google Docs or Google Sheet files without requiring OAuth. Use this skill to create and edit Google Docs and Sheets, no Google sign-in required. Documents are viewable at shareable links. Registration is automatic on first use.
X Twitter Scraper
100Use when the user needs X (Twitter) data or confirmation-gated X actions through Xquik: tweet search, user lookup, follower extraction, media download, monitoring, webhooks, MCP, SDKs, posting, likes, DMs, and profile updates. Requires a Xquik API key. Never ask for X login material.
Gmail
100Interact with Gmail - search emails, read messages, send emails, create drafts, and manage labels. Use when user asks to: search email, read email, send email, create email draft, mark as read, archive email, star email, or manage Gmail labels. Lightweight alternative to full Google Workspace MCP server with standalone OAuth authentication.
Context Mode
100Update context-mode from GitHub and fix hooks/settings. Pulls latest, builds, installs, updates npm global, configures hooks. Trigger: /context-mode:ctx-upgrade
Google Sheets
99Read and write Google Sheets spreadsheets - get content, update cells, append rows, fetch specific ranges, search for spreadsheets, and view metadata. Use when user asks to: read a spreadsheet, update cells, add data to Google Sheets, find a spreadsheet, check sheet contents, export spreadsheet data, or get cell values. Lightweight integration with standalone OAuth authentication supporting full read/write access.
Project Session Manager
100Worktree-first dev environment manager for issues, PRs, and features with optional tmux sessions