It looks like you are connecting to the Google Sheet itself and not a Web Data Connector. Tableau has one already built that you can download from the Googlesheets Sample Connector Thread . But if you just need to connect to Google Sheets in Desktop (and not refresh on Tableau Server) you can use this link instead: http://tableau.github.io/webdataconnector/Examples/GoogleSheetsConnector.html
If you use that link you should come to a page that looks like the one below, where you can enter your credentials and get data from your spreadsheets.
I got the google sheet connector to work, thanks.
I have two follow up questions.
1. How secure is data that I run through this connector?
2. It looks like the WDC will only do an extract? I'd like a live connection to a shared excel doc / google sheet, What would you recommend?
The WDC doesn't use any other outside libraries other than those provided by Tableau and Google API so the connection is as secure as you logging into your Google Account.
As for the live connection, Web Data Connections are currently Extract only. However I know there are many other community members that have found solutions on how to connect to Google Sheets live. Here is a link that may have a solution for you: Google Spreadsheets to Tableau connector - a working driver! Yay!
I have another question about the Google Spreadsheet Web Data Connector
How can I import all sheets from a google doc all at once??
Heres my process
1. select the web data connector in tableau
2. pasting in the data connector URL
3. pasting in my google sheet url
4. verifying my google account and password
5. I'm then asked to select a sheet.
Currently I can only select one sheet at a time and thus have to go through steps 1-5 for every sheet.
I have 50sheets, is there an alternative way to import all sheets at once?
To bring in multiple sheets from Google Sheets as one data source you will have to use something different. I'm not sure if there is a Web Data Connector already built that does this so you may have to look into other methods like using the Tableau SDK.