The cacheLifespan option defines the time in hours, days or weeks during which you want to keep your data before it is fetched again.
Google Sheets controls how the functions recalculate according to different behaviours (modifying cells, opening the spreadsheet, …)
To avoid that IMPORTFROMWEB fetches the data source constantly, the content is cached 24 hours by default. Therefore, whenever IMPORTFROMWEB recalculates, the content is retrieved from the cache.
You can customize the cache lifespan by setting the cacheLifespan option to the value you want the cache to last.
Values can be in hours, days or weeks. It accepts different syntaxes like
10 hours or even just
As any other options of IMPORTFROMWEB, there are 2 ways to call the cacheLifespan option :
=IMPORTFROMWEB(data_sources, selectors, "cacheLifespan:2days")
|3||=IMPORTFROMWEB(data_sources, selectors, A1:B1)|
Bear in mind that the function will not necessarily update directly after the cache expires but only when Google Sheets lets the function recalculate.
cacheLifespan is available from the Premium plan. The maximum value for cacheLifespan depends on your plan: 15 days for Premium, 30 days for High Volume.
Use automatic triggers if you need the function to update periodically.
See Set up automatic updates
Control the cache lifespan for all the functions in your spreadsheet through the sidebar
See Use the sidebar