All templates

Automated Sawyer Camp Week Enrollment Reports

Every Monday during camp season, WebRun opens Sawyer, pulls enrollment and capacity for this week and the next four camp weeks, logs the fill rate for each week in Google Sheets, and sends your camp director a Telegram summary flagging which weeks are under filled.

Runs on WebRun · Strict Lockdown policy
Every Monday at 7:30 AM WebRunorchestrates each step
1 Sawyer pull enrollment and capacity per camp week
2 Google Sheets log the fill rate
3 Telegram flag under filled weeks
In short

How do I track weekly STEM camp enrollment before a week runs under capacity?

WebRun pulls Sawyer enrollment and capacity for this week and the next four camp weeks every Monday, logs each week's fill rate in Google Sheets, and sends your camp director a Telegram summary flagging any week under 60 percent filled. Slow weeks surface with enough lead time to run a promotion or adjust staffing before the cancellation deadline arrives.

  • Under filled camp weeks get flagged with four weeks of lead time
  • Fill rate trends are logged automatically instead of tallied by hand each Monday
  • Cancellation decisions are made from real enrollment numbers, not a guess

Built for STEM camp directors · robotics and coding camp operators · seasonal program coordinators

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens www.hisawyer.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Sawyer - pull enrollment and capacity per camp week
    hisawyer.com
    WebRun in Sawyer: pull enrollment and capacity per camp week
    WebRun opens Sawyer to pull enrollment and capacity per camp week.
    • Open Sawyer and pull enrolled headcount and capacity for this week and the next four camp weeks
    • Break the count down by camp track where more than one runs the same week
    • Note the cancellation deadline coming up for each camp week

    Done when Enrollment and capacity for the next five camp weeks are captured by track.

  3. 2
    Google Sheets - log the fill rate
    google.com
    WebRun in Google Sheets: log the fill rate
    WebRun opens Google Sheets to log the fill rate.
    • Log this week's enrollment, capacity, and fill rate percentage for each camp week and track
    • Compare this week's fill rate to the same week logged last Monday to show the trend

    Done when The enrollment tracker sheet is updated with this week's fill rate for every camp week and track.

  4. 3
    Telegram - flag under filled weeks
    telegram.org
    WebRun in Telegram: flag under filled weeks
    WebRun opens Telegram to flag under filled weeks.
    • Message your camp director a summary of fill rate by week, sorted with the lowest filled weeks first
    • Flag any week under 60 percent filled with its cancellation deadline

    Done when Your camp director has this week's fill rate summary in Telegram with under filled weeks flagged.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.hisawyer.com
ScheduleRuns automatically on this cadence
Every Monday at 7:30 AM
DeliveryHow each run's result reaches you
Enrollment report · Telegram
OutputWhat each run produces - A weekly fill rate log per camp week and track in Google Sheets, plus a Telegram summary flagging any under filled week and its cancellation deadline.
Report
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does it cancel a low-enrolled camp week automatically?

No. It only reports the fill rate and flags which weeks are running low. Whether to run, combine, or cancel a week is always your team's call, made with real numbers instead of a guess.

What counts as under filled?

Any camp week under 60 percent of capacity, which you can adjust. WebRun sorts the Telegram summary with the lowest filled weeks first so the most urgent ones are easy to spot.

How far ahead does it look?

This week plus the next four camp weeks, so a slow week shows up with enough lead time to run a promotion or adjust staffing before its cancellation deadline passes.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.