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 4 weeks subscribing to our Premium or High Volume plans).
Therefore, whenever IMPORTFROMWEB recalculates, the content is retrieved from the cache and it is not counted as new requests.
See our article on how to set up the cache duration.
This said, there are 2 ways to update your data, let’s check them out.
It is possible to fetch the latest data as many time as you want, whenever you decide.
You select in your spreadhseet the cell that contains the function you want to recalculate and ImportFromWeb goes to the webpage to scrape it again.
Note that the RUN button works either for 1 single function or for all the functions within your active sheet or even all the functions of your spreadsheet. Just select the appropriate option on the drop-down menu.
=IMPORTFROMWEB( ) functions can be executed automatically even though the spreadsheet is closed or even though you’re offline. Again, setting up an automatic trigger can be done through the sidebar (check out our step by step video)
The scope of automatic triggers is the related spreadsheet (with all its tabs) and it applies for all the functions in that spreadsheet. Triggers can be set on a hourly, daily or weekly basis.
Note that you always keep an eye on all your triggers. Access to your Account section in the side bar and view all the triggers metadata (creation data, last execution date, times executed…)
You can always check the last time the data was fetched through the Monitor tab in the sidebar:
You can also use the “updateDate” selector in your function and adapt the format of your cell to “Date time”: