My =IMPORTFROMWEB() functions return #GOOGLE_QUOTA_EXCEEDED

This is usually because you have reached the Google daily quota of external requests you can send in one day (by using the appsScript UrlFetch service).

The Google Apps Script URL Fetch service allows scripts to make HTTP requests to external web services. And the daily quota for URLFetchApp requests varies based on the type of Google account you have: free Google Workspace accounts are given 20,000 fetch calls per day, while paid accounts are given 100,000 fetch calls.

Please note that this is not exactly related to the number of ImportFromWeb formulas or requests you use. For example, when you edit the spreadsheet, Google Sheets may trigger recalculations and this consumes your Google quota, or you may use other third party app that consumes your quota as well.

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 reduce 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.
  • We’ve noticed that GOOGLEFINANCE() triggers very frequent recalculations of the whole spreadsheet. Using GOOGLEFINANCE() with many ImportFromWeb functions is a frequent cause of #GOOGLE_QUOTA_EXCEEDED

You can find the official documentation on Google quotas here