kpi-bot

Build a daily KPI bot that sends a formatted Slack message with data from Databricks. The user will describe what data they want — your job is to write the SQL, format it for Slack, create or update an n8n workflow, and send a test message.

Step 1: Understand the Request

Ask the user (if not already clear from $ARGUMENTS):

1. What data do you want? (e.g., "daily bookings by category", "live coach count", "weekly signups")
2. Which Slack channel? (get the channel ID — they can find it by right-clicking the channel → View channel details → copy the ID at the bottom)
3. What time should it send? (default: 8pm MT)

Remind them: the bot must be invited to the channel first — /invite @LeLoop in the target channel.

Step 2: Write the SQL

Query leland_analytics.ai tables by default. Key tables and columns:

bookings (approved orders only):