Automated Daily Package Cleanup with Telegram Alerts

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 endpoint ('limparPacotes'), which runs a similar query for 'OBJETIVA' records and notifies the same Telegram chat upon completion. The manual trigger is disabled, emphasizing scheduled and API-driven automation. This setup ensures databases remain lean, preventing bloat from stale logistics data.

Benefits include reduced storage costs, improved query performance, and proactive alerting for operations teams. Ideal for e-commerce, logistics, or shipping businesses tracking packages, it saves hours of manual SQL maintenance and provides instant visibility into cleanup events via Telegram, enabling quick issue resolution.