-
1. Re: Does Connecting Google Spreadsheets Auto Update?
Chris McClellanNov 12, 2016 5:10 AM (in response to brendon.chan.0)
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.
-
2. Re: Does Connecting Google Spreadsheets Auto Update?
Miguel Hernandez Feb 8, 2017 5:01 AM (in response to brendon.chan.0)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
-
3. Re: Does Connecting Google Spreadsheets Auto Update?
Chris McClellanFeb 8, 2017 6:54 PM (in response to Miguel Hernandez)
The last time I tested, it refreshed overnight so the viz was updated the next day.
-
4. Re: Does Connecting Google Spreadsheets Auto Update?
Nathan Panuco Feb 10, 2017 11:17 PM (in response to Miguel Hernandez)1 of 1 people found this helpfulHi 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!
-
5. Re: Does Connecting Google Spreadsheets Auto Update?
Jatin Kakani Aug 21, 2017 8:52 AM (in response to Chris McClellan)Hi Chris,
Any idea what about Tableau Online? Does it also auto refresh ? and what's the frequency? -
6. Re: Does Connecting Google Spreadsheets Auto Update?
Chris McClellanAug 21, 2017 4:20 PM (in response to Jatin Kakani)
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.
-
7. Re: Does Connecting Google Spreadsheets Auto Update?
Jatin Kakani Aug 22, 2017 12:35 PM (in response to Chris McClellan)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).
-
8. Re: Does Connecting Google Spreadsheets Auto Update?
Chris McClellanAug 22, 2017 4:10 PM (in response to Jatin Kakani)
I doubt it ... Tableau Public caches the data, Tableau Server doesn't
-
9. Re: Does Connecting Google Spreadsheets Auto Update?
Eugene Kim Sep 16, 2017 7:03 PM (in response to brendon.chan.0)1 of 1 people found this helpfulSo 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.
-
10. Re: Does Connecting Google Spreadsheets Auto Update?
jo.bi Oct 3, 2017 5:14 AM (in response to brendon.chan.0)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?
-
11. Re: Does Connecting Google Spreadsheets Auto Update?
jo.bi Oct 3, 2017 5:27 AM (in response to Chris McClellan)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
-
12. Re: Does Connecting Google Spreadsheets Auto Update?
Dmitry Lavoshnikov Mar 30, 2018 5:04 AM (in response to brendon.chan.0) -
13. Re: Does Connecting Google Spreadsheets Auto Update?
TheCefi Org Apr 4, 2018 5:24 AM (in response to brendon.chan.0)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.