Data Viz Done Right

August 24, 2016

Tableau Tip: Connect to Google Sheets with Daily Auto-Refresh

No comments

After publishing my viz earlier today that used Google Sheets, Zen Master Chris Love posted this question on our collaboration tool:

So I told him I’d create a video that shows three things:

  1. How to scrape data from a web page into Google Sheets
  2. How to import that data into Tableau with the Google Sheets connector
  3. Ensuring it refreshes when you publish the viz to Tableau Public


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 -


Then you need to update your spreadsheet settings. Click "File" -> "Spreadsheet setting" and set the "recalculate" to "On change and every hour". This will keep the data refreshed.

No comments

Post a Comment