Dynamic email notification - workflow

How to
#1

Hello,
could you please advise how to create dynamic email notification for this case?
We have a table called Request where people from our company can request access to our clients. The field client is linked to another table called Clients where we have the list of all clients and responsible people from our company who approves the access (list of responsible people is linked to another table called Employees where we have their email addresses). The goal is to notify the right person for each client.

The logic is following Request.client = Clients.Client then Employee.Responsible Person.Email

What can be the best way to set it up?

#2

You can dynamically compose an email in the Run script workflow action.

Only variables are inserted in the Send email action, but we plan to insert dynamic emails within the Send email action in the future.