What is a request?
The function counts a request when it manages to fetch a JSON from the target url. For instance, if fetching the content fails or if there is no element in the JSON that matches the filters, no request will be counted.The JSON is cached by default for 24 hours. Therefore, until the cache expires, using the same […]
Read full article
Control when the data updates
Google Sheets natively controls how the functions recalculate according to different behaviours (modifying cells, opening the spreadsheet, …). This is why, sometimes, you enter your spreadsheet and see your functions recalculating and your data loading. To avoid that IMPORTFROMWEB fetches the data source constantly, imported data are cached 24 hours by default (and up to […]
Read full article