Determine current user in Apps Script

by

GOOD NEWS: It’s possible with this workaround!

I’m using some protection functionality that reveals the user and owner of the document and I’m storing it in the properties for better performance. Have fun with it!

function onEdit(e) {
  SpreadsheetApp.getUi().alert("User Email is " + getUserEmail());
}

function getUserEmail() {
  var userEmail = PropertiesService.getUserProperties().getProperty("userEmail");
  if(!userEmail) {
    var protection = SpreadsheetApp.getActive().getRange("A1").protect();
    // tric: the owner and user can not be removed
    protection.removeEditors(protection.getEditors());
    var editors = protection.getEditors();
    if(editors.length === 2) {
      var owner = SpreadsheetApp.getActive().getOwner();
      editors.splice(editors.indexOf(owner),1); // remove owner, take the user
    }
    userEmail = editors[0];
    protection.remove();
    // saving for better performance next run
    PropertiesService.getUserProperties().setProperty("userEmail",userEmail);
  }
  return userEmail;
}

More Related Contents:

  1. Is it possible to ‘prefill’ a google form using data from a google spreadsheet?
  2. How to protect the Apps Script code in a Google spreadsheet?
  3. Is there a way to evaluate a formula that is stored in a cell?
  4. Automatic timestamp when a cell is filled out
  5. Apps Script: how to get hyperlink from a cell where there is no formula
  6. How to auto select range from a filter without having to manually enter it?
  7. Script to Change Row Color when a cell changes text
  8. Sheet.getRange(1,1,1,12) what does the numbers in bracket specify?
  9. You do not have permission to call openById
  10. Google Apps Script, copy one spreadsheet to another spreadsheet with formatting
  11. Single Google Form for multiple Sheets [duplicate]
  12. How do I communicate a page(modal dialog) with its sibling (sidebar)?
  13. How to replace text in Google Spreadsheet using App Scripts?
  14. copy data from one sheet to another in google app script and append a row, one small issue
  15. Using built-in spreadsheet functions in a script
  16. Google App Scripts cannot be given Authorization or Permission
  17. How to get the correct range to set the value to a cell?
  18. Refresh data retrieved by a custom function in Google Sheet
  19. How to extract the link from a cell now that links are not reflected as HYPERLINK?
  20. Google Apps Script: Dynamically creating spreadsheet menu items
  21. Increment Cell value by one by clicking
  22. email notification if cell is changed
  23. Dynamic selection options in Google Apps Script for forms
  24. Apply multiple font colors to the text in a single Google Sheets cell
  25. How to evaluate a spreadsheet formula within a custom function?
  26. Google Sheet use Importxml error could not fetch url [duplicate]
  27. On Edit doesnt work if cell auto updates – Need a workaround Google Sheets
  28. How to ignore empty cell values for getRange().getValues()
  29. We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED
  30. e.range.getA1Notation() unable to track changes caused by formula update

Leave a Comment