search

bradjasper / ImportJSON

Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet
GNU Lesser General Public License v3.0
2.1k stars 1.06k forks source link

How to add timer? #234

Open mrfrankito opened 2 years ago

mrfrankito commented 2 years ago

Hello and thank you for this amazing code! https://puu.sh/IWNt6/5d8a15138d.png I am using multiple calls in cells and I am reaching max quotas limit very often. Therefore I would like to add a timer to update all cells every 1 hour, instead of automatic updates. Any ideas how can I do it? I've tried to add trigger but it doesn't work since it's custom function (cell function).

Thanks

pact-wheeler commented 2 years ago

I have the same question, I was so excited when I saw this...but no solution yet...

maddietodd commented 1 year ago

Same here.