google-apps-scriptquotagoogle-workspace-add-ons

App-script runtime error "Exceeded maximum execution time" in workspace addon


Problem:

I am getting the error Exceeded maximum execution time after about 45 seconds.

Expected behaviour:

The function should run for 6 Minutes. After that duration I would expect an error. I checked up the current quota limits here: https://developers.google.com/apps-script/guides/services/quotas#current_limitations

My setup for testing:

I tried to remove all code and just have a single function "runFor6Min()" which only executes:

Utilities.sleep(6000 * 10)

I assume that the function should be treated as a Script runtime (6 Min) and not as a Custom function runtime (30s) e.g. a custom function within a Google Sheet.

Any ideas what else I could try?

Appended appsscript.json enter image description here


Solution

  • If you use CardService to call server side functions, you're limited to 30s of execution time as written in the documentation:

    Warning: The Apps Script Card service limits callback functions to a maximum of 30 seconds of execution time. If the execution takes longer than that, your add-on UI may not update its card display properly in response to the Action.