Package Cleanup and Telegram Notifications

Name: Package Cleanup and Telegram Notifications
Rating: 4.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

39 views

0 downloads

Data Managementautomationcleanupcrondatabasemysqltelegram

Cleans up old 'TRANSPORTE-RECEBIDO' package data from the database and sends Telegram notifications.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow automates the cleanup of old package data that are in the 'TRANSPORTE-RECEBIDO' state for more than one month. It then sends notifications to a Telegram channel about the completed cleanup for different clients.

Key Features

Deletes old package records from the database.
Uses MySQL queries for data manipulation.
Sends notifications to a Telegram chat.
Scheduled to run daily at 8 AM.

How To Use

Configure Database Credentials: Set up your MySQL credentials in n8n.
Configure Telegram Credentials: Set up your Telegram API credentials in n8n.
Adjust Cron Schedule: Modify the Cron node's triggerTimes if you need the workflow to run at a different time.
Verify Chat ID: Ensure the chatId in the Telegram nodes is correct for your desired notification channel.

Apps Used

automation

cleanup

cron

database

mysql

Workflow JSON

{
  "id": "40a97306-930d-4f1a-99a9-3c1434f116e3",
  "name": "Package Cleanup and Telegram Notifications",
  "nodes": 0,
  "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.