UPDATE: Zen Master Jeffrey Shaffer sent me a link to this post on his blog. It’s important to note that the IMPORTHTML function does not seem to auto-refresh. You can force an auto-refresh in your Google Sheet by making the first cell an IF statement like this following -

3 comments
:

Another way to add a timed refresh is by writing a Google Apps Script via Tools > Script Editor. The syntax is pretty simple and it's well documented. Steps are to (1) write the script and (2) set the update frequency as a timed trigger. The syntax is really easy to follow and well documented. Got the following working in minutes with zero prior experience:

Thank you Andy for your wonderful tips.I developed a project using Google Form and Google Sheets. 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 API JavaScript, but still data is not refreshing "live".

Any tips on how to make it work on Tableau server?Is it a problem with Google Sheets’ connection (Tableau server not properly connecting to Google Sheets)? Problem with Tableau Server’s caching system? Any comment or idea?