Those who know me know I don’t like to complicate things.
Whenever possible, I prefer lean, fast, elegant solutions.
You don’t always need to build complex software or monumental architectures — sometimes all it takes is a few lines of code, a bit of mental agility, and the right tools.
🔗 What is Pipedream?
Pipedream is an online platform that allows you to:
✅ connect different services and apps (APIs, databases, cloud, notifications, etc.)
✅ write and run small scripts in Node.js, Python, and other languages without setting up a server
✅ create workflows that trigger when something happens (e.g. a new order in the database, a new message in an app, a file change)
👉 In short: it’s like a smart “glue” that lets you automate operations without developing a full app or installing anything.
🔗 What is Telegram?
Telegram is a messaging app that allows you to:
✅ send messages, photos, videos, and files securely across devices
✅ create groups and channels to communicate with friends, teams, or large audiences
✅ use bots and advanced tools for automation, notifications, and integrations
👉 In short: it’s a fast, secure, and versatile communication platform that goes beyond simple chats.
📌 Practical example
In business, you often have to wait for an event: order confirmation, a status change, an approval.
The problem?
You can’t sit in front of a page or management system for hours waiting. You have work to do — and the information needs to reach you automatically when needed.
Let me show you a concrete example that you can replicate or adapt.
🗂 Real scenario
Imagine you have a MySQL database with a table called arc_order containing:
CREATE TABLE arc_order (
arc_order_id INT AUTO_INCREMENT PRIMARY KEY,
arc_order_number VARCHAR(50),
arc_order_customer VARCHAR(100),
arc_order_quantity INT,
arc_order_status VARCHAR(20), — e.g. Pending, Accepted, Shipped
arc_order_date DATETIME DEFAULT CURRENT_TIMESTAMP
);
Your goal:
👉 Receive a Telegram message as soon as an order changes status to “Accepted”, showing the ordered quantity.
🤖 How does the flow work?
✅ Pipedream queries the arc_order table every few minutes (e.g. every 5 minutes)
✅ It looks for orders where arc_order_status = 'Accepted'
✅ It sends a message to your Telegram bot with the order number and quantity
✅ It updates the record to avoid duplicate notifications
💻 Pipedream code example (Node.js)
javascriptCopiaModificaconst mysql = require(‘mysql2/promise’);
const axios = require(‘axios’);
// Database connection
const connection = await mysql.createConnection({
host: process.env.DB_HOST,
user: process.env.DB_USER,
password: process.env.DB_PASS,
database: process.env.DB_NAME
});
// Get accepted orders not yet notified
const [rows] = await connection.execute(
“SELECT arc_order_id, arc_order_number, arc_order_quantity FROM arc_order WHERE arc_order_status = ‘Accepted'”
);
for (const order of rows) {
const message = `✅ Order ${order.arc_order_number} accepted. Quantity: ${order.arc_order_quantity}`;
// Send Telegram notification
await axios.post(`https://api.telegram.org/bot${process.env.TELEGRAM_TOKEN}/sendMessage`, {
chat_id: process.env.CHAT_ID,
text: message
});
// Update status to avoid duplicates
await connection.execute(
“UPDATE arc_order SET arc_order_status = ‘Notified’ WHERE arc_order_id = ?”,[order.arc_order_id]); } await connection.end();
🛠 How to set up the bot on Telegram (summary)
1️⃣ Search for BotFather on Telegram and create a new bot using /newbot
2️⃣ Get the API token
3️⃣ Start a chat with your bot (so you can get the chat_id)
4️⃣ Insert the token and chat_id as environment variables in Pipedream
🛑 How to stop the process
✅ In Pipedream:
Disable or delete the workflow with a click
✅ In Telegram:
Delete or deactivate the bot via BotFather
Or simply stop sending messages from your workflow
✨ Why is this approach useful?
✅ No need for big systems or costly development
✅ Integrates with what you already have (MySQL, Telegram bot)
✅ Saves your time and attention
A perfect example of how a simple idea and the right tools can make all the difference.
🌐 If you want to see more practical examples and fast solutions for managerial and business needs:
👉 www.francescoboschi.com/coding
📌 Legal notice
Pipedream and Telegram are mentioned purely as technical examples for educational purposes.
I have no official ties or collaborations with these platforms.
