Watch your key lane rates so you never quote blind
Every Monday, WebRun opens DAT One, pulls the spot rate trend for each of your configured key lanes over the past 7 days, logs the weekly rates to a Google Sheets history tracker, and posts a Slack digest showing which lanes are rising, falling, or stable so your team quotes from current data.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically track DAT spot rate trends on my key lanes?
WebRun pulls spot rate trends from DAT One every Monday for your configured key lanes, including rate direction and load-to-truck ratio. It logs the weekly data to Google Sheets for a rolling history and posts a Slack digest with the biggest movers first, so every broker quotes from this week's real market data instead of guessing.
- Team quotes from this week's DAT spot rates, not last month's memory
- Rate movements above threshold flagged immediately in Slack
- Growing lane rate history in Google Sheets for seasonal benchmarking
Built for freight brokers · pricing managers · carrier sales reps · brokerage owners
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
one.dat.comin a real browser with your saved login - no setup, no API keys. -
1
DAT - pull spot rate trends for key lanes
dat.com How to Automate DAT
WebRun opens DAT to pull spot rate trends for key lanes. - Open DAT One and navigate to rate analytics for each configured key lane
- Pull the average spot rate and rate trend (rising, falling, stable) over the past 7 days
- Note the load-to-truck ratio for each lane to give context for the rate movement
Done when All key lanes have this week's rate, trend direction, and load-to-truck ratio captured.
-
2
Google Sheets - log weekly rates to history tracker
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log weekly rates to history tracker. - Append this week's rates to the lane rate history sheet, one row per lane
- Calculate the week-over-week change for each lane
Done when This week's lane rates are logged in Google Sheets with week-over-week change calculated.
-
3
Slack - post trend digest to team
slack.com How to Automate Slack
WebRun opens Slack to post trend digest to team. - Post the weekly rate digest to your brokerage Slack channel
- Lead with lanes showing the largest rate changes, both up and down
- Include rate, trend direction, and load-to-truck ratio for each lane
Done when Team has this week's lane rate trend digest in Slack to guide quoting.
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
Which lanes does it track?
It tracks the lanes you configure, typically your top 10 to 20 highest-volume origin-destination pairs. You can add or remove lanes in the setup without changing anything else.
What is the load-to-truck ratio and why does it matter?
The load-to-truck ratio is a DAT metric showing how many available loads exist per available truck on a lane. A high ratio means tight capacity and rising rates; a low ratio means loose capacity and rate pressure, which helps your team quote more accurately.
Does the history stay in Google Sheets indefinitely?
Yes. Each Monday's rates are appended as new rows, so you build a growing history you can use to spot seasonal trends and benchmark contract rates against the spot market.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.