Automated Art Studio Supply Restock Lists
Every Monday, WebRun opens Punchpass to see how many students are booked into this week's classes, checks expected clay, glaze, and material use against the running inventory in Google Sheets, and sends the studio manager a restock list on Telegram before supplies run short.
How do I automatically know when studio supplies need restocking?
WebRun checks Punchpass every Monday for how many students are booked into that week's classes, compares expected clay, glaze, and material use against the running inventory in Google Sheets, and sends the studio manager a restock list on Telegram naming what's low and how urgently. Nothing gets ordered automatically, so the studio can shop with real numbers instead of guesswork.
- Materials get reordered before a class runs short
- Restock decisions use actual bookings, not guesswork
- The manager gets one weekly list instead of checking shelves by hand
Built for ceramics studios · art studio managers · craft supply buyers · independent studio 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
punchpass.comin a real browser with your saved login - no setup, no API keys. -
1
Punchpass - count students booked into this week's classes
punchpass.com
WebRun opens Punchpass to count students booked into this week's classes. - Open Punchpass and pull the roster count for every class scheduled this week
- Note which classes use clay, glaze, or specialty materials
- Flag any class that's grown since last week's forecast
Done when This week's expected material use is estimated from live rosters.
-
2
Google Sheets - compare against current inventory
google.com
WebRun opens Google Sheets to compare against current inventory. - Open the studio's inventory sheet and check current stock levels
- Compare stock on hand against this week's forecasted use
- Mark any item projected to run out before Friday
Done when Every material at risk of running out this week is flagged.
-
3
Telegram - send the restock list
telegram.org
WebRun opens Telegram to send the restock list. - Send the studio manager a restock list naming each low item and how many classes it needs to cover
- Sort so the most urgent shortages appear first
Done when The manager has this week's restock list in Telegram.
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 place the supply order for me?
No. It only compiles the restock list and sends it to Telegram. Ordering from your supplier is still a decision your team makes.
How does it estimate how much material we'll use?
It reads this week's live Punchpass roster counts for every class, so the forecast reflects actual bookings, not a fixed average.
What if inventory counts are out of date?
It reads whatever is currently in your Google Sheets inventory, so keeping that sheet current keeps the restock list accurate.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.