Collect passenger weights for balloon flight planning
Every morning, WebRun opens TripWorks, reviews upcoming flights, notes which passengers are still missing a weight figure, records the running totals in a Google Sheet for the pilot, and drafts a discreet, respectful request email in Gmail for each passenger without one, queued for your review.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically collect passenger weights for balloon flight planning?
Every morning, WebRun checks upcoming TripWorks flights for passengers who have not given a weight, logs per-flight load totals in a Google Sheet for the pilot, and drafts a discreet, confidential request email in Gmail for anyone missing one. Every request waits for your review, so nothing about a passenger's weight is sent unapproved.
- Pilots get a per-flight load sheet instead of chasing weights by hand
- Missing weights are requested days ahead, not at the launch field
- Weight figures stay internal and every passenger request is reviewed first
Built for hot air balloon operators · balloon pilots · flight coordinators · tour operators
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.tripworks.comin a real browser with your saved login - no setup, no API keys. -
1
TripWorks - find passengers missing a weight
tripworks.com How to Automate TripWorks
WebRun opens TripWorks to find passengers missing a weight. - Open TripWorks and list passengers on flights in the coming days
- Read the weight field or custom question response on each booking
- Flag every passenger who has not provided a weight yet
- Capture their name, email, and flight date for the pilot and the request
Done when Passengers missing a weight are identified across all upcoming flights.
-
2
Google Sheets - log the load sheet for the pilot
docs.google.com How to Automate Google Sheets
WebRun opens Google Sheets to log the load sheet for the pilot. - Open the flight planning sheet in Google Sheets
- Record each flight with its confirmed weights and the passengers still outstanding
- Total the known basket weight per flight so the pilot can plan ballast and lift
- Highlight flights where too many weights are still missing to plan safely
Done when The Google Sheet shows per-flight weight totals and which passengers are still outstanding.
-
3
Gmail - draft a discreet weight request
gmail.com How to Automate Gmail
WebRun opens Gmail to draft a discreet weight request. - Draft a short, respectful email explaining that weights are needed for safe flight planning
- Reassure the passenger that the figure is confidential and used only for load and ballast
- Include the simple way to reply or update it on their booking
- Save each email as a Gmail draft. Do not send any weight request automatically.
Done when A discreet weight-request draft exists in Gmail for every passenger without a weight, ready for review.
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 email passengers for their weight without me?
No. Every weight request is saved as a Gmail draft and waits for your review. You can soften the wording or skip a guest before anything is sent.
Is the weight information kept private?
Yes. Weights are logged only in your internal Google Sheet for the pilot's load and ballast planning. The draft email tells passengers the figure is confidential and used solely for safe flight planning.
Why does the pilot need passenger weights at all?
Balloons have strict lift and basket capacity limits, so total load drives ballast, fuel, and passenger grouping. The sheet totals known weights per flight and flags any flight still missing too many to plan safely.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.