Excel Power Automation - Sending Emails to Users Based on Sheet Criteria

Hi All!

My organization currently uses a website called Smartsheets to create task lists. I've created automations that run each morning that send emails to users if a task becomes past due.

It fulfills the intended purpose; however, every single month there seems to be some new issue; therefore, I'd like to transfer over to using functionality in native Excel.

My research turned me on to Power Automation. I found the tools I needed until I hit a roadblock: P.A. does not look at the contact within the sheet and send a message to that person. It appears to just go to one designated individual.

Any thoughts, recommendations, or solutions? I am almost at the end of my rope and ready to just deal with Smartsheets.

A screenshot of our task list can be found in the comments. Maybe it provides some reference that I missed.

Thanks!