I have three hosted feature services in ArcGIS Online that I originally created a couple of years ago from Google Sheets using the instructions found here: https://doc.arcgis.com/en/arcgis-online/manage-data/publish-features.htm. Periodically, I update them from the Google Sheets using the Update Data button on the Item Details page, selecting the Overwrite Entire Layer option (the only option I see). This is quick and easy and works great.
However, once in a while, one of them will suddenly lose the option to Overwrite Entire Layer and instead only allows me to Append Data to Layer. I can never figure out why this happens, as the Google Sheet's structure and permissions have not changed. Once this happens, the ability to overwrite the layer from the Google Sheet never seems to return.
If I create a new version of the feature service using the same Google sheet, I am once again able to update by overwriting the layer. My other option is to download a CSV file from the Google sheet and use the Append Data to Layer option, but that involves extra steps that I'd prefer to avoid.
Does anyone know what causes this to happen and if there's a way to repair the feature service's link to the Google Sheet (if losing it is what has caused the issue)?
Thanks in advance!
Holly