It’s important to keep the spreadsheet open when executing the IMPORTFROMWEB functions, and it’s also beneficial to keep the add-on sidebar open. Doing so improve the overall efficiency of the data extraction process.
However, if you prefer to update your data on a regular basis, such as daily or weekly, you can utilize the trigger feature. With this feature, you can schedule when the ImportFromWeb functions will be executed, even when you’re offline or when your PC is turned off. For the trigger feature, please refer to our article on managing data updates.