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 10h, 10hours, 10 hours or even just 10.

As any other options of IMPORTFROMWEB, there are 2 ways to call the cacheLifespan option :

=IMPORTFROMWEB(data_sources, selectors, "cacheLifespan:2days")


1cacheLifespan2 days
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.

Other ways to control how your data is updated:

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