Automated Package Cleanup and Notification

Name: Automated Package Cleanup and Notification
Rating: 5 (5 reviews)
Author: Free N8N

Intermediate

20 nodes connected

detail.loadingPreview

Free N8N Temples

186 views

0 downloads

Data Managementautomationcleanupcrondata hygienemysqltelegramwebhook

Cleans up old 'TRANSPORTE-RECEBIDO' packages from a database and sends Telegram notifications for two different systems.

About This Workflow

This workflow is designed to automate the cleanup of outdated package data in a MySQL database. It targets records with the status 'TRANSPORTE-RECEBIDO' and the module 'pacoteProduto' that are older than one month. The cleanup process is executed twice, targeting two different database credentials (PPM and OBJ). After the cleanup, Telegram notifications are sent to a specific chat ID, indicating the completion of the operation for each system.

Key Features

Scheduled Execution: Triggered by a cron job to run daily at 8 AM.
Database Cleanup: Utilizes MySQL queries to remove old package records.
Dual Database Support: Connects to two separate MySQL databases (PPM and OBJ) for cleanup.
Conditional Deletion: Only deletes records older than one month.
Telegram Notifications: Sends confirmation messages to a Telegram chat upon successful cleanup for each database.
Manual Trigger: Includes a manual trigger for on-demand execution.
Webhook Integration: Listens for a webhook to trigger the cleanup process.

How To Use

Cron Node: Configure the Cron node to schedule the workflow. The current configuration triggers it daily at 8 AM.
Manual Trigger Node: The On clicking 'execute' node allows for manual execution. Enable this node to test the workflow.
Webhook Node: The Webhook node listens for incoming requests on the /limparPacotes path. This can be used to trigger the workflow from external systems.
MySQL Nodes:
- limpaPacoteCliente0 connects to the PPM MySQL database and executes the cleanup query.
- limparPacoteCliente1 connects to the OBJ MySQL database and executes the same cleanup query.
Telegram Nodes:
- Telegram sends a notification to the specified chatId after limpaPacoteCliente0 is executed.
- Telegram1 sends a notification to the same chatId after limparPacoteCliente1 is executed.

Connections:

The Cron and Webhook nodes trigger both limpaPacoteCliente0 and limparPacoteCliente1 nodes.
limpaPacoteCliente0 is connected to Telegram.
limparPacoteCliente1 is connected to Telegram1.

Apps Used

automation

cleanup

cron

data hygiene

mysql

webhook

Workflow JSON

{
  "id": "c5f181dc-c4fd-483a-b48a-0ffd7ee6b38b",
  "name": "Automated Package Cleanup and Notification",
  "nodes": 20,
  "category": "Data Management",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.