100+ HubSpot tables
Contacts, Deals, Companies, Tickets, Campaigns, Custom Objects, and 100+ more tables — all synced automatically.
HubSpot Looker Studio Connector
Connect HubSpot to Looker Studio and sync 100+ data tables automatically — contacts, deals, campaigns, tickets, custom objects, and more. Point-and-click setup.
CONNECT TO LOOKER STUDIO
What is the HubSpot Looker Studio Connector?
The HubSpot Looker Studio Connector automatically syncs your HubSpot data into a dedicated database and surfaces it in Looker Studio — giving your whole team self-service access to CRM dashboards and analytics without writing a line of SQL.
Looker Studio is Google Cloud’s Free BI platform. Its unique Blend with Google Ads & GA4 acts as a single source of truth for your metrics — ensuring every dashboard and AI query returns consistent, accurate data. With the Looker Studio Connector you can integrate your entire HubSpot database with Looker Studio for dashboard creation and business analysis.
Contacts, Deals, Companies, Tickets, Campaigns, Custom Objects, and 100+ more tables — all synced automatically.
Blend HubSpot CRM data with Google Ads, GA4, Google Sheets, and BigQuery in a single Looker Studio dashboard.
Share reports with a link, embed them on any webpage, or collaborate in real time — exactly like Google Docs.
Access all 100+ tables and unlimited records for one flat monthly fee. No pay-per-record pricing.
Data coverage
Every Looker Studio Connector subscription includes the complete HubSpot data model — contacts, deals, marketing campaigns, service tickets, commerce, web analytics, custom objects, and more. All tables include your custom HubSpot properties.
All tables include custom properties. Read the full table definitions here.
How it works
No ETL engineers. No coding. Point-and-click setup that takes under 5 minutes.
Authenticate your HubSpot portal via OAuth. Super Admin access required. Takes under two minutes.
Your connector credentials are available in the Datawarehouse.io app. Add your connector database as a data source in Looker Studio using the “Add Data” button and start building dashboards immediately. Full setup instructions are available here.
Use Looker Studio’s drag-and-drop canvas to build interactive dashboards. Blend HubSpot data with Google Ads, GA4, and other sources. Share reports with a link or embed them anywhere.
Your HubSpot data should be in Looker Studio — not stuck in the platform. Start your free trial today.
Frequently asked questions
Everything you need to know before getting started.
The HubSpot Looker Studio Connector by Datawarehouse.io automatically allows you to connect HubSpot to Looker Studio. It creates all necessary tables and schemas, and continuously syncs 100+ HubSpot data tables into it.
Datawarehouse.io provisions a dedicated Azure-hosted MS SQL Server Database, creates all tables and schemas, then continuously syncs your HubSpot data on your chosen schedule. Your database credentials are available in the Datawarehouse.io app. Add the database as a data source in Looker Studio in under five minutes.
Your sync frequency depends on your plan: Lite syncs every 24 hours, Standard every 6 hours, Advanced every hour, and Max every 15 minutes. Standard, Advanced, and Max users can also set their preferred sync time.
Yes. Datawarehouse.io apps support more than just HubSpot as a data source. Additional sources such as Google Ads and LinkedIn Ads are available and included in your subscription.
Yes. All Datawarehouse.io apps allow you to add other users to your account or database. Users can be added in seconds through our self service user interface.
Yes. SOC 2 certified and GDPR compliant. All data is encrypted in transit and at rest. Only you have read-only access to your Azure SQL database. Data is processed in Azure EU West or North America depending on your billing region.
Yes. Users on the Standard (6-hour), Advanced (1-hour), and Max (15-minute) plans can set their preferred sync time from the user panel.
Yes. Our apps have been independently reviewed by HubSpot and have met their standards for security and technical quality.
Yes. A 14-day free trial is available. A free Looker Studio dashboard template is also included to help you get started quickly.
Security
Independently audited security controls covering availability, confidentiality, and processing integrity.
All data encrypted in transit and at rest. Only you have read-only access to your Azure SQL database. HubSpot authentication uses OAuth 2.0.
Data processed in Microsoft Azure EU West or North America depending on your billing region.
Independently reviewed by HubSpot for security and technical quality standards.
Join 10,000+ teams who’ve eliminated manual exports.
