All templates
For corrugated box converters, folding carton plants & packaging shipping and logistics teams

Log every shipment's pallet count without typing it in

Every night, WebRun opens EFI, reviews shipments dispatched that day, logs the customer, order, pallet count, carrier, and BOL number to a Google Sheet, and drafts a shipment notice per customer in Gmail, ready for you to review and send.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every night at 6:30 PM WebRun
1 EFI pull the day's completed shipments
2 Google Sheets log pallet counts and BOL numbers
3 Gmail draft the shipment notice
Run a sample
In short

How do I log pallet counts and shipment details without manual data entry?

WebRun compiles the day's completed shipments from EFI every night. It logs the customer, order, pallet count, carrier, and BOL number to a Google Sheet, then drafts a shipment notice per customer in Gmail and leaves it unsent, so your shipment record is complete and a ready-to-send notice is waiting without anyone retyping the details.

  • Every shipment is logged with its pallet count the same night it ships
  • No one retypes BOL numbers or carrier details from paperwork
  • A shipment notice is ready to send without writing it from scratch

Built for corrugated box converters · folding carton plants · packaging shipping and logistics teams · warehouse coordinators

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 www.efi.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    EFI - pull the day's completed shipments
    efi.com How to Automate EFI
    WebRun in EFI: pull the day's completed shipments
    WebRun opens EFI to pull the day's completed shipments.
    • Open EFI's shipping or dispatch records and review shipments completed today
    • Capture the customer, order, pallet count, carrier, BOL number, and ship time for each
    • Note any shipment split across more than one truck

    Done when Every shipment completed today is listed with its pallet count and BOL number.

  3. 2
    Google Sheets - log pallet counts and BOL numbers
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: log pallet counts and BOL numbers
    WebRun opens Google Sheets to log pallet counts and BOL numbers.
    • Open the shipment log and append a row per shipment
    • Record the customer, order, pallet count, carrier, BOL number, and ship date
    • Log a split shipment as its own row per truck

    Done when The shipment log holds a row for every shipment completed today.

  4. 3
    Gmail - draft the shipment notice
    gmail.com How to Automate Gmail
    WebRun in Gmail: draft the shipment notice
    WebRun opens Gmail to draft the shipment notice.
    • Draft a shipment notice per customer naming the order, pallet count, carrier, and BOL number
    • Keep the wording short and factual
    • Leave every email as an unsent draft for you to review. Never send it on its own

    Done when A shipment notice draft is waiting in Gmail for every customer shipped today.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.efi.com
ScheduleRuns automatically on this cadence
Every night at 6:30 PM
DeliveryHow each run's result reaches you
Shipment log · Google Sheets
OutputWhat each run produces - A shipment log with pallet counts and BOL numbers, plus a drafted notice per customer waiting in Gmail.
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 email the shipment notice to customers automatically?

No. WebRun leaves every shipment notice as an unsent draft in Gmail. You review the pallet count and details, then send it yourself.

Where do the pallet counts come from?

Straight from EFI's shipping or dispatch record for each completed shipment. WebRun doesn't count pallets itself, it reads the number already recorded in your system.

What if a shipment is split across multiple trucks?

Each dispatch is logged as its own row, so a split shipment shows as separate lines with its own carrier and BOL number instead of one combined total.

Put this on autopilot.

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