Skills googlesheets-automation
📦

googlesheets-automation

Content revision r2 Medium Risk ⚙️ External commands🌐 Network access

Automate Google Sheets Workflows

Manual spreadsheet updates are slow and error-prone. This skill guides Claude, Codex, and Claude Code through Rube MCP tools for reliable Google Sheets operations.

Supports: Claude Codex Code(CC)
⚠️ 50 Poor

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request
Review the Skillstore skill "googlesheets-automation" from https://skillstore.io/skills/sickn33-googlesheets-automation.md and its manifest at https://skillstore.io/api/skills/sickn33-googlesheets-automation/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.

Your Agent should still show its plan and request any confirmation required by the security policy.

Agent-readable resources

Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.

Markdown detail GET /skills/sickn33-googlesheets-automation.md Signed manifest GET /api/skills/sickn33-googlesheets-automation/manifest Signed lockfile GET /api/skills/sickn33-googlesheets-automation/lockfile

Test it

Using "googlesheets-automation". Read the first 100 rows from the Orders tab and summarize order status.

Expected outcome:

  • Located the requested spreadsheet and Orders tab.
  • Read the bounded range covering the first 100 rows.
  • Returned a status summary without modifying the sheet.

Using "googlesheets-automation". Append three leads to the Leads tab and confirm placement.

Expected outcome:

  • Validated the target tab and column layout.
  • Appended three rows after the existing table.
  • Reported the updated range for verification.

Using "googlesheets-automation". Update inventory rows by SKU and sort low-stock items first.

Expected outcome:

  • Used SKU as the unique key for row updates.
  • Updated matching rows and added missing products.
  • Applied the requested low-stock sorting rule.

Security Audit

Medium Risk
v5 • 7/24/2026 Open versioned report

All 88 external-command alerts are false positives caused by Markdown backticks around tool names, parameters, and examples. The Rube MCP endpoint is a confirmed network dependency that mediates Google Sheets access. Third-party OAuth access and irreversible deletion require clear safeguards.

1
Files scanned
206
Lines analyzed
1
Review items
0
False positives ignored

Confirmed security concerns (2)

Medium
SKILL.md:11SKILL.md:21-25
Third-Party OAuth Data Access
The workflow routes Google Sheets operations through Rube MCP and Composio after Google OAuth authorization.
Lines 11 and 21-25 explicitly identify Composio, configure rube.app, and require Google OAuth.
Medium
SKILL.md:175SKILL.md:195
Unconfirmed Irreversible Spreadsheet Deletion
The skill exposes row and column deletion but does not require explicit user confirmation or a backup.
Lines 175 and 195 explicitly identify the irreversible deletion tool, while no confirmation gate is defined.
Capability review items (1)

These are real local capabilities that may be expected for this skill, so they require review but are not counted as confirmed malicious behavior.

Low
SKILL.md:21
Hardcoded URL
**Get Rube MCP**: Add `https://rube.app/mcp` as an MCP server in your client configuration. No API k
Line 21 directs users to configure the external Rube MCP endpoint. This is an intentional network dependency that can mediate Google Sheets access.

Risk Factors

⚙️ External commands (50)
SKILL.md:16 SKILL.md:17 SKILL.md:21 SKILL.md:23 SKILL.md:24 SKILL.md:35 SKILL.md:36 SKILL.md:37 SKILL.md:38 SKILL.md:39 SKILL.md:40 SKILL.md:43 SKILL.md:44 SKILL.md:45 SKILL.md:46 SKILL.md:47 SKILL.md:48 SKILL.md:52 SKILL.md:53 SKILL.md:55 SKILL.md:62 SKILL.md:63 SKILL.md:64 SKILL.md:65 SKILL.md:66 SKILL.md:69 SKILL.md:70 SKILL.md:71 SKILL.md:72 SKILL.md:77 SKILL.md:78 SKILL.md:85 SKILL.md:86 SKILL.md:87 SKILL.md:88 SKILL.md:91 SKILL.md:92 SKILL.md:93 SKILL.md:94 SKILL.md:95 SKILL.md:96 SKILL.md:99 SKILL.md:108 SKILL.md:111 SKILL.md:112 SKILL.md:113 SKILL.md:114 SKILL.md:115 SKILL.md:116 SKILL.md:119
🌐 Network access (1)
SKILL.md:21
Audited by: codex View Audit History →
Share & cite this report

Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.

Open versioned report
Security Assessment

Copy report link

https://skillstore.io/skills/sickn33-googlesheets-automation/audits/5?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/sickn33-googlesheets-automation/security.svg)](https://skillstore.io/skills/sickn33-googlesheets-automation?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/sickn33-googlesheets-automation?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/sickn33-googlesheets-automation/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/sickn33-googlesheets-automation.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>
Academic citations (APA · BibTeX · CFF)

APA citation

sickn33. (2026). googlesheets-automation security audit report (audit version 5) [Author version unspecified]. Skillstore. https://skillstore.io/skills/sickn33-googlesheets-automation/audits/5

BibTeX citation

@techreport{sickn33-sickn33-googlesheets-automation-2026, author = {sickn33}, title = {googlesheets-automation security audit report (audit version 5)}, institution = {Skillstore}, year = {2026}, number = {5}, url = {https://skillstore.io/skills/sickn33-googlesheets-automation/audits/5}, note = {Author version unspecified} }

CITATION.cff

cff-version: 1.2.0 message: "If you use this Skill, cite its author and this versioned security audit report." title: "googlesheets-automation security audit report (audit version 5)" version: "unspecified" type: report authors: - name: "sickn33" date-released: "2026-07-24" url: "https://skillstore.io/skills/sickn33-googlesheets-automation/audits/5" identifiers: - type: other value: "skillstore:sickn33-googlesheets-automation:audit:5" description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: High
55
Architecture
85
Maintainability
85
Content
69
Community
83
Spec Compliance

What You Can Build

Refresh Operations Reports

Read source tabs, append new records, and update recurring operational reports.

Synchronize Customer Records

Upsert customer rows by email or another unique header while preserving existing records.

Maintain Inventory Sheets

Update product rows, apply filters, and format stock reports for routine review.

Try These Prompts

Read a Sheet Range 
Find the spreadsheet named [name]. Read [tab and bounded range], then summarize the rows without changing the sheet.
Append New Records 
Append these records to [spreadsheet and tab]. Verify the headers and report the updated range after writing.
Create a Structured Workbook 
Create a spreadsheet named [name] with tabs [tabs]. Add headers, freeze the first row, and format each header range.
Upsert and Validate a Dataset 
Upsert [records] into [sheet] using [key header]. Read the affected bounded range, verify changes, and apply [filter or sort].

Best Practices

  • Read the target range and verify tab names before writing.
  • Use bounded ranges and batch operations to reduce timeouts and rate-limit errors.
  • Confirm keys, headers, and affected ranges before upserts or destructive changes.

Avoid

  • Do not use unbounded ranges on large spreadsheets.
  • Do not use column letters as upsert key headers.
  • Do not delete rows or columns without explicit confirmation.

Frequently Asked Questions

What setup is required?
Configure the Rube MCP endpoint and complete Google OAuth for the target account.
Can this skill create spreadsheets?
Yes. It can create spreadsheets, add tabs, and update worksheet properties.
Can it edit existing spreadsheets?
Yes. It can read and modify spreadsheets available to the connected Google account.
How does row upserting work?
It matches an actual header value, updates matching rows, and appends records without matches.
How are large sheets handled?
Use bounded ranges and batch tools to reduce timeouts and Google Sheets rate-limit errors.
Can it delete rows or columns?
Yes, but deletion is irreversible. Review the target bounds and require explicit confirmation first.

Developer Details

Author

sickn33

License

MIT

Skillstore revision

r2

Version notice

The author did not declare a version.

Repository

https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/googlesheets-automation

Ref

88a8e9a07f4c54ab105c1c41b6267c287146b07b

Maintenance freshness

7/26/2026

Usage

9 downloads · 138 views

File structure

📄 SKILL.md