Automated Sawyer Competition Roster Drafts
Every morning in the weeks before a competition, WebRun opens Sawyer, pulls the enrollment, skill level, and eligibility details for every student on the competition team, builds a roster in Google Sheets, and emails the coach a review-ready draft to check before it goes to the organizer.
How do I build a competition team roster from my class enrollment records?
WebRun pulls each competitor's enrollment, skill level, and eligibility status from Sawyer every morning, builds a competition team roster in Google Sheets, and emails the coach a review-ready draft with any missing eligibility documents flagged. Nothing goes to the competition organizer automatically. The coach always reviews and submits the final roster themselves.
- The coach gets a review-ready roster instead of building one from scratch
- Missing eligibility documents get flagged before the submission deadline, not after
- The roster stays current with live enrollment right up to competition day
Built for robotics competition coaches · STEM program directors · coding competition team leads
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.hisawyer.comin a real browser with your saved login - no setup, no API keys. -
1
Sawyer - pull team enrollment and skill levels
hisawyer.com
WebRun opens Sawyer to pull team enrollment and skill levels. - Open Sawyer and pull the roster for the competition team class or group
- Capture each student's grade, skill level, and any eligibility notes on file
- Flag any student missing a required waiver or eligibility document
Done when Every competitor's enrollment and eligibility status is captured.
-
2
Google Sheets - build the roster draft
google.com
WebRun opens Google Sheets to build the roster draft. - Build a roster with each student's name, grade, skill level, and eligibility status
- Sort the roster in the format your competition organizer requires
- Highlight any student flagged with a missing document so the coach sees it first
Done when A complete roster draft exists in Google Sheets with any missing eligibility items highlighted.
-
3
Gmail - send the coach a review copy
gmail.com
WebRun opens Gmail to send the coach a review copy. - Draft an email to the coach with the roster link and a summary of any flagged eligibility issues
- Leave the email as a Gmail draft for the coach to review. WebRun never contacts the competition organizer directly
Done when The coach has a review-ready roster draft and knows about any outstanding eligibility items.
How is each run configured?
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.
Every action is checked against this policy before it runs.
Questions, answered
Will it submit the roster to the competition organizer?
No. WebRun only builds the roster draft and emails a review copy to the coach. Submitting to the competition organizer is always a decision your coach makes and completes themselves.
How does it flag eligibility problems?
It checks each competitor's record in Sawyer for a signed waiver and any required eligibility document, then highlights whoever is missing one so the coach can chase it before the deadline.
What if the team roster changes right before the deadline?
It rebuilds the roster from live Sawyer enrollment every morning, so a last-minute addition or drop is reflected in the next draft automatically.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.