Home > Back-end >  Finding google sheets owner name
Finding google sheets owner name

Time:10-20

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:

  1. Select File
  2. Select Details

Details in file menu

  1. The owner is displayed

Document details

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()

  • Related