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.
I also would love to see this feature. We use notifications on almost every sheet, and it's very inconvenient for our users to not be able to click the notification in the email and be taken to the App.