How to Connect Salesforce to Looker

Getting your Salesforce data into Looker is a surefire way to unlock deeper, more flexible reporting than you can get with Salesforce's native dashboards alone. The goal is to combine that rich sales data with information from marketing, finance, and product to get a complete picture of your business. This article walks you through the best way to connect the two platforms and start building reports that drive real decisions.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Connect Salesforce to Looker in the First Place?

While Salesforce offers robust built-in reporting, it can sometimes feel like an island. Connecting it to a powerful business intelligence platform like Looker opens an entirely new world of analysis. Here’s why it’s worth the effort:

• A Single Source of Truth: Instead of logging into Salesforce for sales data, Google Analytics for web data, and your ad platforms for spend data, you can merge it all in Looker. This lets you finally answer critical questions like, "Which marketing channels source the deals with the highest close rate?"
• Deeply Custom Analysis: Looker allows for more complex calculations, sophisticated data modeling, and far more visualization flexibility than standard Salesforce reports. You can define your business logic once and have your whole team use it consistently.
• Democratized Data Access: Once it's set up, business users can easily explore Salesforce data and build their own reports in Looker without needing to ask a data analyst for help or understand the complexities of Salesforce reporting types.
• Improved Performance: Querying massive datasets directly in Salesforce for complex reports can be slow. By moving the data to a dedicated data warehouse, you enable faster, more complex analysis without slowing down your sales team's primary CRM tool.

Looker vs. Looker Studio: A Quick but Important Clarification

Before we dive into the steps, it's essential to clear up a common point of confusion. Google offers two products with "Looker" in the name, and they are very different:

• Looker (Google Cloud): This is an enterprise-grade BI platform designed for deep data modeling and governance. It connects to dedicated SQL databases (data warehouses) and uses its own modeling language, LookML, to define business metrics. This is the more powerful, flexible, and complex tool.
• Looker Studio (formerly Google Data Studio): This is a free data visualization tool. It has direct "connectors" to many apps, including a native Salesforce connector, making it easier to set up for simple dashboards but less powerful for complex, large-scale analysis.

This guide primarily focuses on connecting Salesforce to the enterprise Looker platform, as this is the most robust and scalable solution. However, the principles discussed here, especially around data warehousing, are valuable for high-performing Looker Studio users as well.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Before You Begin: Prerequisites to Gather

To ensure a smooth process, you'll need a few things in order before you start the connection. Think of this as your pre-flight checklist.

• A Supported Salesforce Edition: You'll need API access, which is available on Salesforce's Enterprise, Unlimited, Developer, or Performance editions. The Professional edition has limited API access that may require an extra cost, and the Essentials edition does not have API access.
• A Dedicated Salesforce User: It’s a best practice to create a new, dedicated Salesforce user for the data connection. This user should have API permissions and read-only access to all the objects and fields you want to analyze (like Accounts, Opportunities, Contacts, Leads, and any custom objects). Using a dedicated credential makes managing security and tracking API usage much easier.
• A Data Warehouse: Looker doesn't store your data, it queries it from a database. You need a central repository to hold your Salesforce data. Popular choices include Google BigQuery, Snowflake, and Amazon Redshift. If you don't already have one, setting up a BigQuery project is a common starting point for teams already in the Google ecosystem.
• ETL/ELT Tool Access: You need a "data pipeline" tool to automatically extract your data from Salesforce, transform it if needed, and load it into your data warehouse. We’ll discuss these tools next.
• Looker Admin Access: You'll need admin permissions in Looker to create a new database connection and set up a new project.

The Recommended Method: Connecting Salesforce via a Data Warehouse

Though it involves a few moving parts, this is the standard and most reliable way to link your Salesforce data to Looker. The architecture looks like this: Salesforce -> ETL Tool -> Data Warehouse -> Looker. It might seem intimidating, but each step is straightforward.

Step 1: Choose Your Data Warehouse

Your data warehouse is the foundation of your analytics setup. Think of it as your company's central library for data. Salesforce is just one book you want to add to the collection. The most important thing here is putting the copy of your Salesforce data in a location your BI tool (Looker) can easily and quickly access. For teams using Looker, Google BigQuery is often the natural choice. It is highly scalable and integrates seamlessly with Google Cloud's other products.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 2: Automate Data Transfer with an ETL Tool

You can’t just copy and paste your Salesforce data into a warehouse. You need a process to handle this automatically. This is where an ETL (Extract, Transform, Load) or ELT (Extract, Load, Transform) tool comes in. These services act as a bridge, pulling data from the Salesforce API and loading it cleanly into your data warehouse on a set schedule.

Popular tools for this include Fivetran, Stitch Data, Airbyte, and Hightouch. The setup process is generally similar for all of them:

1. Create an account with your chosen ETL provider.
2. Set up a "source": In this case, Salesforce. You'll enter the credentials for the dedicated Salesforce user you created earlier.
3. Set up a "destination": This will be your data warehouse (e.g., BigQuery). You'll provide credentials so the ETL tool has permission to write data to it.
4. Select objects and fields: Choose which Salesforce objects (tables) you want to sync, like Opportunity, Account, Lead, User, etc., as well as their corresponding fields. It's often best to start with the essentials and add more later.
5. Set a sync frequency: You can decide how often you want the tool to check for new or updated data in Salesforce - every 5 minutes, every hour, or once a day.

Once you kick off the initial sync, the ETL tool will begin pulling all your historical Salesforce data and loading it into your data warehouse. This might take a while, depending on how much data you have.

Step 3: Connect Looker to Your Data Warehouse

With data flowing into your warehouse, you're ready for the final connection. In this step, you’ll tell Looker where to find its data.

1. Navigate to the Admin section in your Looker instance.
2. Under "Database,” click on Connections.
3. Select Add Connection.
4. From the "Dialect" dropdown, choose your data warehouse (e.g., Google BigQuery, Snowflake).
5. Fill out the required credentials, like the database name, host, username, and password. You'll get these from your data warehouse platform.
6. Click Test to make sure Looker can successfully communicate with your database.
7. If the test is successful, click Add Connection. Your data is now accessible to Looker!

You're Connected! Now What? Building Your Analysis

Connecting the pipes is just the beginning. The next step is to teach Looker how to interpret your Salesforce data and make sense of it for your business users.

Getting Started with LookML

LookML (Looker Modeling Language) is the secret sauce of Looker. It's a layer of code that sits between your database and the Looker user interface. It works like a "translator," turning complex SQL database tables into friendly, reusable business definitions. For example, you can use LookML to:

• Define a "dimension" for 'Opportunity_Amount' and label it clearly as "Deal Value."
• Create a "measure" called Total_Won_Revenue that is a SUM of the Deal Value only where the Opportunity_Stage is 'Closed Won'.
• Establish relationships (joins) between tables, like linking your Opportunity table to your Account table.

When you first connect Looker to your database, you can automatically generate a base LookML model from your database schema. From there, your data team can refine it, adding business logic and making it more intuitive for users to build reports.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Building Your First Salesforce Report

Once your model has some basic definitions, anyone on the team can analyze the data from the "Explore" section of Looker.

1. Choose an Explore, like "Opportunities."
2. From the field list on the left, select a few dimensions (e.g., Stage Name, Record Type) and a measure (e.g., Count of Opportunities).
3. Looker automatically generates the query and shows you the results.
4. Add a filter, such as filtering for Close Date in the "Current Quarter."
5. Select a visualization, like a bar chart or a funnel visualization for sales stages.
6. Congratulations! You've just built a custom report. You can save this as a "Look" or add it as a new tile on a dashboard.

Final Thoughts

Connecting Salesforce to Looker by setting up a reliable data pipeline to a warehouse unlocks powerful, centralized analytics. This process equips your entire organization with the self-service tools needed to dig deep into sales performance, spot trends, and find opportunities that would otherwise remain hidden within Salesforce reports.

If that process sounds like a lot of steps just to get answers from your Salesforce data, that's because it often is. We created Graphed to remove all of that complexity. We wanted to make data access instant, without requiring you to set up data warehouses, manage ETL pipelines, or learn a modeling language like LookML. With us, you just connect your Salesforce account in a few clicks, and a prebuilt semantic layer understands your data instantly. From there, you can ask for reports and dashboards in plain English - like "create a sales pipeline report showing deal closure rates by rep for this quarter" - and get beautiful, real-time dashboards in seconds.