My IMPORTJSON functions return #GOOGLE_QUOTA_EXCEEDED

This is usually caused because Google limits the number of external requests you can send in one day (by using the appsScript UrlFetch function).

Free Google Workspace accounts are given 20,000 requests per day.

This is not exactly related to the number of importjson functions you use:
If you have many importjson functions, the spreadsheet cache is not big enough so it temporarily keeps the data on our server.
If you edit the spreadsheet, Google Sheets triggers recalculations pretty often and the functions use UrlFetch to get the cached data from our servers.

When will the counter be reset

It’s a daily quota. Unfortunately, Google doesn’t give more details on what time it will reset the quota.

How can I avoid this error?

  • If you don’t use many IMPORTFROMWEB functions, the issue is rather due to another script. You may try to disable other add-ons.
  • Try to lower the number of functions in your spreadsheet. ImportFromWeb allows you to fetch a range of URLs in one function. You can also put a range of selectors if you need to fetch several elements from the target pages.
  • If you use many functions in one spreadsheet, try to limit your activity in the spreadsheet so Google Sheets does not trigger recalculations so often.

You can find the official documentation on Google quotas here