How to get an email that changes a google spreadsheet?

Question

Google Sheets

I would like to indicate the author of the changes in the column after the change is made.
There is an onEdit trigger, but how can I find out the username/soap of the person who makes the edit?

Answer 1

For simple triggers like onEdit and custom functions , the user object is not available , you can see this if you make the following code:

function onEdit(e) {
  SpreadsheetApp.getActiveRange().setValue(Utilities.formatString("email: %s",e.user.getEmail() ));
}

But no one forbids to make another function and assign it a trigger "On change" ( Edit - Triggers of the current project - Adding a trigger - onEditTrigger - Main deployment - From table - On editing - Save ):

function onEditTrigger(event) {
        var userEmail = event.user.getEmail();                  //Email пользователя
  //Что-то делаем...
};