How to send push notifications to a user when you post some news in your application (ignore comments)
There are several posts in the forum regarding this. Your best bet would be to use a google script or Zapier to monitor the sheet and send out emails. Here are some that I found.
You could check this out too incase WhatsApp notifications interest you.