# Notify DingTalk on new Azure DevOps pull requests with user mentions
This workflow automates notifications about new pull requests in Azure DevOps by sending structured messages to a DingTalk group chat. It uses a MySQL database to map Azure DevOps accounts to DingTalk profiles, ensuring accurate mentions of reviewers and team members.
## Who it´s for
- Developers using Azure DevOps and DingTalk for communication
- DevOps engineers setting up automated notifications
- Teams in China where DingTalk is the primary messaging platform
- IT leads aiming to integrate CI/CD pipelines with internal chat systems
## What the automation does
- Triggers on a new pull request creation via Azure DevOps HTTP webhook
- Loads user mapping from a MySQL database (Azure DevOps → DingTalk)
- Constructs a formatted markdown message with reviewer mentions and PR link
- Sends the message to a designated DingTalk group via bot webhook
- Handles special group references (e.g., ´团队´ maps to ´所有人´)
## What´s included
- Ready-to-use n8n workflow
- Webhook trigger and event handling logic
- Integrations with Azure DevOps, DingTalk, and MySQL
- Basic setup and adaptation guide
## Requirements for setup
- Azure DevOps account with access to pull request events
- Configured DingTalk bot webhook with message posting permissions
- MySQL database with user mapping table (TFS → DingTalk)
- n8n instance capable of receiving and processing HTTP requests
## Benefits and outcomes
- Eliminates manual PR monitoring
- Accelerates team response with instant notifications
- Ensures correct user mentions across different identity formats
- Supports flexible user mapping through a centralized database
- Enhances code review transparency
- Simplifies team changes and onboarding
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet