Harbour & Pine · Operations
Apps Script Automation & Workflow Academy
Design, test and export Google Apps Script automations for a fictional business.
Simulated time
Process a new onboarding row
Sheets Row Added → Validate Data → Send Gmail Notification → Update Sheet Status
The browser runs a fictional Workspace. It creates a local message receipt and updates a local spreadsheet.
Opening the local workspace…
Independent exercise
Hint and troubleshooting
Deployment notes
Virtual Workspace
Synthetic dataScript editor
Code.gsCtrl/⌘ + Enter runs the current activity. Code runs in a disposable worker. Live Google services are unavailable here.
Trigger lab
Manual replayEvent payload and permissions
Workflow designer
Connect nodes, inspect generated code, then run it against the virtual Workspace.
Generated Apps Script
Validate the graph to inspect its Apps Script.
Portfolio & snapshots
Weekly scenario
AI workflow coach
Review the prompt for private data before sharing it outside the academy.
Evidence and next step
Execution Observatory
Awaiting a runRun the starter script to see checks, service calls and resource changes.