Hi everyone, I wanted to share a Node-RED flow I built to solve a common problem: missing important notifications and struggling with manual logs.
This flow automatically logs events to a MySQL database (with timestamps and all relevant data) while sending instant Telegram notifications with rich formatting, including images and multi-chat support. It also has built-in error handling and retry mechanisms to make sure alerts don't get lost.
The setup is simple and should take about 15 minutes: just import the JSON flow, configure a few nodes like the database and Telegram bot tokens, and you’re live.
I’m happy to provide setup tips, answer questions, and hear any feedback or feature requests.
Has anyone else created similar flows, or do you have other strategies for reliable alerting and event logging in Node-RED?
I think most people who've been here a while have created flows along these lines at some point.
Personally, I have a standard flow that listens to a specific set of MQTT topics and formats a Telegram output. I send data to those topics whenever I want some kind of information or alert on my phones. I have several Telegram bots. For example: a low-message-volume one for the family to use and a higher volume one with more detailed information for my own monitoring use.
I think mine is a bit simpler and easier to integrate. You can call the service within your LAN by passing the parameters you need.
I’ve also prepared a version that, instead of receiving parameters through a REST call, gets them by subscribing to an MQTT topic.
Both MQTT and REST APIs can be used by anyone — home automation systems, ESP32, Shelly devices, etc.
I believe this is the best integration approach.
It is a standard 1ByOne 433MHz wireless doorbell. I use an RFX transceiver dongle with Max's excellent RFX nodes. I have a standard flow that listens to everything from the RFX, splits the inputs by known/unknown devices and outputs known devices in a standard, enhanced format to MQTT.
