google-sheetsgoogle-apps-scriptgoogle-account

Google sheets script exceeds "maximum execution time" in ONE account


I created a new Google sheet with one script: https://raw.githubusercontent.com/Eloise1988/COINGECKO/refs/heads/master/CoinGeckoV2.gs

The sheet has just one cell with a simple function from the script: =GECKOPRICE("eth")

As expected, it runs perfectly except for my usual Google account, where I get the error "exceeded maximum execution time".

When I share this sheet from a different account and run it with my usual account, it runs. And when I share this sheet from my usual account and run it with the other account, it doesn't run. So to my understanding, the error is not about the account I'm logged in with, but about the account owning the sheet/script.

I thought this would be a short lived glich but it's been this way for weeks now. Any idea what I could do to overcome it?

Both accounts are the ordinary free Google accounts, by the way.


Solution

  • Chances are that one of the accounts has run out of its daily quota.

    There's a limit of 20,000 UrlFetchApp.fetch() calls per day per account.

    See Quotas for Google Services.

    Decrease the number of custom function formulas in the spreadsheet, and/or edit the following line to make results stay in cache longer:

    const expirationInSeconds = 6 * 60 * 60; // the max is six hours