Send a Daily PostgreSQL Digest to Telegram Every Morning
Each morning this pulls yesterday's numbers from PostgreSQL, 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
PostgreSQLnode (orHTTP Request/SQL query) that returns yesterday's key figures — revenue, sessions, spend, whatever PostgreSQL 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.
Alert on Cold Chain Temperature Excursions Before Product Spoils
A cold chain excursion discovered at delivery means spoiled product and rejected shipments. Monitor temperature loggers in transit and alert the moment any reading breaches limits.
n8nSlackTwilioSend a Daily Google Analytics Digest to Slack Every Morning
Each morning this pulls yesterday's numbers from Google Analytics, formats them into a readable digest, and posts it to Slack — so the whole team starts the day on the same page without opening a dashboard.
n8nSlack
Log Pool Chemical Readings and Alert on Out-of-Range Levels
Keep pools safe by logging each visit's chemical readings and instantly alerting the office when levels fall outside the safe range.
n8nGoogle SheetsSlack