Document is [my_spreadsheet_id] missing (perhaps it was deleted?)

Question

Occasionally (actually it's happening quite often) I'm getting a "Document tIbdnvK2ZBY_7SQ2skESDvg is missing (perhaps it was deleted?)" error which obviously isn't true. Can anyone please put some light to this issue? Maybe some good solution to it?

Answer 1

I have a few scripts working on timers and occasionally get this error, it seems to happen when the sheet the script tries to access is too busy calculating or dealing with other requests (the old Google sheets would go offline sometimes hich caused this too).

It happens much less with the new Google sheets, and reducing the frequency is good too if possible- I moved to the form submit trigger then an hourly on top in case the first trigger fails.