Automation connecting names and users

Hey!
Can I make a automation that if there is a name of a person in one table it will tag the person (or the user)?
We have a big table that contains names of all our employees and their team lead. This table is sync with google sheets by Zapir. I used a formula in another page to connect between the employee and his team lead, when the employee name appears. What I need is that when the team lead name appears that person will get a notification. Is there a way to do so?

Thank you🙏