All templates
For med spa managers, aesthetic clinic front desk teams & multi-provider cosmetic practices

Start every day with a clear schedule and gap report

Every morning, WebRun opens Aesthetic Record, compiles today's appointment schedule by provider and room, identifies open gaps that could be filled, logs the summary to Google Sheets, and posts the digest to your team's Slack channel before the first client arrives.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every day at 7:00 AM WebRun
1 Aesthetic Record pull today's appointment schedule
2 Google Sheets log the daily schedule digest
3 Slack post the digest to the team channel
Run a sample
In short

How do I automatically get a daily schedule and gap report for my med spa each morning?

WebRun pulls today's appointment schedule from Aesthetic Record every morning, organizes it by provider and room, flags open gaps and unconfirmed bookings, logs the summary to Google Sheets, and posts the digest to Slack before the first appointment. The entire digest is internal and reaches only your team.

  • Every team member knows the full day's schedule before the first client arrives
  • Open gaps are surfaced proactively so front desk can offer slots to the waitlist
  • Daily schedule data is logged automatically for occupancy trend analysis

Built for med spa managers · aesthetic clinic front desk teams · multi-provider cosmetic practices · medspa operations managers

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

  2. 1
    Aesthetic Record - pull today's appointment schedule
    aestheticrecord.com
    WebRun in Aesthetic Record: pull today's appointment schedule
    WebRun opens Aesthetic Record to pull today's appointment schedule.
    • Open Aesthetic Record and pull today's full appointment schedule
    • Organize appointments by provider and treatment room
    • Identify open time slots of 30 minutes or more that could accommodate a booking
    • Flag any appointments that are unconfirmed or marked as tentative

    Done when Today's schedule is compiled with provider, room, open gaps, and unconfirmed appointments.

  3. 2
    Google Sheets - log the daily schedule digest
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: log the daily schedule digest
    WebRun opens Google Sheets to log the daily schedule digest.
    • Open the daily schedule tracking sheet and append today's summary row
    • Record the total appointments, total open slots, and a breakdown by provider
    • Save the sheet for weekly and monthly trend tracking

    Done when Today's schedule summary is logged in Google Sheets.

  4. 3
    Slack - post the digest to the team channel
    slack.com How to Automate Slack
    WebRun in Slack: post the digest to the team channel
    WebRun opens Slack to post the digest to the team channel.
    • Post the daily schedule digest to the team channel, showing each provider's appointments and open slots
    • Highlight the largest gap blocks that could be offered to waitlist clients
    • Flag unconfirmed appointments so the front desk can follow up before the client is due

    Done when Your team has the full schedule digest in Slack before the first appointment.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.aestheticrecord.com
ScheduleRuns automatically on this cadence
Every day at 7:00 AM
DeliveryHow each run's result reaches you
Schedule digest · Slack
OutputWhat each run produces - A daily schedule digest showing appointments by provider, open gaps, and unconfirmed bookings, posted to Slack and logged to Google Sheets.
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

Does it post anything to clients or patients?

No. This digest is entirely internal. WebRun posts the schedule summary to your Slack team channel only. No client or patient data is sent externally.

How does it identify slots that could be filled?

WebRun flags any contiguous open time of 30 minutes or more within normal operating hours as a fillable gap. Your team can adjust the minimum gap size during setup.

Can I track schedule trends over time?

Yes. Each daily digest is logged as a row in Google Sheets, so you can analyze occupancy rates, peak days, and provider utilization over any period.

Put this on autopilot.

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