Weekly Failures Report

This workflow automatically queries the execution records of a specified workflow every week, filtering out the failed executions from the past week, and sends a summary report to the user via Telegram. This feature helps users stay informed about any anomalies in workflow operations, improves operational efficiency, and reduces the risk of business interruptions. It is suitable for automated operations teams and enterprise users who need to track process status. Through this automated mechanism, users can effectively monitor the health status of workflows without manual intervention.

Tags

n8n monitoringfailure report

Workflow Name

Weekly Failures Report

Key Features and Highlights

This workflow automatically queries the historical execution records of a specified n8n workflow every 7 days, filters out failed executions from the past week, and consolidates all failure information into a single message. The report is then pushed to users via Telegram, enabling timely awareness of workflow anomalies.

Core Problems Addressed

Automates monitoring of n8n workflow execution status to prevent unnoticed failures, thereby improving operational efficiency and workflow stability while reducing the risk of business interruptions.

Application Scenarios

  • Automated operations teams monitoring workflow statuses
  • Enterprises or teams requiring regular tracking and troubleshooting of automation failures
  • Any scenario relying on n8n automation workflows that needs prompt notification of exceptions

Main Process Steps

  1. Scheduled Trigger: Initiates the workflow once every 7 days.
  2. Retrieve Historical Executions: Calls the n8n API to fetch all historical execution records of the target workflow.
  3. Filter Weekly Failures: Filters executions from the past 7 days that did not complete successfully.
  4. Generate Failure Messages: Creates detailed alert texts for each failed execution, including workflow name, execution link, and date.
  5. Aggregate Messages: Combines all failure messages into a single text.
  6. Push Notification via Telegram: Sends the consolidated failure report to a specified chat through a Telegram bot.

Involved Systems or Services

  • n8n: Utilizes n8n’s built-in API to retrieve execution data.
  • Telegram: Uses a Telegram bot to push failure report messages.

Target Users and Value

  • Automation operations engineers and DevOps teams
  • Enterprise users managing automation workflows on the n8n platform
  • Professionals aiming to enhance automation system stability and promptly detect and respond to anomalies
  • Any users who wish to receive workflow status notifications via instant messaging tools

By automating data collection and instant messaging notifications without manual intervention, this workflow significantly improves operational efficiency and response speed in monitoring workflow health.

Recommend Templates

Slack-GitHub User Info

This workflow automatically queries detailed information for a specified GitHub username by receiving user commands in Slack, and sends the organized information back to Slack as a message, making it easy for team members to quickly access developer information. It effectively addresses the cumbersome process of manually searching for information, enhancing communication efficiency and collaboration experience. By integrating Webhook triggers, flexible GraphQL queries, and custom functions, it ensures that the information is accurate and free of redundancy, making it suitable for various scenarios such as development teams, project managers, and human resources.

Slack IntegrationGitHub Query

Error Notification Workflow

This workflow focuses on the automatic capture and processing of error events from other workflows, generating real-time error alert messages and sending them to designated groups via Telegram. This mechanism effectively shortens fault response time, enhances system stability, and ensures that operations and business personnel can promptly understand issues. It is suitable for automated process monitoring, unified error management, and status tracking for DevOps teams. With simple configuration, users can achieve efficient error notifications, ensuring business continuity.

error notificationauto alert

FetchGithubIssues

This workflow regularly fetches the latest open issues with the "Bug" label from a specified GitHub repository, focusing on critical issues with fewer than 5 comments. It automatically retrieves and filters qualifying issues every 10 minutes, pushing their titles and links in real-time to a designated Telegram user for quick bug monitoring and notifications. This approach helps the development team stay informed about important defects in the project, enhances issue response speed and communication efficiency, and simplifies the manual monitoring process.

GitHub MonitoringBug Alerts

n8n_check

This workflow regularly monitors the RSS Feed of n8n's official GitHub Releases, automatically filtering for new version information containing specific keywords that were released on the same day. It sends push notifications through a Telegram group and AWS SES email to ensure that users are promptly informed of important updates. It supports scheduled daily runs as well as manual triggers, helping operations and development personnel efficiently track the status of the tool, enhancing the timeliness and convenience of information retrieval, and avoiding the need for frequent manual checks.

n8n monitoringversion alert

User Information Management Chained Request Workflow

This workflow is triggered with a single click, allowing for the retrieval, creation, and updating of user information. It demonstrates an efficient process using HTTP request nodes for REST API chaining. The workflow supports retrieving user lists, adding new users, and updating user information, automatically linking the operational steps to ensure a smooth data flow. It significantly enhances the efficiency and accuracy of user data management, making it particularly suitable for scenarios that require frequent maintenance of user information, reducing human errors and ensuring real-time data updates.

User ManagementChained Requests

Automatic Association of GitHub Pull Requests with Pipedrive Contacts

This workflow automatically listens for Pull Request events in GitHub and retrieves the corresponding contacts in the Pipedrive CRM system based on the email of the PR submitter. If a contact is found, the system adds PR-related notes to their record, ensuring that development activities are synchronized in real-time with customer information. This automation significantly enhances the collaboration efficiency between the software development team and the sales team, reduces errors caused by manual operations, and helps the company better manage customer relationships and project progress.

GitHub AutomationCRM Integration

Backup Workflows to Git Repository (Automated Workflow Backup to Git Repository)

This workflow automatically backs up all workflows to a designated GitHub repository, ensuring data security and version management. Through scheduled triggers, the system checks for the existence of backup files and content differences, performing incremental updates and commits to keep the repository in sync with the workflows. This process simplifies backup operations and reduces the risk of data loss due to human error or failures, making it suitable for operations personnel, DevOps teams, and individual developers, thereby enhancing the security and traceability of the workflows.

n8n BackupGitHub Versioning

OpenAI Assistant for HubSpot Chat

This workflow implements the integration of HubSpot chat with the OpenAI intelligent assistant, automatically handling customer inquiries and providing instant responses. It manages chat thread IDs through Airtable to ensure continuity of conversation context. Additionally, it supports calling external APIs based on OpenAI's feedback to expand functionality and enhance the intelligence level of customer interactions. This solution is suitable for automating customer service, sales assistance, and real-time data queries, aiming to improve customer satisfaction and operational efficiency.

Intelligent ServiceMulti-turn Dialogue