Sorry, we don't support your browser.  Install a modern browser

Stack calls/split cron jobs for auto cache#224


When connected with the api solution to google sheets the auto cache is doing parallel calls to all of the conencted spreadsheets/projects. If you have a lot connected it causes “Too many requests” and the data is subsequently not updating correctly. At the moment the only option is to disable the api solution (or ask google for a quota increase), and it becomes less secure. Is there any way of not making all the calls at the same time e.g. stack the calls, split the cron jobs or something similar so it won’t cause the error.

a year ago