Connect Hubspot to Metabase: 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
Metabase

Visualize Hubspot Data in Metabase

Connecting your Hubspot account to Metabase takes just minutes with Kondado’s direct integration. You simply select Hubspot as your data source, choose which pipelines to replicate such as Deals, Contacts, and Marketing Emails, and set your preferred update schedule. Your marketing, sales, and service data flows directly into Metabase where you can build comprehensive dashboards without writing any code. Business teams can track campaign performance, monitor sales pipelines, and analyze customer interactions all in one place to make faster, data-driven decisions. Whether you need near-real-time insights or daily summaries, the automated updates keep your reports current without manual exports.

Kondado connects Hubspot to Metabase using a “Via Kondado” direct integration that requires no intermediate databases or complex setup, allowing you to replicate data on a configurable schedule ranging from every 5 minutes to daily.

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

With your Hubspot data in Metabase, you can combine information from the Deals and Companies pipelines to visualize your complete sales funnel from lead acquisition to closed revenue. Marketing teams can analyze the Marketing Emails pipeline alongside Contacts to measure campaign ROI and engagement rates across different audience segments. Customer service managers can track Tickets and Feedback Submissions to identify support trends and improve response times proactively. These combined insights help you understand the full customer journey, align your teams around shared metrics, and optimize every touchpoint for better business outcomes and sustainable revenue growth.

Try out all the features for free for 14 days

Hubspot data available in Metabase

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 Metabase

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

1
Connect Hubspot as data source

Add Hubspot to your Kondado account by selecting it from the data sources list and entering your API credentials to establish the connection.

2
Select Metabase destination

Choose Metabase as your destination platform and configure the "Via Kondado" direct connection to enable seamless data flow without intermediate databases.

3
Configure dashboards and schedule

Select the specific pipelines you want to replicate, set your preferred refresh frequency from 5 minutes to daily, and start building visualizations in Metabase.

Access Hubspot data in Metabase 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 Metabase automatically

How do I connect Hubspot to Metabase without technical setup?
You start by adding Hubspot as a data source in your Kondado account and authenticating with your Hubspot credentials. Then select Metabase as your destination and choose which pipelines to replicate. The "Via Kondado" connection eliminates the need for intermediate databases or manual API configuration.
What Hubspot dashboards can I build in Metabase?
You can create custom dashboards showing sales pipeline velocity by combining Deals and Companies data, or track marketing campaign performance using Marketing Emails and Contacts. Many users also build customer service reports merging Tickets with Feedback Submissions to monitor satisfaction trends.
How often does Hubspot data update in Metabase?
You control the refresh frequency based on your business needs, choosing from every 5 minutes, 15 minutes, hourly, or daily updates. This configurable schedule ensures your dashboards reflect recent activity without overwhelming your system with unnecessary requests.
Which Hubspot KPIs should I track in Metabase?
Focus on metrics like deal conversion rates, email open and click rates from the Marketing Emails pipeline, and ticket resolution times from the Tickets data. You can also track lead response times and pipeline stage durations to identify bottlenecks in your sales process.
Are there pre-built Hubspot report templates for Metabase?
Kondado provides the data infrastructure for you to build custom dashboards tailored to your specific business processes. While pre-built templates are not available, the standardized pipeline structure makes it easy to create reports for sales forecasting, marketing attribution, and service analytics.
How do I share Hubspot dashboards with my team in Metabase?
Once you build your dashboards in Metabase, use the native sharing features to distribute reports to stakeholders across marketing, sales, and operations teams. You can set up automated email deliveries or embed dashboards in internal tools so everyone accesses the same current data.
Can I combine Hubspot data with other sources in Metabase?
Yes, you can replicate data from multiple sources into Metabase to create unified dashboards. For example, combine your Hubspot sales data with financial information from PostgreSQL or advertising metrics from Google Sheets to get a complete view of your business performance across all channels.
What is the difference between the Contacts and Companies pipelines?
The Contacts pipeline contains individual lead and customer information including email addresses and creation dates, while Companies holds organization data with associated contact relationships. Combining these in Metabase lets you analyze how many contacts belong to each company and track engagement at both the individual and account levels.

Try out all the features for free for 14 days