In Google Spreadsheet I am having the following issue:
I am using
Session.getActiveUser().getUserLoginId() to fetch the current user's email id but other than creator of the spreadsheet it is returning empty string. I have also used
getEffectiveUser() but no help.
I have even deployed this to "User accessing the web app" but still it's not working.
How can I fix this?