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

说明与用途

每周一早上发送的 KPI 摘要，让沙龙和诊所老板快速评估自动提醒等工作流程的效果。

问题

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

结果

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

工作流

• 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

证据

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

来源

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.

来源

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.

来源