Scheduled Cleanup of Transport Status Package Label Notification Workflow
This workflow is triggered either by a timer or a webhook to automatically clean up package label data in the database that is older than one month and has a status of "TRANSPORTE-RECEBIDO." It sends a notification to Telegram upon completion of the cleanup. This effectively addresses the issue of data accumulation for logistics package labels, prevents database redundancy, and ensures a tidy data environment. It is suitable for industries such as logistics and warehousing, enhancing operational efficiency, reducing manual operations, and achieving automation in data management with real-time notifications.
Workflow Name
Scheduled Cleanup of Transport Status Package Label Notification Workflow
Key Features and Highlights
This workflow automatically cleans package label data with the status "TRANSPORTE-RECEBIDO" older than one month from two databases (PPM and OBJ) via scheduled triggers or Webhook activation. It sends cleanup completion notifications through Telegram, enabling automated data maintenance and real-time alerts. Highlights include automated scheduled execution, multi-system coordinated operations, and instant message delivery, significantly enhancing operational efficiency.
Core Problems Addressed
It resolves the issue of long-term accumulation and delayed cleanup of expired logistics package label data, preventing database redundancy and data clutter. Meanwhile, it ensures relevant personnel receive timely cleanup status updates via Telegram, maintaining a clean data environment and transparent information flow.
Application Scenarios
Applicable in logistics, warehousing, supply chain management, and other industries requiring periodic cleanup of transport status package data—especially in workflows involving multi-database management and the need for immediate notifications to stakeholders.
Main Process Steps
- Automatically triggered daily at 8:00 AM via a Cron node or manually triggered through a Webhook interface.
- Executes an SQL update on the PPM database to delete package labels older than one month with the status "TRANSPORTE-RECEBIDO."
- Performs the same cleanup operation on the OBJ database concurrently.
- Upon completion, sends two separate notification messages to predefined Telegram groups, informing about the cleanup status of the PPM and OBJ systems respectively.
Involved Systems or Services
- MySQL Databases (PPM and OBJ)
- Telegram Messaging Service
- n8n Automation Platform (Cron scheduling and Webhook triggering)
Target Users and Value
- Logistics data administrators and operations personnel
- Supply chain management teams requiring clean package label data in databases
- Enterprise users aiming to reduce repetitive manual tasks and improve data management efficiency through automation tools
This workflow enables users to achieve automatic, periodic cleanup of package label data with real-time notifications, significantly reducing manual maintenance costs while improving data management standards and business responsiveness.