All templates
For hazmat freight sales teams, dangerous goods shipping coordinators & DG logistics brokers

Follow up on open hazmat shipping quotes before they expire

Every morning, WebRun reviews your open dangerous goods shipping quotes in Google Sheets, identifies any quote without a customer response after 48 hours, drafts a follow-up email for each using the shipment details from Labelmaster DGIS, and queues the drafts in Gmail for your team to approve before sending.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every day at 9:00 AM WebRun
1 Google Sheets find open DG quotes without a response after 48 hours
2 Labelmaster pull shipment and compliance details for each quote
3 Gmail draft follow-up email for team review
Run a sample
In short

How do I automatically follow up on open dangerous goods shipping quotes?

WebRun reviews your open dangerous goods shipping quotes in Google Sheets every morning, finds any quote without a customer response after 48 hours, pulls the shipment compliance details from Labelmaster DGIS, and drafts a follow-up email for each. All drafts queue in Gmail for your team to approve before any customer receives a message.

  • Every open DG shipping quote gets a follow-up draft within 48 hours of no response
  • UN number and compliance details included in every draft automatically
  • No open quote slips through the cracks before it expires

Built for hazmat freight sales teams · dangerous goods shipping coordinators · DG logistics brokers · hazmat customer success teams

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 docs.google.com/spreadsheets in a real browser with your saved login - no setup, no API keys.

  2. 1
    Google Sheets - find open DG quotes without a response after 48 hours
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: find open DG quotes without a response after 48 hours
    WebRun opens Google Sheets to find open DG quotes without a response after 48 hours.
    • Open the Open Quotes tracker sheet
    • Filter to rows where the quote date is more than 48 hours ago and the status is still Open or No Response
    • Capture the customer name, quote number, UN number, origin, destination, and quoted rate for each

    Done when All open DG quotes with no customer response after 48 hours are identified.

  3. 2
    Labelmaster - pull shipment and compliance details for each quote
    labelmaster.com How to Automate Labelmaster
    WebRun in Labelmaster: pull shipment and compliance details for each quote
    WebRun opens Labelmaster to pull shipment and compliance details for each quote.
    • Open DGIS and look up the shipment details for each open quote
    • Confirm the UN number, proper shipping name, hazard class, and mode for each
    • Note any compliance requirements or documentation needed so the follow-up is informative

    Done when Shipment compliance details are confirmed in DGIS for each open quote to be followed up on.

  4. 3
    Gmail - draft follow-up email for team review
    gmail.com How to Automate Gmail
    WebRun in Gmail: draft follow-up email for team review
    WebRun opens Gmail to draft follow-up email for team review.
    • Draft a follow-up email to each customer for their open DG shipping quote
    • Include the quote number, UN number, shipment route, and a brief note on any compliance advantage
    • Leave all drafts unsent in Gmail for your coordinator to review, personalize if needed, and approve before sending

    Done when Follow-up email drafts are queued in Gmail for every unanswered DG quote, awaiting human approval.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
docs.google.com/spreadsheets
ScheduleRuns automatically on this cadence
Every day at 9:00 AM
DeliveryHow each run's result reaches you
Follow-up drafts · Gmail
OutputWhat each run produces - Follow-up email drafts queued in Gmail for every open DG shipping quote past 48 hours, with shipment and compliance details pulled from Labelmaster DGIS.
Text
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

Will it send the follow-up emails to customers automatically?

No. Every follow-up email is drafted in Gmail and left unsent. Your coordinator reviews and approves each draft before it reaches any customer.

How does it know what compliance details to include in the follow-up?

It pulls the UN number, proper shipping name, and hazard class from the Labelmaster DGIS shipment record linked to the quote, so the follow-up is grounded in real DG compliance data.

What if a customer has already responded and the quote is in progress?

It reads the live status column in your Google Sheets quote tracker each morning, so any quote marked as Accepted, In Progress, or Declined is automatically excluded from the follow-up list.

Put this on autopilot.

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