If Data studio doesn't have the capability to do this, can you recommend other applications where we can create a dashboard that can trigger alerts? Not necessarily an email alert, it can also be an alert in the actual dashboard itself. Appreciate your help!
You can do this in Google Sheets - Google App Script (Tools > Script Editor) would allow you to make a script that emails people based on values in the sheet. See here for documentation on the sheets and gmail script functions: https://developers.google.com/apps-script/