Dashboards in minutes

Connect Pipedrive to Data Studio: Dashboards in Minutes

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Connect Pipedrive to Data Studio

How to visualize Pipedrive data in Data Studio? Start by connecting your Pipedrive account to Kondado, selecting the sales pipelines you want to replicate, and choosing Data Studio as your destination. This direct integration eliminates complex setup steps, allowing you to transform raw CRM information into interactive charts and graphs within minutes. Business teams can monitor deal progress, track team performance, and analyze sales trends without writing a single line of code or managing technical infrastructure. Whether you manage a small sales team or oversee complex agency operations, having your Pipedrive metrics available in visual format helps you identify bottlenecks and opportunities faster than browsing through standard CRM views.

16
available pipelines
235
extractable fields
  • ✓No code, no spreadsheets
  • ✓Auto-refreshed data
  • ✓14-day free trial
Connect Pipedrive now →

Try out all the features for free for 14 days

Kondado provides a direct integration between Pipedrive and Data Studio, replicating 16 different pipelines including Deals, Activities, and Organizations on a configurable schedule to keep your reports updated automatically.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Try out all the features for free for 14 days

Available data

Pipedrive data available in Data Studio

Each item below is automatically replicated by Kondado from Pipedrive into Data Studio — no schema setup, no manual mapping.

16
available pipelines
235
extractable fields
∞
Auto-refresh

Available integrations

Activities
Unique identifiers, activity types, and due dates are among the fields available for managing tasks, calls, and meetings.
Activity Fields
Fields such as name, data type, and whether the field is editable are essential for defining metadata of custom activities.
Activity Types
Different types of activities, such as tasks and meetings, are categorized to facilitate management and organization.
Deal Fields
Fields such as value, status, and creation date are fundamental for managing deals and their associated information.
Deal Products
Information about products associated with deals, including identifiers and quantities, is essential for sales tracking.
Deals
Data such as unique identifiers, titles, and values are used to manage and track the progress of deals.
Deals Flow (History)
History of changes in deals, including status and values, provides insights into the progress and evolution of sales.
Notes
Notes linked to deals, people, or organizations include fields such as content, creation date, and unique identifiers.
Organization Fields
Field definitions such as name, type, and status are crucial for managing information about organizations.
Organizations
Data such as unique identifiers, names, and status are used to manage and categorize organizations in the system.
Persons
Includes fields such as id, name, and email, enabling management of contacts and associated information.
Products
Contains information on id, name, and price, facilitating management of the product portfolio.
Sales Pipelines
Presents data on id, name, and stages, allowing visualization of the sales flow.
Stages
Includes fields such as id, name, and order, defining the stages of the sales process.
Teams
Provides data on id, name, and members, facilitating organization and management of teams.
Users
Includes information such as id, name, and email, allowing management of users and their permissions.
Full docs on the wiki → Start free trial →

Try out all the features for free for 14 days

With your Pipedrive information flowing into Looker Studio, you can combine data from multiple pipelines to uncover actionable insights. For example, merging Deals with Activities helps you understand which follow-up actions correlate with closed sales, while analyzing Organizations alongside Deal Fields reveals which company profiles generate the highest value opportunities. These combinations enable marketing teams to refine lead scoring models and help sales managers identify the most productive stages in their Sales Pipelines without switching between different screens or spreadsheets.

Try out all the features for free for 14 days

How to create Pipedrive dashboards in Data Studio

Visualize your data automatically — no spreadsheet exports or custom scripts.

1
Connect Pipedrive to Kondado

Log into Kondado and add Pipedrive as a new data source by entering your API credentials. Select which sales pipelines like Deals, Activities, and Organizations you want to replicate for visualization.

2
Select Looker Studio as Destination

Choose Looker Studio as your destination platform to enable direct data flow without intermediate databases. This creates a seamless bridge between your CRM and visualization environment.

3
Configure Refresh and Build Dashboards

Set your preferred update frequency from 5 minutes to daily, then start creating charts and graphs. Your Pipedrive Data Studio dashboard will stay current automatically, displaying fresh sales insights whenever you open your reports.

Access Pipedrive data in Data Studio and combine it with dozens of other data sources

If the source you want is not listed, drop us a chat message. We love to add new sources!

55pbx
55pbx
ActiveCampaign
ActiveCampaign
Google Ads
Google Ads
Amazon S3
Amazon S3
api4com
api4com
Apple App Store
Apple App Store
ASAAS
ASAAS
AWS CloudWatch Metrics
AWS CloudWatch Metrics
Azure Table Storage
Azure Table Storage
BigQuery
BigQuery
Bing
Bing
Bitrix24 CRM
Bitrix24 CRM
Bling!
Bling!
Blip (take)
Blip (take)
ClickUp
ClickUp
Clockify
Clockify
ContaAzul
ContaAzul
Criteo
Criteo
E-goi
E-goi
EADBOX
EADBOX
Exact Sales
Exact Sales
Facebook Ads
Facebook Ads
Facebook
Facebook
Fatura Simples
Fatura Simples
Freshdesk
Freshdesk
FTP
FTP
Google Analytics GA4
Google Analytics GA4
Google Cloud Storage
Google Cloud Storage
Google Play Store
Google Play Store
Google Search Console
Google Search Console
Google Sheets
Google Sheets
Granatum
Granatum
Hi Platform
Hi Platform
Hotmart
Hotmart
Hubspot
Hubspot
Huggy
Huggy
InfluxDB v1
InfluxDB v1
Infusionsoft (Keap)
Infusionsoft (Keap)
Instagram Ads
Instagram Ads
Instagram
Instagram
Jira
Jira
Linkedin
Linkedin
Loja Integrada
Loja Integrada
MailChimp
MailChimp
Mandrill
Mandrill
Mautic
Mautic
Meetime
Meetime
Mercado Libre
Mercado Libre
Meta Ads
Meta Ads
Microsoft Ads
Microsoft Ads
Microsoft Advertising
Microsoft Advertising
Mixpanel
Mixpanel
monday.com
monday.com
MongoDB
MongoDB
Movidesk
Movidesk
MySQL (& MariaDB)
MySQL (& MariaDB)
NectarCRM
NectarCRM
Notion
Notion
Nuvemshop (Tiendanube)
Nuvemshop (Tiendanube)
Olist Tiny
Olist Tiny
Omie
Omie
Oracle
Oracle
Pagar.me
Pagar.me
Pinterest Ads
Pinterest Ads
Pipedrive
Pipedrive
Pipefy
Pipefy
PipeRun
PipeRun
Ploomes
Ploomes
PostgreSQL
PostgreSQL
Pushwoosh
Pushwoosh
RDStation CRM
RDStation CRM
RDStation
RDStation
Recruiterbox
Recruiterbox
Salesforce Marketing Cloud (Exact Target)
Salesforce Marketing Cloud (Exact Target)
Salesforce
Salesforce
SenseData
SenseData
Shopify
Shopify
SQLServer
SQLServer
Stilingue
Stilingue
Superlogica
Superlogica
Sympla
Sympla
Taboola
Taboola
Tangerino
Tangerino
TikTok Ads
TikTok Ads
TikTok Organic
TikTok Organic
Tiny ERP
Tiny ERP
Toggl
Toggl
Tray
Tray
Trello
Trello
Twilio
Twilio
VNDA
VNDA
VTEX
VTEX
Wake Commerce
Wake Commerce
Webhook
Webhook
Wootric
Wootric
WordPress
WordPress
X Ads
X Ads
YouTube
YouTube
Zeeng
Zeeng
Zendesk Chat (Zopim)
Zendesk Chat (Zopim)
Zendesk
Zendesk

Visualize Pipedrive data in other BI tools

If the software you need is not listed, drop us a messagem. You can use almost every tool

Airtable
Pipedrive > Airtable
Alteryx
Pipedrive > Alteryx
Amazon Quicksight
Pipedrive > Amazon Quicksight
BIMachine
Pipedrive > BIMachine
Cortex
Pipedrive > Cortex
Data Studio
Pipedrive > Data Studio
Geckoboard
Pipedrive > Geckoboard
Grafana
Pipedrive > Grafana
IBM Cognos Analytics
Pipedrive > IBM Cognos Analytics
Klipfolio
Pipedrive > Klipfolio
Looker Studio
Pipedrive > Looker Studio
Looker
Pipedrive > Looker
Looqbox
Pipedrive > Looqbox
Metabase
Pipedrive > Metabase
Microstrategy
Pipedrive > Microstrategy
Pentaho
Pipedrive > Pentaho
Power BI
Pipedrive > Power BI
Qlik Cloud Analytics
Pipedrive > Qlik Cloud Analytics
Qlik Sense
Pipedrive > Qlik Sense
Qlik
Pipedrive > Qlik
QlikView
Pipedrive > QlikView
Redash
Pipedrive > Redash
Superset
Pipedrive > Superset
Tableau
Pipedrive > Tableau
BI TOTVS
Pipedrive > BI TOTVS
Zoho Analytics
Pipedrive > Zoho Analytics

Related on Kondado

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Why Kondado?

Focus on extracting value from your data and leave the rest to us

shape-data-to-dashboards icon-data-multiple-destinations

Wherever you need

With the same platform, you send data to AI (Claude/ChatGPT via MCP), reports, spreadsheets, databases, data warehouses, and data lakes. ETL and ELT

Learn More About Our Platform →
shape-data-to-dashboards icon-data-multiple-destinations

From wherever you need

Data from over 80 sources for Marketing, Ecommerce, ERPs, Customer Service, Finance, Databases, and much more

Learn More About Our Data Sources →
shape-data-to-dashboards icon-data-dollar

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Frequently Asked Questions (FAQ)

Answers about visualizing Pipedrive data in Data Studio automatically

How do I connect Pipedrive to Data Studio without technical setup? ▼
Simply add Pipedrive as a data source in your Kondado account and select Looker Studio as the destination. The platform handles the data replication automatically, requiring no API configuration or database management from your side. You can start building your first dashboard within minutes of authentication.
What sales metrics can I track in a Pipedrive Data Studio dashboard? ▼
You can monitor conversion rates across different Sales Pipelines, analyze win/loss ratios using Deals Flow history, and measure team productivity by combining Activities with user performance data. Custom calculations allow you to track average deal size, sales cycle length, and revenue forecasts based on your current pipeline stages.
How frequently does my Pipedrive data refresh in Data Studio? ▼
Kondado updates your information on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. This automated refresh ensures your reports display current deal statuses and recent activities without manual exports. You can adjust the frequency based on how rapidly your sales data changes.
Can I create custom dashboards showing Pipedrive deal progression? ▼
Yes, you can build visualizations that track deals moving through specific stages using the Deals and Stages pipelines combined with time-based filters. These custom reports help sales managers identify stalled opportunities and forecast revenue by visualizing conversion rates between each pipeline stage. The drag-and-drop interface makes it easy to adjust charts as your sales process evolves.
Is it possible to share Pipedrive reports with non-CRM users? ▼
Absolutely, once your data is in Looker Studio, you can share dashboards with stakeholders who do not have Pipedrive licenses. This allows executives, marketing teams, or external partners to view sales performance metrics and collaborate on business decisions without accessing your CRM directly. Sharing permissions remain controlled through your Data Studio settings.
Do I need to store Pipedrive data in a database before visualizing it? ▼
No, Kondado connects Pipedrive directly to Looker Studio without requiring intermediate storage like BigQuery or PostgreSQL. This direct route eliminates maintenance overhead and costs associated with database management while still providing access to 235 fields across 16 different data pipelines. Your information flows straight from the CRM to your visualization tool.

Try out all the features for free for 14 days