JUHE API Marketplace

MySQL Package Cleanup Automation

Active

For the ManualTrigger Automate platform, this workflow automates the cleanup of outdated package records in MySQL, triggered by webhooks or scheduled daily at 8 AM. It sends notifications via Telegram upon completion, ensuring timely communication and efficient data management.

Workflow Overview

For the ManualTrigger Automate platform, this workflow automates the cleanup of outdated package records in MySQL, triggered by webhooks or scheduled daily at 8 AM. It sends notifications via Telegram upon completion, ensuring timely communication and efficient data management.

  • Database Administrators: Those managing MySQL databases looking to automate data cleaning processes.
  • Developers: Individuals who need to integrate Telegram notifications into their applications.
  • Business Analysts: Professionals who require automated reporting and data management solutions.
  • System Administrators: Users responsible for scheduling tasks and ensuring system maintenance without manual intervention.
  • Automation Enthusiasts: Individuals interested in creating automated workflows to enhance productivity.
  • This workflow automates the process of cleaning up outdated records in a MySQL database, specifically focusing on entries marked as 'TRANSPORTE-RECEBIDO' that are older than 1 month.
  • It sends notifications via Telegram to inform users when the cleanup process is completed for different clients, ensuring timely communication and reducing manual follow-up efforts.
  • The integration of a webhook allows for immediate execution of the workflow upon receiving a specific trigger, enhancing responsiveness.
  • Trigger: The workflow can be initiated either manually or automatically at 8 AM daily using a cron job or via a webhook.
  • Database Cleanup: Two MySQL nodes execute a query that updates the status of outdated records to 'DELETE'.
  • Notification: After the database cleanup, two separate Telegram notifications are sent to inform about the successful completion of the cleanup for different clients.
  • Flexibility: The workflow allows for both scheduled and immediate execution, providing versatility in operation.

Statistics

7
Nodes
0
Downloads
37
Views
2596
File Size

Quick Info

Categories
Communication & Messaging
Simple Workflow
+2
Complexity
simple

Tags

webhook
api
integration
schedule
telegram
automation
communication
bot
+4 more

Boost your workflows with Wisdom Gate LLM API

Supporting GPT-5, Claude-4, DeepSeek v3, Gemini and more.

Enjoy a free trial and save 20%+ compared to official pricing.