I have been trying on the Public Tableau 10.0, particularly newly added feature of connecting the data set with google spread sheet. I have watched the "How to tutorial" with regards to google sheets. From the viz part, I edited request update and it responded request sent. I could see the data manually changed from google sheet were reflected on the viz. I wonder if there is any way that we wouldn`t need manual interference by requesting an update. Can it be done automatically regardless of hitting request update button? I know it updates every 24 H. I wish it could be done every second or minute...
This is a limitation of Tableau Public as live data updates require Tableau Desktop.
I would start a trial and give it a shot!