I published a GoogleSheet page as a csv and loaded it into AGOL, symbolized, etc... I then set the refresh interval and made some changes to the GoogleSheet to make sure it was updating. The symbols all flash every 12 seconds (showing that it's refreshing), but none of the info actually changes to reflect the new Google sheet values.
If I click to open the Table for the layer in AGOL it gives me a "Please Wait...Accessing Data" screen which may or may not have an end (I turned it off after 15 mins). At least some of the data gets updated when I do that, even though I don't let it finish.
I've tried a few variations of saving and reloading the map, but the partial table load seems to be the only way to get it to kind of work. Based on what I'm doing with the data, they only really need to be updated once a week and a day delay will be fine, but it would be nice to know that it's going to happen automatically. Anyone with experience have any tips to try?