)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Analytics Studio datasets can’t directly connect to Tableau Public due to authentication requirements and API limitations. This forces manual data exports every time you need to update your Tableau visualizations.
Here’s a streamlined alternative that creates a data bridge from Salesforce to formats that Tableau Public readily accepts, with automatic updates maintained throughout the process.
Create automated Tableau connections using Coefficient
Coefficient offers alternative connection methods by creating a data pipeline from Salesforce to Google Sheets, then exporting to formats that Tableau Public can easily ingest with automatic updates.
How to make it work
Step 1. Set up direct Salesforce to Sheets pipeline.
Import Salesforce data directly to Google Sheets using Coefficient, bypassing Analytics Studio authentication entirely. This gives you access to the complete Salesforce schema, not just limited Analytics Studio reports.
Step 2. Configure automated file generation.
Set up Coefficient to refresh data on schedule, then use Google Apps Script to auto-export CSV files after each refresh. Store these files in publicly accessible Google Drive folders for Tableau Public to access.
Step 3. Create web data connector alternatives.
Publish Coefficient-synced Google Sheets to web and use published sheet URLs as data sources. Create custom web data connectors for Tableau that maintain live connections without authentication requirements.
Step 4. Implement hybrid data approach.
Include calculated fields using spreadsheet formulas, combine multiple Salesforce objects in one dataset, and apply complex filters before data reaches Tableau. This provides more flexibility than Analytics Studio reports.
Step 5. Set up Tableau refresh coordination.
Schedule Coefficient refreshes, configure automatic CSV exports, connect Tableau Public to published data, and set Tableau extract refresh schedules to align with your data updates.
Start connecting Salesforce to Tableau
This method provides more flexibility and control than attempting to connect Analytics Studio to Tableau Public while solving the authentication challenge completely. Begin building your automated Salesforce to Tableau pipeline today.
