BRUTAL MARKETING
GOOGLE LOOKER STUDIO FOR SALES TEAMS: HOW TO CONNECT YOUR CRM AND BUILD A DASHBOARD
september 2026
BRUTAL MARKETING
Google Looker Studio for Sales Teams: How to Connect Your CRM and Build a Dashboard
september 2026
Google Looker Studio for Sales Teams: How to Connect Your CRM and Build a Dashboard
Most sales managers we work with at Brutal Marketing spend 30 to 60 minutes every day manually pulling together a sales report. Export from CRM, paste into Excel, a few formulas, then "why don't the numbers add up?" — every Monday, without fail.
And all of this while a free tool exists that automates the whole thing.
And all of this while a free tool exists that automates the whole thing.
Serhii
Ponomarenko
Ponomarenko
Google Looker Studio (formerly Google Data Studio) lets you connect your CRM directly and get a live dashboard that updates without any manual input. Managers see their own numbers, the business owner sees the big picture, and you stop being "the person with the spreadsheet."
Here's what follows: exactly what to connect, how to set it up, and the mistakes that trip up almost everyone doing this for the first time.
Here's what follows: exactly what to connect, how to set it up, and the mistakes that trip up almost everyone doing this for the first time.
What Looker Studio Is — and Why It's Not Just "Another Dashboard"
Google Looker Studio is a cloud-based data visualization tool. It's free, runs in the browser, requires no installation, and supports hundreds of data sources: Google Sheets, BigQuery, Salesforce, Pipedrive, Kommo, Facebook Ads, Google Analytics, and more.
The key difference from Excel or a standard CRM report is that data updates automatically. You set up the connection once, build the charts you need, and forget about it. Every morning the dashboard is already current.
Another advantage: access via link. You can show a report to a business owner without giving them CRM credentials, share a specific dashboard with a specific manager, or embed it in a company portal. No "can you give me access to the system?" and no "it won't open again."
The key difference from Excel or a standard CRM report is that data updates automatically. You set up the connection once, build the charts you need, and forget about it. Every morning the dashboard is already current.
Another advantage: access via link. You can show a report to a business owner without giving them CRM credentials, share a specific dashboard with a specific manager, or embed it in a company portal. No "can you give me access to the system?" and no "it won't open again."
How Looker Studio Differs from Built-in CRM Reports
The built-in analytics in Pipedrive or Kommo are convenient, but limited. You see what the developer decided to show you. Looker Studio lets you combine data from multiple sources simultaneously: deals from CRM + ad spend from Google Ads + revenue from the accountant's spreadsheet. That kind of cross-source view isn't possible inside any CRM.
In our experience at Brutal Marketing, this is where Looker Studio delivers the most value — connecting data that used to live in separate places so you can finally see the real cost of acquiring a customer or the real performance of a specific manager.
In our experience at Brutal Marketing, this is where Looker Studio delivers the most value — connecting data that used to live in separate places so you can finally see the real cost of acquiring a customer or the real performance of a specific manager.
Connecting Pipedrive to Looker Studio
Pipedrive doesn't have a native connector in Looker Studio, so there are two practical approaches.
Option 1: Via Google Sheets (free, but with caveats)
You set up an automated export of Pipedrive deals into Google Sheets using Zapier, Make (Integromat), or the Pipedrive API directly. Then you connect that Sheet to Looker Studio as a data source.
The upside: no additional cost beyond your Zapier or Make subscription. The downside: data updates on a delay (once per hour or on a trigger), and with a large number of deals the spreadsheet starts to slow down.
The upside: no additional cost beyond your Zapier or Make subscription. The downside: data updates on a delay (once per hour or on a trigger), and with a large number of deals the spreadsheet starts to slow down.
Option 2: Via a third-party connector (paid, but reliable)
There are dedicated Looker Studio connectors: Supermetrics, Coupler.io, windsor.ai. These connect Pipedrive directly — no intermediate spreadsheets — and refresh data on a schedule, as frequently as every 15 minutes.
Pricing runs from $19 to $49 per month depending on the number of sources. For a team of 5+ managers with serious deal volume, it pays for itself: the time saved on manual data collection covers the subscription cost in the first month alone.
At Brutal Marketing, we most often recommend Coupler.io — clean interface, support for both Pipedrive and Kommo alongside Google Sheets, and no API knowledge required.
Pricing runs from $19 to $49 per month depending on the number of sources. For a team of 5+ managers with serious deal volume, it pays for itself: the time saved on manual data collection covers the subscription cost in the first month alone.
At Brutal Marketing, we most often recommend Coupler.io — clean interface, support for both Pipedrive and Kommo alongside Google Sheets, and no API knowledge required.
Connecting Kommo (amo) to Looker Studio
Kommo has slightly more integration options than Pipedrive, but the logic is similar.
Via native webhook + Google Sheets
Kommo can send a webhook on any deal change. You point that webhook at a Google Apps Script that writes data into a spreadsheet — and that spreadsheet becomes your Looker Studio data source. This approach is technical and requires some scripting knowledge, but it delivers near-real-time data.
If you want to understand how data transfers between Kommo and external services actually work, it's worth reading our article on Telegram-CRM integration first — we walk through the webhook mechanism with a concrete example.
If you want to understand how data transfers between Kommo and external services actually work, it's worth reading our article on Telegram-CRM integration first — we walk through the webhook mechanism with a concrete example.
Via Coupler.io or Supermetrics
Same as with Pipedrive — select Kommo as your source, authorize the connection, choose which fields to export (deal name, amount, assigned user, status, creation date, close date), and connect to Looker Studio. Takes 20–30 minutes even without technical experience.
What fields you must include
Regardless of the connection method, make sure your data source includes the following fields:
Without these fields your dashboard will be incomplete, and you won't be able to answer basic questions: who's selling, how much, where customers are coming from, and where they're dropping off.
- deal name;
- deal amount;
- assigned manager;
- current pipeline stage;
- deal creation date;
- close date (actual or expected);
- loss reason (for lost deals);
- source (where the lead came from).
Without these fields your dashboard will be incomplete, and you won't be able to answer basic questions: who's selling, how much, where customers are coming from, and where they're dropping off.
Building a Basic Sales Dashboard in Looker Studio
Once your data source is connected, the interesting part begins. Here's what the first screen should contain — what the business owner or sales manager sees without scrolling.
Key metrics at the top
Four number cards: total revenue for the current month, number of closed deals, average deal size, conversion rate. These answer the question "how are we doing?" without reading through tables.
Add a comparison to the previous month or the same month last year. Looker Studio does this in a few clicks using the "comparison date range" feature.
Add a comparison to the previous month or the same month last year. Looker Studio does this in a few clicks using the "comparison date range" feature.
Sales funnel
A vertical or horizontal bar chart showing the number of deals at each pipeline stage. You'll immediately see where the bottleneck is: if there are more deals at "Proposal Sent" than at "Negotiation," that means proposals are going out but no one is following through.
Breakdown by manager
A table or heatmap: each manager is a row, columns are revenue, number of deals, conversion rate, average deal cycle. Without this view, you can't tell whether the problem is systemic or whether one manager just had a bad month.
Weekly or daily trend
A line chart of revenue or deal count over time. This shows seasonality, dips, and peak days. Useful for planning time off, launching promotions, and understanding whether there's any real growth happening.
Lead sources
A pie or bar chart: how many deals and how much revenue comes from each source (website, Instagram, referral, cold call, etc.). If this data exists in your CRM, you'll have a clear basis for deciding where to invest your marketing budget.
For guidance on how to set up your pipeline in CRM correctly so this data actually exists, see our article on setting up a sales funnel in CRM.
For guidance on how to set up your pipeline in CRM correctly so this data actually exists, see our article on setting up a sales funnel in CRM.
Automatic Data Updates: How It Works and Where Things Go Wrong
Looker Studio doesn't pull data from your CRM on its own. It queries the data source (Google Sheets or a connector) and displays whatever is there. So "automatic updates" really means setting up a regular export from your CRM into that source.
If the source is Google Sheets
Data in the spreadsheet updates when your Zapier/Make scenario runs, or when you manually trigger the script. Looker Studio caches data for 12 hours by default. To get fresh data, click "Refresh data" in the top right corner, or reduce the cache to 1 hour in the data source settings.
If the source is a third-party connector
Coupler.io, Supermetrics, and similar tools let you set a refresh schedule: every 15 minutes, once an hour, once a day. For a daily report, an overnight refresh is enough. For operational monitoring during the day, once an hour or more frequently makes sense.
Common problems
Data stalls and stops updating. Usually the cause is an expired connector authorization. Go to the data source settings and re-authorize.
The dashboard shows old data even after refreshing. This is browser cache or Looker Studio cache. Try Ctrl+Shift+R, or reduce the cache duration in the data source settings.
Fields have disappeared or been renamed. If you changed the structure of your Sheets table or renamed fields in CRM, Looker Studio will lose those fields in the report. You'll need to manually re-map them in the chart settings.
The dashboard shows old data even after refreshing. This is browser cache or Looker Studio cache. Try Ctrl+Shift+R, or reduce the cache duration in the data source settings.
Fields have disappeared or been renamed. If you changed the structure of your Sheets table or renamed fields in CRM, Looker Studio will lose those fields in the report. You'll need to manually re-map them in the chart settings.
Ready-to-Use Dashboard Templates from Brutal Marketing
At Brutal Marketing, we almost always set up Looker Studio alongside a CRM implementation or restructuring. Over time, working with different sales teams, we've built several standard templates that cover 80% of what clients actually need.
Template 1: Operations Dashboard for the Sales Manager
Built for daily monitoring. Shows: deals with no activity for more than X days, overdue tasks, managers with the lowest conversion rate for the current week, number of calls and emails per day. There's no reason for a business owner to look at this — it's a tool for the sales manager to know first thing in the morning where to go with the fire extinguisher.
Template 2: Strategic Dashboard for the Business Owner
Monthly and quarterly revenue trends, average deal size broken down by product or direction, customer sources, LTV (if there are repeat purchases), plan vs. actual comparison. Updates once a day. The owner checks it once a week and sees the full picture without having to ask "so how are things going?"
Template 3: Marketing + Sales Performance Dashboard
Combines CRM data with ad platform data (Google Ads, Meta). Shows: how many leads came from each channel, what the conversion rate to deal is, what the customer acquisition cost (CAC) is, and what revenue each channel generates. This is the report for anyone who wants to know whether their advertising is actually paying off — not just feel like it is.
This approach — having marketing and sales see shared data — is part of what we build when working on a full sales team setup. Without unified analytics, these two functions usually operate in parallel universes.
This approach — having marketing and sales see shared data — is part of what we build when working on a full sales team setup. Without unified analytics, these two functions usually operate in parallel universes.
How to get a template
Looker Studio templates are shared as links — you open it, make a copy, connect your own data source, and adapt it to your field names. This takes anywhere from 30 minutes to a few hours depending on how ready your CRM infrastructure is.
If your CRM data structure isn't clean yet, start there. A dashboard shows exactly as much as the data in the system. If managers aren't filling in fields or lead sources aren't being tracked, no Looker Studio setup will fix that. We cover what a properly configured CRM looks like in our article on CRM implementation for sales teams.
If your CRM data structure isn't clean yet, start there. A dashboard shows exactly as much as the data in the system. If managers aren't filling in fields or lead sources aren't being tracked, no Looker Studio setup will fix that. We cover what a properly configured CRM looks like in our article on CRM implementation for sales teams.
What Else You Can Connect to Looker Studio Besides CRM
Looker Studio becomes significantly more powerful when CRM is just one of several data sources. Here's what's worth adding if you have the setup in place.
Google Analytics or GA4. See how many people visited the site, which page generated the most leads, and which traffic converts into a lead. Combined with CRM data — the full chain from click to closed deal.
Google Ads and Meta Ads. Ad spend in the same dashboard as deal revenue. ROAS and real CAC become immediately visible, no calculator needed.
Google Sheets with accounting data. If your accountant tracks payments in a spreadsheet, it can be connected as an additional source — and you can see the gap between "deal closed" in CRM and "payment received" in reality.
For guidance on correctly setting up lead sources and payment tracking inside your CRM so this data is actually reliable, see our article on sales team automation.
Google Analytics or GA4. See how many people visited the site, which page generated the most leads, and which traffic converts into a lead. Combined with CRM data — the full chain from click to closed deal.
Google Ads and Meta Ads. Ad spend in the same dashboard as deal revenue. ROAS and real CAC become immediately visible, no calculator needed.
Google Sheets with accounting data. If your accountant tracks payments in a spreadsheet, it can be connected as an additional source — and you can see the gap between "deal closed" in CRM and "payment received" in reality.
For guidance on correctly setting up lead sources and payment tracking inside your CRM so this data is actually reliable, see our article on sales team automation.
Summary
The Brutal Marketing team offers a wide range of features that cater to the same needs and make the sales process truly smooth and seamless. If you want to learn more about the positive impact this intuitive sales CRM can have on your business, feel free to contact us.
Pipedrive, Kommo — these are just a few examples of intelligent CRMs for businesses that can help you optimize your sales process to achieve your sales goals. Advanced CRMs are used by sales teams of various sizes.
With this high-quality sales tool, you can create multiple sales pipelines for efficient management of the sales process stages. You can add, edit, and rename your sales deals. By using the CRM, it's easy to track the customer journey.
Pipedrive, Kommo — these are just a few examples of intelligent CRMs for businesses that can help you optimize your sales process to achieve your sales goals. Advanced CRMs are used by sales teams of various sizes.
With this high-quality sales tool, you can create multiple sales pipelines for efficient management of the sales process stages. You can add, edit, and rename your sales deals. By using the CRM, it's easy to track the customer journey.
We at Brutal Marketing will select the best CRM program for you to use in your business. We will be happy to tell you about the program's capabilities and show you which settings will exactly help you achieve the desired financial results.
Frequently Asked Questions
Is Google Looker Studio free?
Yes, the core product is completely free. You only pay for connectors if you use third-party services like Coupler.io or Supermetrics, and for the automation layer (Zapier, Make). Looker Studio itself has no monthly fee.
Do I need technical knowledge to set it up?
It depends on how you connect the data. Via Google Sheets and Zapier/Make — a basic familiarity with those tools is enough, no specialized knowledge required. Via webhook and Google Apps Script — you'll need a developer or someone with scripting experience. Via a third-party connector like Coupler.io — the easiest option, no code at all.
How often does the data in the dashboard update?
It depends on your setup. The minimum interval via third-party connectors is 15 minutes. Via Google Sheets with automation, it depends on how frequently your Zapier/Make scenario runs. Looker Studio itself caches data — the cache duration can be set anywhere from 1 to 12 hours.
Can I give someone access to the dashboard without giving them CRM access?
Yes, and this is one of the main advantages. You share a Looker Studio link with "view" or "edit" permissions. The person sees the report with no access to your CRM system whatsoever.
What if the data in our CRM is filled in inconsistently?
Clean up the CRM first — then connect Looker Studio. The dashboard reflects what's there. If half the deals have no assigned manager or no lead source recorded, the report will be inaccurate. Start with a CRM audit and standardize how fields are filled in.
Set Up Looker Studio Together with Your CRM — Tailored to Your Sales Team
At Brutal Marketing, we set up Looker Studio as part of a CRM implementation or restructuring, not as an afterthought. That means correct fields, clean data, a finished dashboard, and no "why does this show zero?" questions after launch.
If you want a dashboard that actually reflects the state of your sales team — submit a request for CRM implementation at form below. We'll dig into your specifics and build analytics that answers your real questions, not just one that looks good in a screenshot.
If you want a dashboard that actually reflects the state of your sales team — submit a request for CRM implementation at form below. We'll dig into your specifics and build analytics that answers your real questions, not just one that looks good in a screenshot.
By submitting an application, you agree to the privacy policy
© 2017-2027, Brutal Marketing
All rights reserved
© 2017-2027, Brutal Marketing
All rights reserved