Connect Hubspot to Looker 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

Hubspot
Looker Studio

Visualize Hubspot Data in Looker Studio

How to visualize Hubspot data in Looker Studio? With Kondado, you connect your Hubspot account as a data source and send information directly to Looker Studio without complex setup or intermediate databases. Marketing and sales teams can build custom dashboards to track leads, monitor deal progression, and analyze campaign performance using fresh data replicated on a configurable schedule. The platform handles the technical details, allowing business users to focus on insights rather than data preparation.

Kondado connects Hubspot to Looker Studio through a direct integration, replicating data from 24 available pipelines including Contacts, Deals, and Marketing Emails on update frequencies ranging from 5 minutes to daily, enabling near-real-time dashboard updates without requiring technical expertise or database management.

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

Combine your customer relationship data with powerful visualization capabilities to unlock actionable business intelligence. By connecting Hubspot to Looker Studio, you can blend information from the Contacts pipeline with deal data from the Deals pipeline to create comprehensive sales funnel views. Add Marketing Emails performance metrics to understand which campaigns generate quality leads, then layer in Tickets data to identify service trends affecting customer retention. These combined insights help marketing teams optimize spend, sales leaders forecast revenue accurately, and operations managers spot bottlenecks across the entire customer journey.

Try out all the features for free for 14 days

Hubspot data available in Looker Studio

24
available pipelines
805
extractable fields

Available integrations

Integration Description
Companies Includes information such as id, name, and properties related to contacts and deals.
Contact lists Presents contact lists with details on membership and relevant properties.
Contacts Brings contact information such as id, email, name, and created date.
Contacts: form submissions Includes form submissions with fields such as conversion id, content type, and form id.
Contacts: lists membership Displays the association of contacts to specific lists and their properties.
Custom object Represents custom objects with fields such as id and specific properties.
Deals Contains information about deals, including id, value, and related contacts.
Email events Records email events with details on sending, opens, and clicks.
Engagements: Calls Includes call details such as id, dispositions, and related objects.
Engagements: Emails Presents email details including id and related objects.
Engagements: Meetings This table contains information about meetings, including fields such as id, contact_id, company_id, and updated_at.
Engagements: Notes Notes table includes fields such as id, contact_id, body, and created_at, allowing tracking of relevant information.
Engagements: Tasks Tasks table presents fields such as id, contact_id, due_date, and status, facilitating activity management.
Feedback Submissions Feedback submissions table includes fields such as id, contact_id, feedback_type, and created_at, allowing analysis of responses.
Leads Leads table contains information such as id, email, status, and created_at, essential for managing potential customers.
Line Items Line items table presents fields such as id, deal_id, product_id, and quantity, useful for tracking sales.
Marketing Emails Marketing emails table includes fields such as id, subject, sent_date, and open_rate, allowing analysis of campaigns.
Owners Owners table contains fields such as id, name, email, and created_at, essential for user management.
Payments Payments table includes fields such as id, amount, payment_date, and status, useful for financial control.
Pipelines Pipelines table presents fields such as id, name, stage, and created_at, important for sales management.
Products Table contains information about products, including fields such as id, name, price, and description.
Properties Metadata Table presents metadata of properties, including fields such as name, type, and description.
Property History Table logs changes to properties, with fields such as id, created_at, and previous_value.
Tickets Table includes information about tickets, with fields such as id, status, priority, and created_at.
Companies
Includes information such as id, name, and properties related to contacts and deals.
Contact lists
Presents contact lists with details on membership and relevant properties.
Contacts
Brings contact information such as id, email, name, and created date.
Contacts: form submissions
Includes form submissions with fields such as conversion id, content type, and form id.
Contacts: lists membership
Displays the association of contacts to specific lists and their properties.
Custom object
Represents custom objects with fields such as id and specific properties.
Deals
Contains information about deals, including id, value, and related contacts.
Email events
Records email events with details on sending, opens, and clicks.
Engagements: Calls
Includes call details such as id, dispositions, and related objects.
Engagements: Emails
Presents email details including id and related objects.
Engagements: Meetings
This table contains information about meetings, including fields such as id, contact_id, company_id, and updated_at.
Engagements: Notes
Notes table includes fields such as id, contact_id, body, and created_at, allowing tracking of relevant information.
Engagements: Tasks
Tasks table presents fields such as id, contact_id, due_date, and status, facilitating activity management.
Feedback Submissions
Feedback submissions table includes fields such as id, contact_id, feedback_type, and created_at, allowing analysis of responses.
Leads
Leads table contains information such as id, email, status, and created_at, essential for managing potential customers.
Line Items
Line items table presents fields such as id, deal_id, product_id, and quantity, useful for tracking sales.
Marketing Emails
Marketing emails table includes fields such as id, subject, sent_date, and open_rate, allowing analysis of campaigns.
Owners
Owners table contains fields such as id, name, email, and created_at, essential for user management.
Payments
Payments table includes fields such as id, amount, payment_date, and status, useful for financial control.
Pipelines
Pipelines table presents fields such as id, name, stage, and created_at, important for sales management.
Products
Table contains information about products, including fields such as id, name, price, and description.
Properties Metadata
Table presents metadata of properties, including fields such as name, type, and description.
Property History
Table logs changes to properties, with fields such as id, created_at, and previous_value.
Tickets
Table includes information about tickets, with fields such as id, status, priority, and created_at.

Try out all the features for free for 14 days

How to create Hubspot dashboards in Looker Studio

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

1
Connect Hubspot as data source

Add Hubspot to your Kondado account by authenticating with your existing credentials and selecting the specific pipelines you want to replicate, such as Contacts, Deals, or Marketing Emails.

2
Select Looker Studio destination

Choose Looker Studio as your destination to send data directly without intermediate databases or complex configuration.

3
Build dashboards and set refresh

Create custom reports in Looker Studio using your replicated data, then configure automatic updates every 5 minutes, hourly, or daily to keep insights current.

Access Hubspot data in Looker 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!

Visualize Hubspot data in other BI tools

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

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

Frequently Asked Questions (FAQ)

Answers about visualizing Hubspot data in Looker Studio automatically

How do I connect Hubspot to Looker Studio without coding?
Start by adding Hubspot as a data source in your Kondado account using your standard login credentials. Select which pipelines you need, such as Contacts or Deals, then choose Looker Studio as your destination. The system creates the connection automatically, allowing you to build dashboards immediately without writing queries or managing databases.
What Hubspot data can I visualize in Looker Studio dashboards?
You can access 24 different pipelines including Contacts, Companies, Deals, Marketing Emails, Tickets, and Engagements. This means you can visualize everything from lead generation metrics and sales pipeline values to customer service response times and email campaign performance. Each pipeline contains hundreds of fields that you can blend to create comprehensive views of your customer lifecycle.
How often does Hubspot data update in Looker Studio reports?
You configure the update frequency based on your business needs, choosing intervals from every 5 minutes to daily schedules. This automated refresh keeps your dashboards current without manual exports, ensuring your marketing and sales teams always work with the latest contact interactions, deal stages, and campaign results.
Can I build a sales funnel dashboard in Looker Studio using Hubspot deals data?
Yes, by selecting the Deals pipeline and combining it with Contacts data, you can create visualizations showing conversion rates between pipeline stages. Track deal values, win rates, and sales cycle duration to identify where prospects stall and which activities accelerate closures, giving sales managers clear visibility into team performance.
Is there a template for Hubspot marketing dashboard in Looker Studio?
Kondado does not provide pre-built report templates, but you can easily create custom marketing dashboards by selecting the Marketing Emails and Contacts pipelines. Build visualizations showing open rates, click-through rates, and lead generation by campaign source to measure inbound marketing effectiveness and optimize your content strategy.
How do I share Hubspot dashboards with my team in Looker Studio?
Once you publish your dashboard in Looker Studio, use the built-in sharing features to invite team members via email or generate shareable links. Your colleagues can view the latest Hubspot metrics without needing Kondado access, making it simple to distribute insights across marketing, sales, and executive teams.
Can I combine Hubspot data with other sources in Looker Studio?
Absolutely. Looker Studio allows you to blend your Hubspot data with information from Google Sheets, BigQuery, or other platforms to create unified reports. Combine CRM data with advertising spend from Google Ads or financial data from accounting software to calculate true customer acquisition costs and lifetime value.
What KPIs should I track when visualizing Hubspot data in Looker Studio?
Focus on metrics that drive decisions: lead conversion rates by source, average deal size and sales cycle length, email engagement rates by campaign, ticket resolution times by priority, and pipeline coverage ratios. These indicators help marketing optimize channels, sales forecast accurately, and support teams maintain service levels.

Try out all the features for free for 14 days