Tableau Public now supports a live connection to Google Sheets in version 10. This allows authors to use a live connection to data in their visualizations in Tableau Public.
Why we built this feature: Tableau Public is viewed on the public web. Many authors are also using publicly available data. This feature enables that web-to-web connection and gives authors the ability to share visualizations that always have up-to-date data, without having to force them to download new data, update their workbooks and then republish them.
Our Goals: 1) Provide a way for authors to save an automated refresh for their workbooks built with Google Sheets. Specifically, just the extracts in a workbook built using Google Sheets (if a workbook has multiple data sources).
2) Enable authors to manually refresh their Google Sheet extract from the Tableau Public web interface.
3) Allow authors to know the status of their Google Sheets extract: how recently it was updated, whether the update failed and why.
I worked with Daniel Hom, the Product Manager of the Tableau Public team to brainstorm the possibilities of adding this feature to the existing product. I created the mockups, presented our case, and ultimately built the feature with our team of talented web developers.
Tools: Tableau, OmniGraffle, Photoshop
Date: March 2016
Role: Interaction Design, Product Design, Visual Design