Weekly Scheduling Dashboard and Gap Report
Every Monday morning, an automated scenario pulls your week's bookings from Calendly and Google Calendar, calculates fill rate against your target, identifies open gaps, and posts a formatted summary to Slack. No manual reports, no guessing, no missed revenue.
The Problem
Appointment slots are perishable inventory. Once Tuesday at 2pm passes unfilled, that revenue is gone forever. But most service businesses don't know their scheduling fill rate until the week is already over.
The average service business operates at 60 to 75% of appointment capacity. Moving from 65% to 80% utilisation can increase revenue by 20 to 25% without adding staff or hours. That's not a rounding error. For a five person practice billing $200 per appointment, it's the difference between coasting and growing.
The data already exists inside your scheduling tools. Fewer than 20% of users actually review their scheduling analytics on a regular basis. Managers spend two to four hours each week manually compiling metrics (when they bother at all), and by the time they spot a problem, Thursday's empty afternoon is already yesterday. Performance conversations happen reactively. "Why was last week so quiet?" instead of "Thursday has three open slots, let's fill them today."
Your scheduling tool probably has a reports tab. You've clicked on it twice. That's the real problem: the insights exist, but nobody looks at them until the revenue has already walked out the door.
How It Works
A Make or n8n scenario runs every Monday morning before your first meeting. It pulls booking data, crunches the numbers, and delivers a formatted summary straight to your team's Slack channel. Here's the full sequence.
1. Scheduled trigger fires on Monday morning
The automation runs on a fixed schedule, typically 7am Monday. No manual trigger, no remembering to pull a report. It just happens, every week, before anyone opens their laptop.
2. Pull this week's bookings from your scheduling tools
The scenario connects to your booking platforms (such as Calendly, Google Calendar, or Acuity) and pulls every appointment for the coming week. It also grabs your defined working hours and blocked time so it knows what counts as an "available slot."
3. Pull prior week's results for comparison
Last week's data gets fetched in parallel: total bookings, cancellations, and no shows. This gives you a week over week comparison so you can spot trends, not just snapshots.
4. Calculate utilisation metrics
The scenario compares booked slots against available capacity and calculates fill rate, cancellation rate, and no show rate. It flags whether you're above or below your target utilisation (say, 80%).
5. Identify specific open gaps
Instead of a single number, the automation pinpoints exactly which slots are open: "Tuesday 2 to 4pm, Thursday 10am, Friday 3pm." Each gap is tagged with the team member and service type so you can act on it immediately.
6. Post formatted summary to Slack
A Block Kit message lands in your chosen Slack channel with total bookings, fill rate, cancellation count, no show count, week over week trend, and a list of specific gaps. Your entire team sees the scheduling health at a glance.
7. Trigger waitlist notifications for open slots
If your fill rate is below target, the scenario can automatically notify waitlisted clients about available times. A simple email or SMS goes out: "A spot just opened on Thursday at 10am. Would you like to book?" Proactive gap filling like this increases fill rates by 15 to 20%.
Why Checking the Calendar Doesn't Count
Every manager thinks they know how full the schedule is. They glance at the calendar, see a reasonable spread of appointments, and move on. But "looks about right" isn't a number.
Do you know your no show rate? Not a guess. The actual percentage, tracked over four weeks. Do you know which team member is consistently 30% busier than the others? Which day of the week is reliably underbooked? Whether your cancellation rate is climbing?
A dental practice running at what they assumed was "full capacity" discovered a 14% no show rate once they started tracking it. That's one in seven appointments. Fourteen percent of their revenue was evaporating every week, and nobody noticed because the calendar looked full on Monday morning.
The calendar shows you what's booked. It doesn't show you what's missing. And it definitely doesn't tell you what to do about it. That's the gap between a scheduling tool and a scheduling system.
From Reporting to Reacting
A weekly report is useful. A weekly report that triggers action is worth ten times more.
The difference matters. When the automation identifies three open slots on Tuesday afternoon and your fill rate is sitting at 68%, it doesn't just tell you. It sends a notification to your waitlisted clients offering those exact times. If you've connected a social media integration, it can post "Spots available this Tuesday afternoon" to your Facebook page or Instagram story.
Practices that run weekly scheduling reviews have 10 to 15% higher utilisation than those that don't. But the review itself isn't the magic. It's the speed of response. By the time a human manager spots Monday's empty slots, compiles the waitlist, drafts the message, and sends it out, it's Wednesday. The automation does all of that before 7:15am on Monday.
And the data compounds. After a month of weekly reports, you start seeing patterns that are invisible in a single snapshot. Tax season versus summer. Monday mornings versus Friday afternoons. The team member who's booked solid while everyone else has gaps. Those patterns turn into decisions: shift hours, run promotions on slow days, hire to match demand instead of guessing.
The Business Impact
Take a four person professional services team. Each person has 30 available appointment slots per week at $200 per slot. That's $24,000 in total weekly capacity across the team.
At 65% utilisation (the industry average), you're billing $15,600 per week. At 80% utilisation (a realistic target with proactive gap filling), you're billing $19,200. That's $3,600 more per week, or $187,200 per year in recovered revenue. From the same team, the same hours, the same office.
The automation also saves your manager two to four hours per week on manual reporting. At $80 per hour, that's another $8,300 to $16,600 per year in recovered time. Time they can spend on client work or business development instead of counting appointments in a spreadsheet.
Setup cost for this automation is typically $500 to $1,500. It pays for itself in the first week.
- Fill rate, cancellation rate, and no show rate delivered to Slack every Monday before 8am
- Specific open gaps identified by day, time, and team member
- Week over week trend tracking so you spot patterns early
- Automatic waitlist notifications for underbooked days
- Two to four hours per week saved on manual report compilation
- 15 to 20% improvement in fill rates through proactive gap filling
Frequently Asked Questions
What scheduling tools does this work with?
The automation connects to any platform with an API. Calendly, Google Calendar, Acuity Scheduling, and Cliniko are the most common. If your team uses multiple tools (one for online bookings, another for internal scheduling), the scenario pulls from all of them and consolidates the data into a single report.
How do you track no shows if our scheduling tool doesn't flag them?
Most scheduling tools don't natively track no shows. The automation uses a simple workaround: any appointment that wasn't marked as "completed" or "attended" by end of day counts as a no show. If your tool supports webhooks, we can also set up real time status updates so the data is even more accurate.
Can we customise what counts as an "available slot"?
Yes. You define your working hours, lunch breaks, admin blocks, and any recurring commitments. The automation calculates utilisation against your actual available capacity, not a generic eight hour day. If different team members have different schedules, each one gets their own availability profile.
We're already fully booked most weeks. Do we really need this?
"Fully booked" and "fully attended" are different things. Even at 100% booking rate, a 12% no show rate means you're running at 88% actual utilisation. This automation surfaces those hidden gaps and helps you fill them through overbooking recommendations for high risk slots or same day waitlist notifications.
Can the report go somewhere other than Slack?
Absolutely. The summary can be posted to Microsoft Teams, emailed as a formatted digest, or logged to a Google Sheets dashboard with charts and trend lines. Slack is the most common destination because teams already live there, but the output format is flexible.
What does the waitlist notification actually look like?
It's a short, personalised message sent via email or SMS to clients who've opted into your waitlist. Something like: "Hi Sarah, a 10am slot just opened this Thursday. Would you like to book it?" with a direct link to confirm. No phone tag, no back and forth. The client taps once and the gap is filled.
How long does setup take?
Most implementations are live within one to two weeks. The core reporting scenario (pull data, calculate metrics, post to Slack) takes a few days. Adding waitlist notifications and social media posting adds another week. The longest part is usually defining your availability rules and target utilisation, not the technical build. Book your free audit and we'll map out exactly what your version looks like.
Sources
Automations we’ve already built
Thirty days after onboarding begins, an automated workflow surveys your client, pulls milestone data from your project tools, generates an AI written retrospective, and flags anyone who needs a recovery call. Every onboarding teaches the next one.
When a new client lands in your practice management software, this automation generates a tailored engagement letter with the right services, fees, and deadlines, sends it for electronic signature, then builds the client folder and kicks off your onboarding checklist. No chasing. No waiting.
A project manager fills out a short form after a discovery call. Within minutes, AI drafts a full Statement of Work into your branded template, routes it through Slack for internal approval, and sends it to the client for signature.
When a project closes in your PM tool, this automation collects every contract, deliverable, and sign off from across your systems, organises them into a standardised archive folder, and generates a summary PDF. No manual cleanup required.
When a contact is tagged in your CRM as needing an NDA, the agreement is generated from a template with their details prefilled, sent for signature, and tracked automatically. Overdue NDAs trigger reminders so nothing slips through.
Automatically converts raw meeting notes or recordings into structured, branded board minutes with tracked resolutions and action items, so your admin staff can stop spending full days on documentation that nobody reads until it's too late.
Capture scope changes on site, generate costed PDFs, route them through internal approval and client e signature, and log everything automatically. No verbal agreements, no lost paperwork, no payment disputes.
When a new contract lands in your cloud folder, an AI agent extracts the text, checks every clause against a risk framework, and sends your team a structured memo flagging the problems that actually matter. Preliminary review drops from hours to minutes.
When a new contractor lands in your HR system or Airtable base, this automation generates a complete document bundle, sends it as a single signing package through PandaDoc, and updates your records the moment everything is signed.
When a deal hits the proposal stage in your CRM, this automation pulls the client name, scope, pricing, and line items, then merges everything into a branded template. The finished PDF lands back on the deal record and in the prospect's inbox without anyone touching a document.
When every party signs a document in DocuSign or PandaDoc, this automation downloads the completed PDF, renames it to your filing convention, stores it in the right client folder, and notifies the account manager. No manual downloading, no misfiled contracts.
A scheduled workflow scans your contracts database daily, flags renewals at 30, 14, and 7 day intervals, and sends tiered alerts to account managers and leadership so nothing expires unnoticed.
When a new client is created in your CRM, this automation builds their billing profile, generates the first invoice, sets up recurring payments, and sends a secure link to collect their payment method. No manual data entry between systems, no forgotten first invoices.
When a project is marked complete in your project management tool, this automation pulls billable hours and rates, generates a branded PDF invoice, and emails it to the client with payment instructions. A copy lands in the client folder without anyone lifting a finger.
When a new patient books an appointment, this automation sends digital intake forms, collects consent and insurance details, converts everything to PDF, files it in the patient folder, and notifies your front desk. No clipboards. No data entry.
An AI agent that turns your meeting recordings into structured summaries, assigned action items, and tracked tasks across Slack, Asana, and Notion. No more post meeting admin, no more forgotten decisions.
An automated workflow pulls client KPIs from your data sources on the first business day of each month, populates branded report templates, converts them to PDF, and emails every client their personalised report before your team starts work.
Automatically classify incoming contracts by type, route each one to the right reviewer, and track every document through the review pipeline so nothing stalls in someone's inbox.
When a new B2B client submits their intake form, this automation reads every team member's role and sends each person the exact onboarding content they need. Billing contacts get payment setup. Project sponsors get the timeline. Day to day operators get tool access and kickoff details. Every stakeholder's progress is tracked independently until all are ready.
When a new client record lands in your CRM with a signed engagement letter, a prefilled contract is automatically generated and sent for e signature. No copying, no delays, no forgotten clauses.
When a prospect opens your proposal, this automation logs the view in your CRM, pings the assigned salesperson on Slack, and sends a templated follow up email if the document stays unsigned after 48 hours.
When a real estate agent fills out a short form with property details and buyer information, the automation generates a complete contract of sale, attaches the correct disclosure forms, and sends the full package to DocuSign with the right signing order.
Automatically converts approved quotes into signed service contracts with warranty terms, payment schedules, and scope definitions. No manual paperwork, no verbal agreements, no disputes three months later.
When a vendor sends a contract, AI extracts payment terms, liability caps, termination clauses and auto renewal dates into a structured row. Your procurement team can then compare every vendor agreement side by side, spotting bad deals before anyone signs.
Not ready to talk yet? Start here.
Everything we've learned building 300+ automations for small businesses, in one practical guide. Written for business owners, not engineers.
- Where your team's hours are actually disappearing
- The five automations worth setting up first and why
- How to calculate what manual work is actually costing you
- A step by step checklist to get your first automation live this week
Completely free.