ManualTrigger Automate

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.

7/8/2025
7 nodes
Simple
webhooksimpletelegrammysqlautomationschedulecommunicationbotintegrationapidatabasedata
Categories:
Communication & MessagingSimple WorkflowData Processing & AnalysisWebhook Triggered
Integrations:
TelegramMySQL

Target Audience

  • 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.

    • Problem Solved

  • 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.

    • Workflow Steps

  • 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.

    • Customization Guide

  • To customize the Telegram messages, modify the text fields in the Telegram nodes to reflect the desired notifications.
    - Adjust the cron job timing by changing the hour parameter in the Cron node to fit your scheduling needs.
    - Update the MySQL queries in the respective nodes to target different tables or conditions based on your database structure and requirements.
    - Enable or disable the manual trigger node depending on whether you want to allow manual execution of the workflow.