To connect to your Google Sheet, simply select the option under “More Servers…” on the Connect menu.

After entering your Google Sheets credentials, you will see the list of available sheets.

Select your sheet and click “connect.”

If you have many Google Sheets and want to find a particular sheet, you can use the search bar to narrow the results. In the example below, I narrowed the results to only sheets containing “consumer” in the name.

If you aren’t sure if this is exactly the sheet you are looking for, you can open it in a web browser by selecting the “open in Google Drive” link below the preview pane.

Once the sheet has been loaded into Tableau, you can drag out the individual sheets from your Google Sheet and join or union them together. You can also union and join Google Sheets with other data sources.

From there you can do all the classic analyses you would on any other data source!