IntuitiveTables can do this
https://www.intuitivetables.com/
It looks like there's no direct sound for "Notification" but it can be added.
You could still get a sound to play in this situation, but the same sound will play when action is required elsewhere as well.
First enable "Notification Detection" and keep it on "Urgent Queue"
Then enable "Table Urgent" table sound:
I will try to make sure a notification sound can be played in the next beta version.
Please reach out to us on discord
https://discord.com/invite/9NnURTpYGY that way we can let you know when the notification sound has been added. You can also contact us if you have any issues getting the sound to play on a notification the way I instructed above.