Google Sheets connection in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to connect Tableau to a Google Sheet using the web data connector URL.

Tableau

CONNECT TO GOOGLE SHEETS USING URL '[1]'

Drag options to blanks, or click blank then click option'

Ahttps://docs.google.com/spreadsheets/d/your_sheet_id/export?format=csv

Bhttps://docs.google.com/forms/d/your_form_id/viewform

Chttps://docs.google.com/spreadsheets/d/your_sheet_id/edit#gid=0

Dhttps://drive.google.com/drive/folders/your_folder_id

Attempts:

3 left

💡 Hint

Common Mistakes

Using the edit URL instead of the export CSV URL.

Using a Google Drive folder URL instead of a sheet URL.

To connect Tableau to Google Sheets via web data connector, you use the export URL with format=csv to get the sheet data.

2fill in blank

medium

Complete the Tableau connection step to refresh data from Google Sheets automatically.

Tableau

SET REFRESH SCHEDULE TO [1]

Drag options to blanks, or click blank then click option'

Amanual

Bautomatic

Cdaily

Dnever

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing manual refresh which requires user action.

Selecting 'never' which disables refresh.

Setting the refresh schedule to automatic allows Tableau to update data from Google Sheets without manual intervention.

3fill in blank

hard

Fix the error in the Tableau Google Sheets connection URL by completing the missing part.

Tableau

https://docs.google.com/spreadsheets/d/[1]/export?format=csv

Drag options to blanks, or click blank then click option'

Afile_name

Bsheet_name

Cfolder_id

Dsheet_id

Attempts:

3 left

💡 Hint

Common Mistakes

Using the sheet name instead of the sheet ID.

Using folder or file names which are not valid here.

The correct URL requires the unique sheet ID, not the sheet name or folder ID.

4fill in blank

hard

Fill both blanks to set up Tableau to connect and refresh Google Sheets data.

Tableau

CONNECT TO GOOGLE SHEET USING URL '[1]' AND SET REFRESH TO [2]

Drag options to blanks, or click blank then click option'

Ahttps://docs.google.com/spreadsheets/d/your_sheet_id/export?format=csv

Bmanual

Cautomatic

Dhttps://docs.google.com/spreadsheets/d/your_sheet_name/export?format=csv

Attempts:

3 left

💡 Hint

Common Mistakes

Using sheet name in URL instead of sheet ID.

Setting refresh to manual which requires user action.

Use the correct export URL with the sheet ID and set refresh to automatic for live updates.

5fill in blank

hard

Fill all three blanks to write a Tableau calculated field that extracts the month from a Google Sheets date column named 'Date'.

Tableau

MONTH([1]([[2]])) = [3]

Drag options to blanks, or click blank then click option'

ADATETRUNC

BDate

CMONTH(TODAY())

DDATE

Attempts:

3 left

💡 Hint

Common Mistakes

Using DATETRUNC instead of DATE for casting.

Using wrong column name or syntax errors.

Use DATE to cast the field, then access the 'Date' column, and compare to the current month using MONTH(TODAY()).