n8n Execution History Auto-Cleanup Workflow
This workflow is designed to periodically scan and automatically delete old execution records that have been running for more than 10 days, thereby maintaining a clean and efficient system and preventing redundant data from occupying storage resources. By regularly cleaning up expired execution records, users can effectively manage historical data, ensuring system performance and response speed. Additionally, it supports manual triggering for testing and debugging purposes, simplifying data cleanup operations for maintenance personnel and enhancing the operational efficiency of the automation platform.
Tags
Workflow Name
n8n Execution History Auto-Cleanup Workflow
Key Features and Highlights
This workflow periodically scans and automatically deletes execution records older than 10 days, maintaining the cleanliness and efficiency of the n8n system while preventing redundant data from occupying storage resources. It also supports manual triggering for testing purposes, facilitating debugging and validation.
Core Problem Addressed
As n8n automation workflows continue to run, historical execution data accumulates, causing database bloat that negatively impacts system performance and increases maintenance costs. This workflow ensures system stability and responsiveness by automatically cleaning up expired execution records.
Use Cases
- n8n automation platform users who need to regularly maintain execution history data
- Enterprise automation process management to prevent excessive historical data from degrading system performance
- Operations personnel seeking to simplify data cleanup tasks on the n8n platform
Main Process Steps
- Use the “Schedule Trigger” node to trigger the workflow at a fixed time daily
- Retrieve all execution records via the “n8n list execution” node
- Filter execution records with start times older than 10 days using the “If” node
- Delete qualifying historical execution records by invoking the “delete execution” node
- Perform “no operation” on records that do not meet the criteria to keep the workflow clear
- Support immediate testing through the “Manual Trigger” node
Involved Systems or Services
- n8n Automation Platform API (used for querying and deleting execution records)
Target Users and Value
- n8n platform administrators and operations personnel
- Automation workflow developers focused on system performance and data management
- Any users building automation workflows with n8n who require regular maintenance of execution history
By using this workflow, users can efficiently and automatically manage n8n execution history, reduce manual intervention, and enhance the operational efficiency and stability of the automation platform.
Batch Message Sending with External Approval Waiting Workflow
This workflow focuses on batch processing customer data, sending personalized messages one by one through rate limiting, while generating approval links for external personnel to confirm. It combines batch processing, timed waiting, and external event triggering mechanisms to ensure that message sending is orderly and the process is controllable. It is suitable for scenarios requiring personalized marketing and online approval, effectively avoiding request overload and enhancing automation efficiency and customer experience. It is designed for use by automation operators, sales teams, and customer service departments.
Google Cal to Zoom Meeting
This workflow automatically retrieves meeting schedules from Google Calendar for the next 12 hours and creates Zoom online meetings based on those schedules. Through secure authentication, it ensures a seamless connection between Google Calendar and Zoom, supporting both scheduled and manual triggers. This greatly enhances the efficiency and accuracy of meeting arrangements, avoiding duplicate operations and omissions. It is suitable for various scenarios, including remote working teams, sales personnel, and educational institutions.
Low Stock & Sold Out Watcher for Shopify
This workflow is designed to automatically monitor the inventory status of a Shopify store. When the inventory falls below a set threshold or a product is sold out, it promptly sends a notification to a designated Discord channel. The notification includes the product name, inventory quantity, variants, and images, helping the operations team to stay updated on inventory dynamics in real time, respond quickly to restocking needs, optimize sales strategies, and avoid sales losses due to stockouts.
Syncro Alert to OpsGenie
This workflow automates the reception of alarm information from the Syncro monitoring system and automatically creates or closes alarms in OpsGenie based on the alarm status. It retrieves information in real-time through Webhook and intelligently determines whether the alarm has been resolved, ensuring that the operations team can respond promptly and improving the accuracy and efficiency of alarm handling. It is suitable for IT operations teams and technical support departments, helping them reduce manual operations and optimize the alarm management process.
Get SSL Certificate
This workflow is primarily used for the automatic monitoring of the SSL certificate status for specified domain names, ensuring website security. It can detect in real-time whether the certificate has expired and sends instant alert notifications via Telegram when it does, helping users respond promptly to security risks and enhancing the website's accessibility and user trust. It is suitable for website administrators, operations personnel, and security teams, addressing the cumbersome issue of manual checks and ensuring that certificates remain valid at all times.
Real-time Monitoring of New ServiceNow Tickets with Slack Notifications
This workflow implements real-time monitoring of newly created tickets in the ServiceNow system. It automatically retrieves the most recently created tickets every 5 minutes, organizes their details, and pushes them to a designated Slack channel. Additionally, if any exceptions occur during the connection process, error notifications will be sent promptly to enable the operations team to respond quickly. This process effectively enhances ticket handling efficiency, ensures that critical events are not overlooked, and improves collaboration and information flow among teams.
Send Daily Weather Updates via Message Using the Gotify Node
This workflow automatically retrieves weather data for Berlin every day and sends instant push notifications via the Gotify service, helping users quickly stay updated on the latest weather conditions. Users do not need to check manually, which enhances the efficiency of planning for both personal and professional activities, such as travel planning and event organization. By utilizing scheduled triggers and real-time notifications, it ensures that users receive timely information about weather changes, thereby improving the accuracy and safety of their plans.
Slack Webhook - Verify Signature
This workflow is designed to verify the message signatures from Slack Webhooks, ensuring the authenticity of the message source and preventing malicious requests and data tampering. By implementing a signature verification mechanism using the HMAC SHA256 algorithm, users can enhance security in automated processes integrated with Slack, avoiding phishing and forgery attacks. It is suitable for enterprise security teams and developers, simplifying the security protection of automated systems and ensuring the credibility of Webhook data.