Common Issues (Google Sheets)

URL Fetch Limit

Google limits plug-in users to 20,000 data pulls per day. If you run into this limit, you will observe the following error: Service invoked too many times for one day: urlfetch.

Each call counts as 1 data pull.

Sharing Sheets

When sharing sheets, be advised that the URL Fetch Limit counts towards the owner of the sheet. Therefore if you share a sheet, it is recommended you share it in View Only mode in order to reduce data pulls counted towards yourself.

Performance

Google Sheets has a few performance limitations that ultimately reduce the quality of offering we can provide. Namely,

Only 30 functions can run simultaneously. If more than 30 functions are requested, the remaining functions are queued and will wait until up-stream functions are finished.

Share sheets in View Only mode.