I update my Google Sheet every day by copying and pasting 300 lines, and I use the Google Sheet watch change module. However, I have the impression that when I paste 300 lines at once, it does not register the updates to the sheet. Can someone help me resolve the trigger issue after a bulk copy and paste? Thank you very much for your help.
You could try to use Google Apps script @Nadege_Baklouti . There is an onEdit() function in there which should work more stable.
1 Like