Google Drive

This article describes how to connect Tableau to Google Drive and set up the data source.

Before you begin

Before you begin, gather this connection information:

  • Google email address and password

Make the connection and set up the data source

  1. Start Tableau and under Connect, select Google Drive. For a complete list of data connections, select More under To a Server. In the tab Tableau opens in your default browser, do the following:

    1. Sign in to Google Drive using your email or phone, and then select Next to enter your password. If multiple accounts are listed, select the account that has the Google Drive data you want to access and enter the password, if you're not already signed in.

    2. Select Allow so that Tableau Desktop can access your Google Drive data.

    3. Close the browser window when notified to do so.

    4. Select a file from the list or use the text box to search for a file by name, and then select Connect.

      Note: This connector might not support all file types. Unsupported file types are grayed out.

  2. On the data source page, do the following:

    1. (Optional) Select the default data source name at the top of the page, and then enter a unique data source name for use in Tableau. For example, use a data source naming convention that helps other users of the data figure out which data source to connect to.

    2. If your Google Drive file has one table, select the sheet tab to start your analysis.

About .ttde and .hhyper files

You might notice .ttde or .hhyper files when navigating your computer's directory. When you create a Tableau data source that connects to your data, Tableau creates a .ttde or .hhyper file. This file, also known as a shadow extract, is used to help improve the speed your data source loads in Tableau Desktop. Although a shadow extract contains underlying data and other information similar to the standard Tableau extract, a shadow extract is saved in a different format and can't be used to recover your data.

In certain situations, you might need to delete a shadow extract from your computer. For more information, see Low Disk Space because of TTDE Files in the Tableau Knowledge Base.

Troubleshoot Google Drive issues

Data limit in Google Drive

Google Drive supports a limited number of cells (in the millions) for spreadsheets that are created in or converted to Google Sheets. For more information, see Files you can store in Google Drive in the Google Drive Help.

Connections to multiple accounts

When using web authoring or publishing to the web, you cannot use multiple Google Drive accounts, even when using different connections. You can have multiple Google Drive account connections in Desktop.

Web authoring with Internet Explorer 11 and Edge

In Internet Explorer 11 and Edge, you cannot access a server using an unsecured connection (http). Use a secure connection (https) or switch to another browser.

See also

Thanks for your feedback! There was an error submitting your feedback. Try again or send us a message.