Problem Definition

Occasionally, a query fails upon refresh or a sheet that is supposed to refresh hourly does not do so for many hours. Less frequently, a query expires and it would be nice to know about these ones too.

The solution is easy on all of these, the sheet owner opens the Add-on and can then refresh manually.

The problem is the failure is silent and the data either disappears or slowly gets more stale.

Suggested Solution

Request is for a way to raise the visibility of these failures, presumably via some type of monitoring or alerting strategy. This would be especially valuable for the situation where the query refresh fails.