All templates

Automated Finished Piece Pickup Reminders

Every morning, WebRun checks the pickup log in Google Sheets for pieces marked ready after the latest glaze firing, matches each one to the client's contact info in Punchpass, drafts a pickup-ready text via Twilio, and updates the log so nothing sits on the shelf forgotten.

Runs on WebRun · Strict Lockdown policy
Every morning at 9:00 AM WebRunorchestrates each step
1 Google Sheets check which pieces are marked ready
2 Punchpass match each piece to the client's contact info
3 Twilio draft the pickup-ready text
In short

How do I automatically remind clients to pick up finished pieces?

WebRun checks the studio's Google Sheets pickup log each morning for pieces marked ready after the latest glaze firing, matches each to the client's contact details in Punchpass, and drafts a pickup-ready text via Twilio for review. Drafts wait for staff approval, so clients get a timely nudge to collect their work and shelf space clears faster.

  • Finished pieces get claimed faster, freeing up shelf space
  • No client forgets a piece sitting since their last class
  • Pieces waiting over 2 weeks get flagged automatically

Built for ceramics studios · pottery studios · paint your own pottery shops · studio front desk staff

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

  2. 1
    Google Sheets - check which pieces are marked ready
    google.com
    WebRun in Google Sheets: check which pieces are marked ready
    WebRun opens Google Sheets to check which pieces are marked ready.
    • Open the studio's pickup log and filter to pieces marked ready since the last glaze firing
    • Note how many pieces belong to each client
    • Flag anything that's been sitting more than 2 weeks

    Done when Every newly fired, ready piece is listed by client.

  3. 2
    Punchpass - match each piece to the client's contact info
    punchpass.com
    WebRun in Punchpass: match each piece to the client's contact info
    WebRun opens Punchpass to match each piece to the client's contact info.
    • Look up each client's phone number and preferred contact in Punchpass
    • Confirm the client is still active, not a one-time drop-in with stale contact info
    • Note their name exactly as it should appear in the text

    Done when Every ready piece has a confirmed contact to reach.

  4. 3
    Twilio - draft the pickup-ready text
    twilio.com
    WebRun in Twilio: draft the pickup-ready text
    WebRun opens Twilio to draft the pickup-ready text.
    • Draft a short pickup-ready text naming the piece and studio pickup hours
    • For pieces waiting over 2 weeks, add a gentle mention of the studio's storage policy
    • Leave each text as a draft. Do not send automatically

    Done when A ready-to-send draft text exists for every client with a finished piece.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
punchpass.com
ScheduleRuns automatically on this cadence
Every morning at 9:00 AM
DeliveryHow each run's result reaches you
Draft pickup texts · Google Sheets
OutputWhat each run produces - A list of finished pieces ready for pickup, matched to each client with a drafted pickup text for approval.
Text
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 text clients without approval?

No. Every pickup-ready text is drafted via Twilio and left for your team to review and send. Nothing goes out on its own.

How does it know a piece is actually ready?

It reads the pickup log your team keeps in Google Sheets, so it only flags pieces someone has already marked ready after firing.

What about pieces sitting a long time unclaimed?

It flags anything waiting more than 2 weeks so staff can send a firmer reminder or apply your storage policy.

Put this on autopilot.

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