Google Sheets connection in Tableau - Step-by-Step Guide

Introduction

This feature lets you connect Tableau directly to your Google Sheets data. It helps you use live or updated data from Google Sheets in your Tableau reports without manual exporting.

When you want to build a dashboard using data that your team updates in Google Sheets daily.

When you need to combine Google Sheets data with other data sources in Tableau.

When you want to avoid exporting CSV files and keep your Tableau workbook connected to live Google Sheets data.

When your sales team tracks leads in Google Sheets and you want to visualize that data in Tableau.

When you want to share Tableau reports that always reflect the latest Google Sheets data.

Steps

Step 1: Open Tableau Desktop

- Start page

You see the Connect pane with data source options

Step 2: Click

- Connect pane under To a Server > More

A list of additional connectors appears

Step 3: Select

- Google Sheets connector

A sign-in window for Google appears

Step 4: Sign in

- Google sign-in window

Tableau connects to your Google account and shows your Google Sheets files

Step 5: Select

- Your desired Google Sheets file from the list

Tableau loads the sheets inside that file as tables you can use

Step 6: Drag

- Sheet name to the canvas

The data preview appears and you can start building your visualization

Before vs After

Before

Tableau shows only local or other data sources without Google Sheets data

After

Tableau shows your selected Google Sheets data ready for analysis and visualization

Settings Reference

Refresh Data

📍 Data Source tab > Extract refresh options

Choose how Tableau updates data from Google Sheets

Default: Live connection

Sheet Selection

📍 Google Sheets connector window

Pick which sheets from the Google Sheets file to use

Default: First sheet selected

Sign-in Account

📍 Google Sheets connector sign-in prompt

Authenticate Tableau to access your Google Sheets files

Default: None

Common Mistakes

Not signing into the correct Google account

Tableau cannot access the intended Google Sheets files if signed into a different account

Ensure you sign in with the Google account that owns or has access to the desired Sheets

Selecting the wrong sheet inside the Google Sheets file

You may load empty or irrelevant data if the wrong sheet is chosen

Double-check the sheet name and preview data before loading

Using extract mode without scheduling refresh

Data will not update automatically and may become outdated

Use live connection or set up extract refresh schedules to keep data current

Summary

Google Sheets connection lets Tableau use live data from your Google Sheets files.

You must sign in to your Google account and select the correct sheet to load data.

Choose live or extract refresh options to keep your data updated in Tableau.