Automated Propane Weekly Delivery Report
Every Monday morning, WebRun opens ADD Systems, pulls last week's delivery data including stops completed, gallons delivered by route, and revenue totals, logs the results to a Google Sheet for trend tracking, and posts a clean weekly performance summary to your operations Slack channel.
How do I automatically generate a weekly propane delivery performance report?
WebRun pulls last week's delivery data from ADD Systems every Monday, including stops completed, gallons delivered, and revenue by route. It logs the results to a Google Sheet for trend tracking and posts a structured performance summary to your Slack operations channel, complete with week-over-week changes.
- Leadership and operations teams start each Monday with a complete prior-week performance summary
- Week-over-week trends are visible without manual spreadsheet work
- Route-level breakdowns make it easy to spot underperforming days or drivers
Built for propane delivery companies · heating fuel operations managers · fuel oil distributors · delivery route supervisors
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.addsys.comin a real browser with your saved login - no setup, no API keys. -
1
ADD Systems - pull last week's delivery totals by route
- Open ADD Systems and navigate to the delivery summary or management report for the prior week
- Capture total stops completed, gallons delivered, revenue, and number of no-access or incomplete stops
- Break totals down by route or driver if that data is available
Done when Last week's delivery totals are captured with stop counts, gallons, and revenue by route.
-
2
Google Sheets - log weekly results to performance tracker
google.com
WebRun opens Google Sheets to log weekly results to performance tracker. - Append a new row to the weekly delivery performance tracker with the week ending date and all captured metrics
- Calculate week-over-week change in gallons and stops if prior rows exist
Done when Last week's performance data is logged to the Google Sheet with a week-ending date.
-
3
Slack - post weekly performance summary
slack.com
WebRun opens Slack to post weekly performance summary. - Post the weekly delivery report to the operations channel with total stops, gallons delivered, and revenue
- Include any notable metrics such as incomplete stops, route with highest volume, and week-over-week change
- Attach a link to the Google Sheet for full historical data
Done when Operations team has this week's delivery performance summary in Slack.
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
Does it compare this week's numbers to the prior week automatically?
Yes. When prior-week data exists in the Google Sheet, WebRun calculates week-over-week changes in gallons and stops and includes them in the Slack summary so trends are visible at a glance.
What if some deliveries from last week are still marked as pending?
It reads the delivery log from ADD Systems as it stands at run time, capturing all stops marked as completed for the prior week. Pending stops are not included, so the numbers reflect confirmed activity only.
Can it break the report down by individual driver or truck?
Yes. If route or driver assignment data is recorded in ADD Systems, WebRun breaks the summary down by route so each driver's week is visible alongside the company total.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.