Hi there,
I will be happy to help you with that Google Script. We can fix the existing code such that the cells are updated correctly "the error is probably because the code selects the wrong ranges while updating the cells".
We can also add few lines of code to alert you using email if that parameter occurs.
I am specilized on Google Apps Scripting, all of my reviews are related to that field.
I will be happy to address any of your questions!
Sincerely,
Mohamed