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
Please check your spreadsheets for excessive use of these functions and reduce them where possible.
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.
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
urlfetchservice 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.
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.
- 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.
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.