Tableau Public should update once every 24hrs.  I haven't worried about finding the exact time of update (and I think it might vary), but if you enter data in the sheet and "just wait 24hrs" it will appear in your viz.  If you're impatient, you can login to Tableau Public and force the refresh as well.

I am wondering the same and it doesn't seem to auto-refresh.

I have this dashboard in Tableau Public connected to Google Sheets.

I have created 2 new records 3 days ago to test if the dashboard auto-updates (with different dates just in case),

The dashboard is not updating.

Anyone has some input on how to auto-update a Tableau Public dashboard linked to Google Sheets?

There is this post http://www.vizwiz.com/2016/08/tableau-tip-connect-to-google-sheets.html , but I would prefer to use some "auto-update" feature instead of doing that.

Thanks

The last time I tested, it refreshed overnight so the viz was updated the next day.

Hi Miguel:

I haven't watched the video, but I found this training resource on Tableau Public that talks about the auto-updating of Google Sheets: Resources | Tableau Public Look for video 3.

Hope this helps!

Hi Chris,

Any idea what about Tableau Online? Does it also auto refresh ? and what's the frequency?

I've just tested it on Tableau Online.  As soon as you enter new data in Google Sheets and refresh in Tableau Online you see the data - so it's instant.

Yes, it would update on hitting the refresh button. I wanted to know if it auto updates (like in Tableau public it automatically updates once a day).

I doubt it ... Tableau Public caches the data, Tableau Server doesn't

So you *can* set Tableau Public to embed your Google credentials and auto-refresh Google Sheet data, but you have to set all of the Google Sheet data sources as an extract. Then when you publish to Tableau Public, it gives you an option to refresh daily, a simple checkbox. It doesn't look like there is any other schedule allowed, not even a time specified. I'm guessing it will get to it when it gets to it. When you check the checkbox, it pops up the Google login box to save your credentials.

Hello there,

what about refreshing data on Tableau server?

I got a workbook linked to Google Sheets, users enter data in google sheet, I fresh workbook and data gets updated in Tableau Desktop.

Then I put my work on 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.

Is there anyone who could enlighten me on this issue? Is it a problem with Google Sheets’ connection (Tableau server not connecting to Google Sheets)? An error in data refreshing? Problem with Tableau Server’s caching system? Or would it be any other solution to incorporate user input into a Dashboard?

Hi Chris,

I would like the same process happen on Tableau server: as soon as I hit refresh on server, you see new data.

Working great on desktop, facing issue on server though. Any help? Thank you

Hi guys,

Hope this helps - you can go Tableau Public website and hit this, then refresh the viz.

Cheers

The Google Sheets should be added as primary data (then use Data blending to match your Google Sheets with other data. ), then select "Kep my data in sync with google  Sheets" while saving.

If you add the google sheet as secondary data (joined to primary data) you won't have the possibility to check "Kep my data in sync with google  Sheets" and your dashboard will not automatically be updated.