How to record delete events in Google Spreadsheet -

i need record delete events in google spreadsheet using google apps script (delete cell or entire row) , cell number , user name.

function onedit(e) triggers when cells edited , not when deleted.

function onedit(e) {  var range = e.range; logger.log(range.getrow()); logger.log(session.getactiveuser().getemail());   if (range.getrow() === 3.0)    {     var recipient = "user@example.com";     var subject = 'roster notification';     mailapp.sendemail(recipient, subject, "hello, roster has been updated. please check. thanks.");    } } 

good news & bad news, i'm afraid.

you can use installable change trigger notified row deletions. (the full list of changes edit, insert_row, insert_column, remove_row, remove_column, insert_grid, remove_grid, format, or other).

the bad news event not tell what changed, if wish track changes roster, you'll need keeping track of changes yourself.

related issues google's issue tracker:

• spreadsheet onchange() trigger event parameter should more useful
• spreadsheet onchange() getactiverange() yields a1
• insert_row undo not changetype remove_row