I am using a google sheet as a database and all I need is to get the user's identity to display the proper info. I included the following code to retrieve the user's email address:
var userEmail = Session.getActiveUser().getEmail();
But all it gives me is a blank string since I published the app to run under my account. One alteative is to publish the app as the user accessing it, but that would mean having to share the google sheet with all the users in order for them to access that data.
Is there any work around?