Community SupportHi LavinaVRovine,
Based on my test, after we set the data source credential for this web data source as Anonymous and click Sign In, if we don't interact with the Data Source Credentials tab, the credential is keeping with Anonymous and we can set manual refresh or schedule refresh. In your scenario, when the issue occurs, please select Anonymous for data source credential then click Refresh Now, the refresh should be successful.
In case of credential losing, you can also create a web data source points to this Google Sheet in Manage Gateways section, then configure the dataset to use this data gateway to refresh. I know Google Sheet doesn't require any gateway, but with gateway configured, the refresh will be smoothly as long as long gateway is running fine.
Best Regards,
Qiuyun Yu