Please make sure that the timezone of your spreadsheet matches your actual location. Otherwise, you might experience problems with scheduled updates.
- Go to "File" at the top
- Choose "Spreadsheet settings". Here you can change the locale and also the timezone
- Click on "Save settings" to confirm these new settings.