This n8n workflow automates the process of cleaning up old package transport status tags in a MySQL database and sending notifications via Telegram. It can be triggered manually, at scheduled times, or via a webhook, making it versatile for different operational needs.
The workflow begins with a trigger, either manual, scheduled daily at 8 AM, or through a webhook, providing flexible activation methods. Once triggered, it executes two separate MySQL queries to update package status tags in two different databases, marking outdated ‘TRANSPORTE-RECEBIDO’ entries as ‘DELETE’. This cleanup ensures that the database remains current and uncluttered.
After the database updates, the workflow automatically sends two Telegram messages to a designated group, informing the team about the processed packages. This notification helps keep stakeholders updated on the package status changes without manual intervention.
This workflow is practical for logistics and warehouse management where regular data cleanup and team notifications are essential for operational efficiency. It ensures timely database maintenance and real-time communication, reducing manual work and potential errors.
Reviews
There are no reviews yet.