I had the same issue with Google sheet based data sources. One of the many reasons I now use firebase exclusively.