0

In Google Sheets, I'm manually invoking the 3rd party importJSON() function for a few cells. There's absolutely no way that I can see, that I can be exceeding the 20,000 requests-per-day quota as I have only 8 total cells that use this function, and I'm invoking it manually when I need it, so it's not even updating On Change (which is what my spreadsheet is set to calculate on).

I can't be doing more than a few hundred requests total per day - and that's on a VERY heavy-use day which would be rare. Typical usage is probably a few dozen total requests in a day (refreshing the data just a few times). Why on earth do I keep getting Service invoked too many times for one day: urlfetch.?

  • 1
    Nope, none at all. This is the only sheet I'm using. Unless somehow sheets that aren't even open, but simply exist in my GDrive, are updating all day and somehow count against the limit? – Jonathan van Clute Aug 19 '17 at 20:28
  • That is actually a possibility. You earlier mentioned recalculation being set to some intervals in a spreadsheet; maybe it's similar in others. Not being open in a browser does not prevent activity. One way to test this is to create a brand new Google account and work with your importJSON spreadsheet there. – user135384 Aug 19 '17 at 22:50
  • OK wow... I never at all would have thought that files which are not open in any way, would somehow be live updating all the time... that seems utterly crazy to me, but I'll go see if I have any others that are using this function. Pretty sure I don't but, will make certain! – Jonathan van Clute Aug 19 '17 at 23:47
  • OK nope, definitely have no other sheets that are using this function at all. No idea how I could possibly be getting even close to a fraction of a fraction of the limit. – Jonathan van Clute Aug 19 '17 at 23:53
  • 1
    Yep sure is. I also haven't run into this in quite some time but probably because I moved to a manual-script-execution-only method for the bulk of my calculations. So now unless I push a button, very little updates. – Jonathan van Clute Oct 31 '17 at 23:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.