Maximum time exceeded on Google Docs

Hi, I have a sleep function built into my google doc that accesses target user information from the API. It fails out after 250ish entries (I'm aiming for 1 per second- I use Torn Tools, so I don't want to get close to my 100 per minute).


Start Function Error Message Trigger End
11/25/20 12:34 AM myFunction Exceeded maximum execution timetime-based 11/25/20 12:40 AM

I am looking at adding filters so it doesn't update the entire list every time and therefore avoids the timeout, but I'm curious if anyone else has run into this and what can be done about it.

Your function is possibly just slow?
Try doing batch updates, instead of modifying cells one by one.

The function is intentionally slow, because the API only allows 100 updates per minute. So it is entirely about Google terminating long-running scripts.