Automated Daily Package Cleanup with Telegram Alerts
Schedules cron jobs to clean old 'TRANSPORTE-RECEBIDO' packages from MySQL database and sends Telegram notifications. Includes webhook for on-demand execution.
This workflow automates the cleanup of outdated package records in a MySQL database, specifically targeting 'pacoteProduto' items in 'TRANSPORTE-RECEBIDO' status older than one month. It uses a cron trigger set for 8 AM daily to execute a SQL query that identifies and marks these records for deletion by updating their 'modulo' to 'DELETE'. Upon successful cleanup for 'PONTO MIX', it sends a Telegram notification to a specified group chat.
A parallel path supports on-demand cleanup via a webhook
Platform
n8n
Category
Other
Price
$14.99
Creator
BestWorkflows
cron
telegram
mysql
database-cleanup
scheduling
notifications
webhook
logistics
automation
packages
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.