Data & Databases
Schedule Database Queries and Send Results to Telegram
7 nodes
282
125
Automatic trigger
Workflow Description
Automated workflow that executes MySQL queries on a defined schedule and sends results directly to Telegram channels. Ideal for recurring reports and database monitoring without manual intervention.
How it works
- 1.Trigger scheduled execution using Cron at specified intervals
- 2.Run MySQL query and retrieve data from your database
- 3.Format results and deliver them to Telegram automatically
Use cases
- Send daily sales reports from your database to the marketing team
- Monitor active users and alert management when thresholds are breached
- Schedule automated backups and confirm completion via Telegram notification
Requirements
- Active MySQL database connection credentials (host, username, password, database name)
- Telegram bot token and access to a channel or group for message delivery
- Correct Cron expression matching your desired execution schedule
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Schedule
Telegram
MySQL
Details
Trigger
Automatic trigger
Nodes
7
Apps
3
Views
282
Downloads
125
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (7)
On clicking 'execute'
Manual Trigger
Cron
Cron
Telegram
Set
Telegram1
Set
Webhook
Webhook
limparPacoteCliente1
My Sql
limpaPacoteCliente0
My Sql