Do you know you can update the metrics in the Google Sheet in the background even when the sheet is not open? You need to enable a config for that, select Extensions → YT Tracker → Settings → Customization, check Refresh numbers automatically.
Now, a dropdown will appear. There you can select once in how many hours the data has to be updated automatically. The options available are 1, 2, 5, 10 or 24 hours.