All templates

Whiskey Systems Automated Proof of Delivery Chasing

Every Monday, WebRun opens Whiskey Systems and identifies shipments marked as delivered more than 2 days ago that still lack a confirmed proof of delivery, logs each open POD to a Google Sheet with the account and delivery date, drafts a polite SMS chase via Twilio for each account, and leaves those messages for a human to review and send so nothing is dispatched without approval.

Runs on WebRun · Strict Lockdown policy
Every Monday at 9:00 AM WebRunorchestrates each step
1 Whiskey Systems find deliveries missing proof of delivery
2 Google Sheets log open POD records
3 Twilio draft SMS chase messages
In short

How do I automatically chase missing proof of delivery from wholesale accounts?

Every Monday, WebRun checks Whiskey Systems for shipments delivered more than 2 days ago without a confirmed proof of delivery, logs each open record to a Google Sheet sorted by age, and drafts an SMS chase via Twilio for a human to review and send, so missing PODs are caught before any invoice dispute window opens.

  • Every unconfirmed delivery caught within 2 days before any invoice dispute window opens
  • POD tracker in Google Sheets stays current with days-outstanding sorted for quick triage
  • No customer receives an automated chase message without human review and approval

Built for craft distillery operations managers · wholesale delivery coordinators · distillery logistics teams · accounts receivable managers

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

  2. 1
    Whiskey Systems - find deliveries missing proof of delivery
    whiskeysystems.com
    WebRun in Whiskey Systems: find deliveries missing proof of delivery
    WebRun opens Whiskey Systems to find deliveries missing proof of delivery.
    • Open Whiskey Systems and navigate to the Finished Goods delivery or transfer tracking view
    • Filter for shipments with a delivery date more than 2 days ago
    • Identify any shipment that does not have a recorded proof of delivery or signed confirmation
    • Capture the account name, contact phone number, shipment number, delivery date, and items delivered

    Done when Every overdue POD is identified with account details, shipment number, and delivery date.

  3. 2
    Google Sheets - log open POD records
    google.com
    WebRun in Google Sheets: log open POD records
    WebRun opens Google Sheets to log open POD records.
    • Open the Proof of Delivery Tracker sheet
    • Append each missing POD as a new row with the account name, shipment number, delivery date, and days outstanding
    • Mark any record that has since been confirmed as cleared
    • Sort by days outstanding, oldest first

    Done when The POD tracker shows every outstanding delivery confirmation with its age.

  4. 3
    Twilio - draft SMS chase messages
    twilio.com
    WebRun in Twilio: draft SMS chase messages
    WebRun opens Twilio to draft SMS chase messages.
    • For each account missing a POD, draft an SMS message politely requesting confirmation of delivery or asking the contact to sign and return the delivery note
    • Include the delivery date and the shipment number so the account can identify the order
    • Leave every message as a draft for a human to review and approve before sending. Do not send automatically.

    Done when A drafted SMS chase is ready for every account with an outstanding proof of delivery.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.whiskeysystems.com
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
POD chase list · Google Sheets
OutputWhat each run produces - A Google Sheet POD tracker sorted by days outstanding and Twilio SMS draft chase messages for each account.
Spreadsheet + draft SMS
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 SMS messages to accounts automatically?

No. WebRun drafts each chase message in Twilio and leaves it unsent. A human reviews and approves every message before it reaches a customer.

What counts as a confirmed proof of delivery?

WebRun looks for a signed delivery confirmation or a received status recorded in Whiskey Systems. If your process records POD differently, you can specify the field or status to check in your run settings.

What if a delivery is still in transit and not actually overdue?

WebRun only flags shipments whose recorded delivery date in Whiskey Systems is 2 or more days in the past. If a delivery date was entered incorrectly, update it in Whiskey Systems and the record will clear on the next run.

Put this on autopilot.

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