Automated Clearing of Old Package Tags and Notifications

This n8n workflow is designed to automate the process of cleaning up outdated package labels in a database and notify relevant teams via Telegram. It can run manually or on a schedule, providing a flexible solution for managing package data.” The workflow includes a manual trigger for quick execution, a cron trigger for scheduled runs, and a webhook to allow external trigger activation. It executes MySQL queries to identify and mark old package entries as ‘DELETE’ based on their outdated status (older than one month). The process involves two separate database queries, each targeting different database connections, to ensure comprehensive cleanup. After the cleanup, the workflow sends notification messages to a Telegram chat, informing operators about the removal of package tags. This setup is particularly useful for logistics or warehouse management scenarios where regular data hygiene and real-time notifications are critical for operational efficiency.