Coding
PromptBeginner5 minmarkdown
Nano Banana Pro
Agent skill for nano-banana-pro
6
These instructions apply to the entire repository.
Sign in to like and favorite skills
These instructions apply to the entire repository.
Driver scans QR --> Google Form (H1..H19, Training) | v Google Sheet: "Mizuho Inventory" / tab "Table Inventory" | v Apps Script (weekly trigger): checkInventory() - Reads configured ranges - Compares actual vs expected - Emails alerts ("there is X of Y") with sheet link
Key IDs:
1xzymMh5ijyPTwa1CS0blqxno89uI33QFgVs2tFTKA2YTable Inventoryfeat:, fix:, chore:, docs:). Keep PRs focused./apps-script/ src/ checkInventory.js # main entry sheet.js # getSheet, header access alerts.js # email compose/send, throttling appsscript.json # manifest /docs/ INVENTORY.md # process flows, ranges, expected levels FORMS_INDEX.md # H1–H19 + Training URLs and QR notes SHEET_SCHEMA.md # column headers & validation rules INCIDENTS.md # postmortems /forms/ H1..H19/ # optional per-form notes or exports training/ AGENTS.md README.md
Table Inventory):
B7:T7, B14:T14, B22:T22, B8:T12, B15:T21, B23:T23expected and threshold (default 2 for single rows; 1 for multi-row blocks).CONFIG.email (use a Google Group; avoid personal emails in code).docs/FORMS_INDEX.md current for H1–H19 + Training.checkInventory() (time-driven weekly, e.g., Monday 06:00).feat/<short-name> or fix/<short-name>.npm i -g @google/clasp clasp login clasp pull # or clasp push if you're updating
main, deploy via Apps Script UI or clasp deploy.getAlerts() so it can be tested with mocked getValues() matrices./tools/testdata/ to validate known states.checkInventory() manually; re-enable trigger when green./docs/INCIDENTS.md.expected vs actual logic; email via SMTP/Graph.Before merge
After deploy
mainFrom a local clone of
hana-table-inventory:
# ensure you're on main and up to date git checkout main git pull --ff-only # add AGENTS.md at repo root, then commit and push git add AGENTS.md git commit -m "docs: add AGENTS guide for Hana inventory system" git push origin main