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.

How can I see what scripts or add-ons are using my quota?

You can visit https://script.google.com/home/executions 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.

Want to Import Data efficiently to Google Sheets?

SyncWith is a Google Sheets add-on and relies on Google services to operate correctly. In order to update your spreadsheets, SyncWith has to call Google's urlfetch service approximately 50 times per day, many orders of magnitude less than if you’re using various import functions.
This is made possible because SyncWith will call an API externally and return all the data in a single update to your spreadsheet.

Google Sheets Triggers

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.
View installed trigger: https://script.google.com/home/triggers
If you review your triggers, and the SyncWith (API Pipeline) trigger is disabled, please attempt to delete it, then close and reopen the SyncWith addon, which should reinstall the trigger.

Don’t Have SyncWith?

  • SyncWith is a Google Sheets Add On
  • SyncWith allows you to move data from any API into Google Sheets
  • Learn more about why Marketers love SyncWith
  • ⭐️⭐️⭐️⭐️⭐️ Reviewed by hundreds of Google businesses
  • Check out our Google Workspace Listing and see why we’re the highest rated API add on with over 100,000 installs. Install today and get your data into Sheets in minutes.

How Does SyncWith Work?

notion image

Discover the APIs we support syncing to Google Sheets

SyncWith supports over 1000 APis including Facebook, Google Ads, Google Analytics, Instagram Posts, Tik Tok, YouTube, Yahoo Finance, Shopify, MySQL, Postgres, Twitter and Notion. See the top 100 APIS you can sync to Google Sheets.