Keep wine and spirits club members excited about every allocation
Every morning, WebRun opens Bottlecapps, identifies members whose club allocation is ready to ship or pick up, drafts a personalized notification email for each in Gmail, and logs the batch in Google Sheets so your team can track who has been contacted.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically notify wine and spirits club members when their allocation is ready?
WebRun checks Bottlecapps every morning for club members whose wine or spirits allocation is ready, drafts a personalized notification for each member in Gmail, and logs the batch in Google Sheets. Your team reviews and sends the drafts, so every member hears about their allocation quickly without a member slipping through.
- Every club member is notified the day their allocation is ready
- Personalized drafts save staff time writing individual messages
- Notification log in Google Sheets shows who has been contacted
Built for wine club managers · spirits club operators · liquor store staff · bottle shop owners
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.bottlecapps.comin a real browser with your saved login - no setup, no API keys. -
1
Bottlecapps - identify members with ready allocations
bottlecapps.com
WebRun opens Bottlecapps to identify members with ready allocations. - Open Bottlecapps and navigate to the wine or spirits club section
- Filter members to those whose current allocation status is Ready or Available
- Capture each member's name, email, club tier, and the allocation details
Done when Every member with a ready allocation is listed with their contact and order details.
-
2
Gmail - draft personalized allocation notices
gmail.com How to Automate Gmail
WebRun opens Gmail to draft personalized allocation notices. - For each member, draft a personalized email noting their club tier, the allocation name, pickup or shipping deadline, and any tasting notes you have provided
- Save each draft unsent in Gmail Drafts for staff review
- Do not send any message without staff approval
Done when A personalized draft notification sits in Gmail Drafts for every member with a ready allocation.
-
3
Google Sheets - log the notification batch
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log the notification batch. - Open the club notifications log sheet
- Append a row for each member drafted today with the date, club tier, allocation name, and draft status
- Mark each row as Pending until staff confirms the email is sent
Done when Today's allocation batch is recorded in Google Sheets with pending status for every member.
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
Will it email club members without my team reviewing the drafts first?
No. Every notification is saved as a Gmail draft and logged in Google Sheets as pending. Your team reviews and sends each one, so no member receives a message without human approval.
Can it handle multiple club tiers with different messages?
Yes. Give WebRun a message template for each tier and it will personalize each draft using the member's tier and allocation details from Bottlecapps.
What if a member's allocation changes after the draft is created?
The log in Google Sheets shows each draft as pending. Your team can update the draft before sending if any allocation details change. WebRun re-reads Bottlecapps on each run, so changed statuses are reflected the next morning.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.