Is there any option to print the user name that the google sheet file belongs to him? The one that resolved the comments the author gave him?
Thank you very much
CodePudding user response:
- Select File
- Select Details
- The owner is displayed
CodePudding user response:
The GetOwner() function returns the Owner User of the Spreadhseet.
function getUserName()
{
ss = SpreadsheetApp.getActiveSpreadsheet();
thisOwner = ss.getOwner();
Logger.log(thisOwner);
}
Reference: Spreadsheet.getOwner()