Automatic 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 reach this 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 one execution per hour.

When the exact execution time sets up, for example, 11 am, it doesn’t mean the execution process will start exactly at 11 am. Based on Google scheduler’s rules the execution time will be within 11:00 am and 11:30 am. time frame.