spreadsheet-automationTurn Google Sheets into a powerful database and workflow engine using formulas, Apps Script, and integrations. Use when building systems in Sheets, automatin...
Install via ClawdBot CLI:
clawdbot install JK-0001/spreadsheet-automationGrade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Calls external URL not in known-safe list
https://example.comUses known external API (expected, informational)
api.twitter.comAudited Apr 16, 2026 · audit v1.0
Generated Mar 20, 2026
Centralizes lead data from multiple sources like forms and APIs into a master sheet, then uses QUERY and FILTER formulas to create a real-time dashboard showing lead status, conversion rates, and weekly metrics. Ideal for small sales teams needing a free CRM alternative.
Tracks stock levels, reorder points, and supplier details using ARRAYFORMULA for automatic calculations and IMPORTRANGE to sync data across warehouse sheets. Sends email alerts via Apps Script when inventory falls below threshold, replacing basic inventory software.
Uses Sheets as a lightweight project database with columns for tasks, deadlines, and owners. Automates status updates via formulas and generates weekly reports using charts and summaries, reducing manual updates for small project teams.
Aggregates support requests from forms or emails into a master sheet, then uses FILTER and UNIQUE formulas to categorize and prioritize tickets. Creates a dashboard with response times and resolution rates, streamlining support workflows without expensive tools.
Pulls transaction data from accounting tools or manual entries using IMPORTRANGE, then applies formulas like QUERY and ARRAYFORMULA to generate monthly budgets and expense reports. Automates alerts for overspending, ideal for small businesses or freelancers.
Offer services to small businesses to automate their Sheets workflows, such as building custom dashboards or integrating APIs. Charge per project or hourly, targeting clients looking to replace SaaS tools with cost-effective solutions.
Create and sell pre-built Google Sheets templates for common use cases like CRM, inventory, or project tracking. Market to entrepreneurs and small teams via online platforms, with upsells for customization or support services.
Partner with agencies to provide ongoing automation services for their clients, such as setting up multi-sheet systems or Apps Script integrations. Focus on retainer models for maintenance and updates, scaling with client needs.
💬 Integration Tip
Use IMPORTRANGE to sync data between Sheets and Google Forms for automated data collection, and leverage Apps Script to connect with external APIs like Slack or email for notifications.
Scored Apr 19, 2026
Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Claude's capabilities with specialized knowledge, workflows, or tool integrations.
Use the @steipete/oracle CLI to bundle a prompt plus the right files and get a second-model review (API or browser) for debugging, refactors, design checks, or cross-validation.
Use when starting any conversation - establishes how to find and use skills, requiring Skill tool invocation before ANY response including clarifying questions
Systematic code review patterns covering security, performance, maintainability, correctness, and testing — with severity levels, structured feedback guidance, review process, and anti-patterns to avoid. Use when reviewing PRs, establishing review standards, or improving review quality.
Coding style memory that adapts to your preferences, conventions, and patterns for consistent coding.
Control and operate Opencode via slash commands. Use this skill to manage sessions, select models, switch agents (plan/build), and coordinate coding through Opencode.