kpi-bot
Installation
SKILL.md
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):
- What data do you want? (e.g., "daily bookings by category", "live coach count", "weekly signups")
- 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)
- 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: