All templates

Automated Buildertrend Material Delivery Coordination

Every morning, WebRun opens Buildertrend, checks today's excavation schedule for material requirements tied to active tasks, identifies any purchase orders or deliveries that have not been confirmed, and appends a coordination checklist to a Google Sheet so your project manager can verify ETAs before the crew arrives.

Runs on WebRun · Strict Lockdown policy
Every day at 6:30 AM WebRunorchestrates each step
1 Buildertrend find today's material requirements and open POs
2 Google Sheets log unconfirmed deliveries for coordination
In short

How do I coordinate material deliveries for my excavation projects?

WebRun opens Buildertrend every morning, checks today's excavation schedule for material requirements, and finds any purchase orders that have not been confirmed as received. It logs every unconfirmed delivery to a Google Sheet with the supplier, material, and project so your team can confirm ETAs before the crew hits the job site.

  • Unconfirmed material deliveries are surfaced every morning before crews arrive on site
  • Job site delays from missing materials drop as coordination becomes proactive
  • Project managers have a single sheet showing every open delivery across all jobs

Built for excavation contractors · construction project managers · site supervisors · procurement 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 app.buildertrend.net in a real browser with your saved login - no setup, no API keys.

  2. 1
    Buildertrend - find today's material requirements and open POs
    buildertrend.com
    WebRun in Buildertrend: find today's material requirements and open POs
    WebRun opens Buildertrend to find today's material requirements and open POs.
    • Open Buildertrend and navigate to today's schedule for all active excavation projects
    • Check the purchase orders section for any deliveries expected today or tomorrow
    • Identify POs that have not been marked as received or confirmed
    • Capture the material description, supplier, expected delivery date, and associated project

    Done when All unconfirmed material deliveries for today and tomorrow are identified.

  3. 2
    Google Sheets - log unconfirmed deliveries for coordination
    google.com
    WebRun in Google Sheets: log unconfirmed deliveries for coordination
    WebRun opens Google Sheets to log unconfirmed deliveries for coordination.
    • Append each unconfirmed delivery to today's row in the coordination sheet
    • Include the material, supplier, expected date, project name, and a status column for your team to update
    • Highlight items where the delivery is today and still shows as unconfirmed

    Done when Your coordination sheet shows all unconfirmed deliveries for today and tomorrow.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.buildertrend.net
ScheduleRuns automatically on this cadence
Every day at 6:30 AM
DeliveryHow each run's result reaches you
Delivery coordination list · Google Sheets
OutputWhat each run produces - A Google Sheet updated each morning with unconfirmed material deliveries due today or tomorrow, including supplier, material, project, and status.
Spreadsheet
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

Does it contact suppliers to confirm deliveries?

No. WebRun logs the unconfirmed deliveries to your Google Sheet. Your project manager uses the list to call or email suppliers directly to confirm ETAs.

How does it know what materials are needed today?

It reads the purchase orders and material lists attached to today's scheduled tasks in Buildertrend, so the coordination list is tied to your actual job schedule.

What if a delivery was marked received in Buildertrend last night?

Deliveries marked as received in Buildertrend before the morning run are skipped, so your sheet only shows what actually needs attention.

Put this on autopilot.

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