Turn VIP depletions into ready-to-send supplier reports
Every month, WebRun opens VIP, pulls case sales by brand and SKU from the Depletions module, fills them into a Google Sheets report template, and drafts a formatted email per supplier in Gmail, ready for review before it goes to the brand manager.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automate supplier depletion reports from VIP?
WebRun compiles your supplier depletion reports automatically. Each period, it opens VIP, pulls case sales by brand and SKU from the Depletions module, fills them into your Google Sheets report template, and drafts a formatted email per supplier in Gmail, ready for review, so depletion reporting stops eating a day of someone's month.
- Depletion reports are compiled and ready to send within minutes, not a full day
- Every brand manager gets the exact report format they expect, every period
- Nothing reaches a supplier until someone on your team reviews and sends it
Built for beer distributors · wine wholesalers · supplier relations teams · beverage distribution accounting
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
www.vipinsights.comin a real browser with your saved login - no setup, no API keys. -
1
VIP - pull depletions by brand
vipinsights.com How to Automate VIP
WebRun opens VIP to pull depletions by brand. - Open VIP and go to the Depletions module
- Filter to the reporting period and pull case sales by brand and SKU
- Capture depletions for every supplier that requires a report
Done when This period's depletions are captured for every reporting brand.
-
2
Google Sheets - compile the depletion report
google.com How to Automate Google Sheets
WebRun opens Google Sheets to compile the depletion report. - Open the depletion report template for the period
- Fill in case sales by brand, SKU, and retailer type
- Total each brand's depletions for the period
Done when The depletion report is compiled and totaled for every brand.
-
3
Gmail - draft the report email to the supplier
gmail.com How to Automate Gmail
WebRun opens Gmail to draft the report email to the supplier. - Draft an email to each supplier's brand manager with their depletion report attached
- Use the subject line and format the supplier expects
- Leave every draft unsent in your outbox for review before sending
Done when A ready-to-send draft is waiting in Gmail for every supplier report due this period.
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
Does it email the depletion report to suppliers automatically?
No. WebRun drafts the report email for every supplier and leaves it unsent in Gmail. Someone on your team reviews the numbers and hits send, nothing goes to a brand manager on its own.
Where do the depletion figures come from?
From VIP's Depletions module, case sales by brand and SKU for the reporting period. WebRun reads the live figures each run, it never estimates or reuses a prior period's numbers.
Can it match the format each supplier wants?
Yes. Give WebRun the report layout or a past example for each supplier and it will fill in that same format every period.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.