Automatic refresh stopped working for multiple clients
I've recently come across a problem within the last month with a select few clients (maybe 25% of my clients or so), where none of my automatic refreshes I've previously set up (to be refreshed once per day) are actually executing. The queries are still active and set to refresh daily, but none are actually executing unless I manually execute them. Nothing changed with the set up, they simply just stopped executing automatically. And it's all queries on a sheet, regardless of data source, and data sources include Google Ads, Bing Ads, Criteo, API, Analytics etc.
Anyone else see similar issues and find a solution? Supermetrics hasn't been able to find a solution for me yet, so figured I'd reach out here. It really affects some of my reports which require a daily refresh or else I am missing data (and thus have to set up new queries to grab the missing data).
I actually just noticed while writing this that by just opening the google doc the refresh will automatically run without manually executing, but it won't run on a day when I don't open the Google Doc. Seems really strange to me, anyone else have this happen?