I have a Google Spreadsheet that uses a number of
import() functions, including the third-party
importJSON() function. It all works great, except that I keep apparently exceeding the limit on how many times per day I can perform the
urlfetch() function (used in
importJSON()). I'm not manually updating the sheet with any frequency at all, but I can only make maybe 30 or so manual sheet changes before I begin getting these errors.
I believe that Google Sheets itself may be updating all these calls every minute, which at I believe 7 instances of the function, times every minute, may be causing the limit to be hit. If my theory doesn't hold water, someone please correct/inform me as to what may actually be happening.
I'd like to find some way to reduce the frequency of updates. In a perfect world I'd love it to only update when I manually ask it to, but Google Sheets doesn't appear to provide such an option.
Is there any way to reduce or slow down the frequency of function calls?