Service invoked too many times for one day: urlfetch

Colin Dellow

Colin Dellow

In order to promote efficient programming and fair use of shared resources, Google limits how often this function can be called. If your Google account, across all of its spreadsheets, formulas and scripts, calls this function more than 20,000 times per day, you will begin seeing errors in SyncWith.
Most of the time, you do not need to worry about this. However, if you see error messages like:
Service invoked too many times for one day: urlfetch
Then you are exceeding this limit. The only solution is to reduce your usage of this service and wait a day for the quota to reset.
Common culprits that can cause high usage of the urlfetch service are:
  • ImportAPI formula function
  • ImportJSON formula function
  • UrlFetchApp.fetch AppsScript function
Please check your spreadsheets for excessive use of these functions and reduce them where possible.

Step 1: What scripts or add-ons are using my quota?

Visit to see all recent Google Apps Script functions that have run. Well-behaved scripts should only run a handful of times per hour at most.
  1. Visit
  1. Review the scripts/tools that are running
  1. Identify any that are running very often that are not SyncWith (which might show up as API Pipeline)
  1. Stop or remove any tools using too much quota
  1. Wait 24 hours for your quota to reset

Step 2: Ensure your Google Sheet trigger is enabled

SyncWith relies on a trigger, installed with Google, to get updated tokens to required to read/write from your sheet.
If you’re hitting quota issues with the SyncWith Google Sheets addon, one possibility is that our trigger has become disabled.
  1. Visit: to find a list of triggers
  1. Identify which trigger is for the SyncWith addon, it might be called API Pipeline
  1. If the trigger is disabled, then you’ve found the problem!
    1. Delete the trigger
    2. Uninstall our google sheets addon (don’t worry all your reports and data will be safe)
    3. Reinstall our google sheets addon