When your Google Sheet is a data source of something, it can be quite useful to update the data in the background automatically.
For instance, let us take an example of a Data Studio dashboard connected to a Google Sheet. Let us say the dashboard displays a list of images from your Google Drive by leveraging the Preview Link column listed by Drive Explorer. You can add new images to your dashboard just by uploading files to your Google Drive, without doing anything manually in your Google Sheet.
To enable scheduled auto update, Select Extensions → Drive Explorer → Configuration, check "Schedule refresh in the background", in the dropdown select one of 1 / 2 / 5 / 10 / 24 hours and click on
It is a premium feature and requires you to have a premium license to use.