Automated Daily Package Cleanup with Telegram Alerts
Schedules cron jobs to clean old 'TRANSPORTE-RECEBIDO' packages from MySQL database and sends Telegram notifications. Includes webhook for on-demand execution.
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
- Platform
- n8n
- Category
- Other
- Price
- $14.99
- Creator
- Tomas Zielinski
- cron
- telegram
- mysql
- database-cleanup
- scheduling
- notifications
- webhook
- logistics
- automation
- packages
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related Other workflows
- Build your first AI agent$9.99
- Automate Daily Lead Outreach from Google Sheets via Outlook$9.99
- Automate Lead Generation by Scraping Emails from Google Maps to Google Sheets$14.99
- Real-time crypto market analysis with GPT-4o-mini and CoinMarketCap APIs via Telegram$2.99
- Automate Comprehensive Jira Project Setup with AI and Form Integration$24.99
- Book and manage appointments with Google Calendar and Gmail$14.99
More from Tomas Zielinski
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.