How to trigger email and worklist notification to employees on expiry of their dependents visa

We have a requirement to trigger email notification and worklist notification to employees on expiry of their dependent’s(contacts) passport/visa.

We are trying to achieve this using Alerts Composer, having said that we are facing challenges in including both employee and dependents details in an alert and henceforth triggering emails and worklist notifications to employees.

If Anyone has encountered a similar scenario in your experience or possess any insights or solutions to address this requirement, we would greatly appreciate your guidance and assistance.