Send a Daily Mixpanel Digest to Telegram Every Morning
Each morning this pulls yesterday's numbers from Mixpanel, formats them into a readable digest, and posts it to Telegram — so the whole team starts the day on the same page without opening a dashboard.
- 1
Step 1 — Schedule the run
Add a
Schedule Triggerset to fire every morning (e.g. 08:00 in your timezone). - 2
Step 2 — Pull the metrics
Add a
Mixpanelnode (orHTTP Request/SQL query) that returns yesterday's key figures — revenue, sessions, spend, whatever Mixpanel tracks. - 3
Step 3 — Format the digest
Add a
Set(orCode) node that arranges the numbers into a scannable message with clear labels and, ideally, day-over-day deltas. - 4
Step 4 — Post to Telegram
Add a
Telegramnode. SetOperationtoSend Message, enter your chat ID, and build the message from the formatted digest. Create the bot with @BotFather and add its token as a credential.
Frequently asked questions
Can I add week-over-week comparison?
Yes — query two windows in Step 2 and compute the delta in Step 3 so the digest shows both the number and the trend.
What timezone does it use?
The `Schedule Trigger` runs in your n8n instance timezone. Set it in Settings so 08:00 means 08:00 where your team is.