Allow email notifications/automation with WorkApp credentials

CraigRCon

Is there a way to send notifications and alerts to users of a WorkApps through automation without providing the users access credentials to the underlying sheets in the WorkApps?

Currently, I have notifications triggered by dates and other metrics to ensure information remains fresh and current. However, since the users do not have access to the main sheet, they are not being notified. It seems to me that it defeats the purpose of combining sheets and reports into a WorkApps if automation is only viable if access is granted to the underlying sheets in the WorkApps.

If this is to appear and function as an app, then notifications and alerts should be managed and controlled within the app and based on the credentials of the app.