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.

Источник