Thanks for your suggestions.
I developed a project using Google Form and Google Sheets (http://thedondata.blogspot.com/2016/09/data-entry-write-back-in-tableau-using_30.html) to allow data-entry. This is working great on Tableau desktop, I just need to refresh data source and data gets updated.
I now want to put this workbook on our Tableau server. But, data is not refreshing live. We don’t see any updates.. Data is updating on Google Sheets but when we hit “refresh” on Tableau Server’s workbook, data is not updating... it will eventually get updated 30 minutes later..
I then created Hugh's Java script, but still data is not refreshing "live".
Is it a problem with Google Sheets’ connection (Tableau server not connecting to Google Sheets)? Problem with Tableau Server’s caching system? Any comment or idea?
I don't quite know if there's a real problem here or what it could be, but any chance this workbook is connected to a published extract? If so, as a troubleshooting step, try subscribing to the view on a schedule that is after the extract refresh completes and try again. But if you're having an issue with getting updated data even with the refresh button, I suggest contacting Tableau Support.