Demonstration code, configuration and documented setup tests
Not a ready-to-paste installation: the accounts, permissions, workbooks, sender, alert recipients and rules still have to be chosen with your team. Plain text files; nothing to install to read them.
The decision core
Pure TypeScript, no I/O. Used by the page and bundled into Apps Script.
- derive.ts 9.4 KB
- index.ts 0.2 KB
- letter-template.ts 0.9 KB
- memory.ts 4.3 KB
- monitor.ts 17.8 KB
- pass.ts 12.3 KB
- rules.ts 3.0 KB
- schema.ts 2.5 KB
- triggers.ts 1.5 KB
- types.ts 6.2 KB
Apps Script adapters
The only code that talks to Google: sheets, mail, lock, triggers.
- common.ts 4.1 KB
- monitor-entry.ts 0.1 KB
- monitor.ts 4.1 KB
- sender-demo-entry.ts 0.1 KB
- sender-entry.ts 0.1 KB
- sender.ts 5.1 KB
- setup-tests.ts 6.5 KB
Sending project (generated)
What goes into the sending project: Code.js and its manifest.
- Code.js 31.8 KB
- appsscript.json 0.3 KB
Checking project (generated)
What goes into the checking project, under another account.
- Code.js 34.2 KB
- appsscript.json 0.3 KB
Demo setup tests (generated)
The sending project plus the setup tests run on our test account.
- Code.js 38.7 KB
- appsscript.json 0.3 KB
Tests
Every safeguard with its negative control, and the generated bundle run against small fakes.
- apps-script-bundle.test.ts 10.4 KB
- core.test.ts 27.6 KB