Google Sheet trigger only works in test mode

new row trigger does not work when published, only in test mode. Would appreciate if you could fix, this is a must - have feature.

thanks