Google spreadsheet: Intercept calls before trigger (event) open

Question

I have a code into a spreadsheet (A) that does a copy of a sheet from another spreadsheet (B) the is activate from a trigger onOpen.

But trigger onOpen starts after 5 or 6 seconds, so a user can do some changes into the sheet. I would like to keep my sheet for those 10 seconds too. Have you an idea? I'm looking how to intercept calls before trigger open but I don't find documentation.

Thanks

Answer 1

You can install a onEditSs edit trigger on B (dont use the simple onEdit, instead install one). From there copy to A whenever the range changes (keep the last one copied on cache to minimize writes). This way A is always up to date even without opening it.