Summarize weekly appointment KPIs into a Monday digest: an n8n workflow (JSON included)

Description and use

A weekly KPI digest sent every Monday morning lets salon and clinic owners quickly assess the effectiveness of automated reminders and other workflows.

Problem

Salon and clinic owners lack a simple way to verify whether automation workflows (reminders, waitlists, rebooking) actually reduce no‑shows and improve revenue.

Outcome

Owners receive a concise weekly KPI digest that includes deltas, making it possible to confirm whether automation workflows improve performance.

Workflow

• 1. Trigger n8n workflow on Monday 08:00
• 2. Pull appointment rows from booking source
• 3. Validate each row (parse starts_at, status in {completed,no_show,cancelled}, numeric revenue_eur)
• 4. Log invalid rows to kpi_errors sheet
• 5. Aggregate metrics for current week and previous week using agg() function
• 6. Compute deltas and top source
• 7. If no rows, emit {empty_week:true} and send “No completed appointment data found” message
• 8. Format digest text block
• 9. Send digest via chosen messaging channel

Evidence

The numbers live in a booking tool behind four clicks, so nobody looks. Six weeks later the workflows are still running on faith.

Source

Every Monday at 08:00, before the first customer walks in, the owner reads: how many appointments, what share showed up, no-show rate, cancellations, revenue, and which booking source brought in the most completed visits.

Source

The workflow validates every row before it counts: starts_at must parse, status must be one of completed, no_show, cancelled, revenue_eur must be numeric.

Source