All templates

Whiskey Systems Automated Price List Update Notifications

When you trigger a price-list rollout, WebRun opens Whiskey Systems to pull the updated prices and your active wholesale account list, drafts a personalized notification email in Gmail for each account with their specific product prices, logs every draft to a Google Sheet for tracking, and leaves all emails unsent for your review before any customer is notified.

Runs on WebRun · Strict Lockdown policy
On demand WebRunorchestrates each step
1 Whiskey Systems pull updated prices and account list
2 Gmail draft personalized price-change notifications
3 Google Sheets log rollout status per account
In short

How do I automatically notify all my wholesale accounts when I update my price list?

When you update prices in Whiskey Systems, WebRun pulls the new rates and your active wholesale account list, drafts a personalized price-change notification email in Gmail for each account with only their relevant SKUs, and logs every draft to a Google Sheet tracker so no account is missed and nothing goes out without your approval.

  • Every active account gets a personalized price-change draft within one run
  • No customer is notified until a human approves and sends the email
  • Rollout tracker in Google Sheets shows which accounts have been notified and which are pending

Built for craft distillery sales managers · wholesale account managers · distillery owners · distribution 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 app.whiskeysystems.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Whiskey Systems - pull updated prices and account list
    whiskeysystems.com
    WebRun in Whiskey Systems: pull updated prices and account list
    WebRun opens Whiskey Systems to pull updated prices and account list.
    • Open Whiskey Systems and navigate to the Finished Goods pricing or sales-order settings
    • Capture the updated price for each SKU that has changed
    • Pull the full list of active wholesale accounts with their contact email addresses
    • Note which SKUs each account has ordered in the past 6 months to personalize each notification

    Done when Updated prices and the relevant account list are captured for drafting.

  3. 2
    Gmail - draft personalized price-change notifications
    gmail.com
    WebRun in Gmail: draft personalized price-change notifications
    WebRun opens Gmail to draft personalized price-change notifications.
    • For each active wholesale account, draft a price-change notification email
    • Include only the SKUs relevant to that account based on their order history
    • State the effective date of the new pricing and include a friendly tone from the distillery
    • Leave every email as a draft in Gmail for review. Do not send any notification automatically.

    Done when A personalized price-change notification draft is ready in Gmail for every active account.

  4. 3
    Google Sheets - log rollout status per account
    google.com
    WebRun in Google Sheets: log rollout status per account
    WebRun opens Google Sheets to log rollout status per account.
    • Open the Price List Rollout Tracker sheet
    • Log each account with its draft status, email address, and the SKUs included in its notification
    • Add a Sent column for the team to mark off each account as the email is approved and sent
    • Note the effective date and the run timestamp for the rollout

    Done when The rollout tracker shows every account, its draft status, and the SKUs covered.

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
On demand
DeliveryHow each run's result reaches you
Draft notifications · Gmail
OutputWhat each run produces - Personalized Gmail draft notifications for each wholesale account and a Google Sheet rollout tracker.
Draft emails + 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

Will it notify customers automatically when prices change?

No. WebRun drafts every price-change email in Gmail and leaves them unsent. Your team reviews and approves each one before any customer receives a notification.

How does it know which products to include in each account's email?

It cross-references each account's order history in Whiskey Systems over the past 6 months and only includes SKUs that account has purchased, keeping each notification relevant and concise.

What if an account has a custom price agreement?

Flag those accounts in your run settings or in the Google Sheet and WebRun will skip automatic drafting for them, leaving a note that a custom notification is needed.

Put this on autopilot.

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