Automatic Data Refresh Limits
The total run time of one google script execution cannot exceed 6 minutes. If it takes more than 6 minutes the operation will be terminated without any notification. You can use "Generate a log of all automatic operations to a separate sheet." option to identify how long the script executes. In case you would hit that limit you can try to split query/report into different spreadsheets.
You can only setup auto refresh process for 20 spreadsheets per account.
Auto refresh process cannot be executed more often than once per hour.
When you are setting exactly time, let's say 11 am, it doesn't mean the process starts execution exactly at 11 am. Google schedules the execution time in 30 minutes time frame between 11:00 am and 11:30 am.
Need more information, please check Quotas for Google Services
Was it helpful ? Please let us know if you still have questions. Our contact email is email@example.com