How can I get the oldValue of a cell, when the user deletes cell content? e.oldValue is undefined in this case
There is a plugin that will accomplish this for you. It takes the route of creating a hidden spreadsheet that mirrors the real one.
https://gist.github.com/tanaikech/73edaed1268a6d07118aed538aa5608d