Skip to content

Latest commit

 

History

3 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 

Repository files navigation

Google AppSheet Production Agent Skill

View on skills.sh

A production-oriented Agent Skill for designing, building, modifying, securing, automating, integrating, testing, deploying, reviewing, and operating Google AppSheet applications.

The skill does not treat a blueprint as a deployed app. It distinguishes Blueprint, Editor implementation, Review, and Incident modes; requires live official AppSheet Help checks; and fails closed on identity, row security, plan support, live-data testing, external side effects, and rollback.

Included

  • Production workflow in google-appsheet-production/SKILL.md
  • Curated official Google AppSheet Help map and machine-checkable 96-article catalog
  • Data architecture, security/governance, expression, and automation references
  • Delivery-pack templates for app spec, sources, data model, security, expressions, automation, tests, deployment, and operations
  • Zero-dependency Python helpers to:
    • Search and fetch current official AppSheet Help articles
    • Verify the official-document catalog
    • Scaffold a complete delivery pack
    • Validate delivery structure, blockers, CSV schemas, source freshness, and likely secrets

Install

List the published skill without installing:

npx --yes skills add Yash-Kavaiya/appsheet-agent-skill --list

Install the skill:

npx --yes skills add Yash-Kavaiya/appsheet-agent-skill \
  --skill google-appsheet-production

Marketplace listings

skills.sh indexing is activated by remote Skills CLI discovery. SkillsMP automatically indexes public GitHub repositories during its daily sync when they contain a valid SKILL.md and use its recognized repository topics.

Official documentation freshness

The bundled catalog was fetched and verified against https://support.google.com/appsheet on 2026-07-30. Recheck exact feature, limit, plan, API, UI, licensing, and residency pages during each substantive task:

cd google-appsheet-production
python scripts/appsheet_docs.py search "security filters"
python scripts/appsheet_docs.py fetch 10104488 --format markdown
python scripts/appsheet_docs.py check-catalog references/official-docs.json

Search results are discovery only. The skill requires the article itself to be fetched before it is used as evidence.

Create a production delivery pack

cd google-appsheet-production
python scripts/scaffold_delivery.py C:/work/my-app/appsheet-delivery \
  --app-name "My App" \
  --mode Blueprint

Then complete every document and validate:

python scripts/validate_delivery.py C:/work/my-app/appsheet-delivery

The strict validator returns non-zero for missing files, unresolved blocking placeholders, empty production CSVs, missing official-source evidence, invalid status, or likely embedded secrets. For template-only smoke testing:

python scripts/validate_delivery.py C:/work/my-app/appsheet-delivery \
  --allow-blockers \
  --allow-empty

Repository layout

appsheet-agent-skill/
├── README.md
├── LICENSE
├── .gitignore
└── google-appsheet-production/
    ├── SKILL.md
    ├── references/
    │   ├── architecture-and-data.md
    │   ├── automation-integrations.md
    │   ├── expression-engineering.md
    │   ├── official-docs-map.md
    │   ├── official-docs.json
    │   └── security-governance.md
    ├── scripts/
    │   ├── appsheet_docs.py
    │   ├── scaffold_delivery.py
    │   └── validate_delivery.py
    └── templates/
        ├── app-spec.md
        ├── automation-inventory.csv
        ├── data-model.md
        ├── deployment-runbook.md
        ├── expressions.md
        ├── operations-runbook.md
        ├── security-matrix.csv
        ├── source-register.md
        └── test-plan.csv

Validation performed

The release workflow verifies:

  • YAML frontmatter, description length, body, and total skill size
  • Python syntax for every helper
  • Real official-help search and article extraction
  • Live availability and titles for every catalog article
  • Delivery scaffold generation
  • Permissive template validation and strict fail-closed behavior
  • Skills CLI local discovery and isolated copied installation
  • Package manifest and SHA-256 checksums

Security

The skill never requires credentials in source files. AppSheet passwords, OAuth tokens, application access keys, webhook secrets, and payment details must be entered by the authorized user through supported product controls. Generated evidence must be redacted.

Trademark and affiliation

Google, Google Workspace, and AppSheet are trademarks of Google LLC. This independent Agent Skill is not affiliated with or endorsed by Google. Official product facts are linked to Google AppSheet Help and must be rechecked live.

License

MIT. See LICENSE.

About

Production-ready Google AppSheet Agent Skill with official-doc grounding, security gates, templates, and validation helpers.

Topics

Resources

Stars

1 star

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages