How to integrate data into Tableau with Windsor.ai

What is Tableau?

Tableau is a leading data visualization and analysis platform with robust business intelligence features. It enables you to seamlessly connect, visualize, and share large datasets to uncover insights and make data-driven decisions. With Windsor.ai’s no-code ELT connector, you can automate data imports into Tableau from over 315 sources, saving time and enhancing efficiency.

While external connectors are temporarily unavailable in Tableau, you can still connect it to Windsor.ai using an intermediary service like Google Sheets or Google BigQuery.

Select one of these destinations in Windsor.ai, set up the connection, and then link Tableau to your chosen destination. This workaround ensures seamless integration while we await Tableau’s reinstatement of external connectors.

Explore our step-by-step guide to integrate your data into Tableau with the Windsor.ai ELT connector.

How to connect Tableau to Windsor.ai

Connecting data in Windsor.ai

1. Create a Windsor.ai account and log in.

2. Connect the required data source, select the necessary account(s), and grant access. In this example, we’ll be using Google Analytics 4 (GA4).

selecting data source in windsor.ai

You’ll see your Google Analytics 4 data in your Windsor.ai account. Now, let’s proceed with setting up a connection with Tableau for data integration.

Connecting Tableau via Google Sheets

1. Log in to your Google Sheets account.

2. Open a new spreadsheet document.

3. Click on the “Extensions” tab and Get Add-ons.

install extensions in Excel

4. On the search tab, type “Windsor.ai,” press enter, and install our extension.

windsor.ai extension

5. Choose the Google account associated with your Windsor.ai account and sign in by granting necessary access. 

6. Click “Complete additional setup now” and take the procedure.

7. Go to the Extensions tab again, find “Windsor.ai,” and click “Login.

log in windsor.ai extension google sheets

8. Paste your API Key provided in the windsor.ai dashboard and log in. Find out how to obtain a Windsor API Key for Google Sheets in this destination guide.

api key for google sheets windsor.ai

Here, you’ve connected Google Sheets with Windsor.ai and now can import data from your source into the spreadsheet.

9. In Google Sheets, click “Extensions,” then “Windsor.ai” and “Get Data into Sheet.

get data into google sheets

10. Choose “Add New Query” and add filters for your data, including name, data sources, connected accounts, and other settings.

windsor.ai query in google sheets

11. After setting a query, click “Load Data.”

google sheets query with windsor.ai

12. Now, you can see your data imported into Google Sheets using Windsor.ai.

data integrated into google sheets

Importing data from Google Sheets into Tableau

1. Open the Tableau Desktop app.

2. Go to the “Data” tab and click “New Data Source.

New Data Source in Tableau

3. Select “More” and “Google Drive.

data sources in Tableau

4. Grant all the necessary access.

5. Return to the Tableau desktop app, select the data you want to import and click “Connect.” In our case, the data is named “Test data.”

connect data in tableau

6. Congratulations! You’ve imported data to Tableau, and it’s ready for further analysis.

integrate data into tableau windsor

FAQs

How do I connect Windsor.ai data to Tableau if external connectors are unavailable?

You can use an intermediary like Google Sheets or Google BigQuery. Connect your data source in Windsor.ai, export it to Google Sheets using the Windsor.ai add-on, and then import the Google Sheets data into Tableau.

Tired of manually transferring data to Tableau? Try Windsor.ai today to automate the process

Access all your data from various sources in one place. Get started for free with a 30-day trial.
g logo
fb logo
big query data
youtube logo
power logo
looker logo