Gemini Conversational Analytics
Ask questions about HubSpot pipeline, campaigns, and customer data in plain English. Powered by Google Gemini — now generally available for all Looker users.
Connecteur HubSpot Looker
Connect HubSpot to Looker and sync 100+ data tables automatically — contacts, deals, campaigns, tickets, custom objects, and more. Point-and-click setup.
CONNECT TO LOOKER
What is the HubSpot Looker Connector?
The HubSpot Looker Connector automatically syncs your HubSpot data into a dedicated database and surfaces it in Looker — giving your whole team self-service access to CRM dashboards and analytics without writing a line of SQL.
Looker is Google Cloud’s enterprise BI platform. Its unique LookML semantic layer acts as a single source of truth for your metrics — ensuring every dashboard and AI query returns consistent, accurate data. With the Looker Connector you can ask questions about HubSpot pipeline, campaigns, and customer data in natural language and get instant, auditable answers.
Ask questions about HubSpot pipeline, campaigns, and customer data in plain English. Powered by Google Gemini — now generally available for all Looker users.
Looker’s LookML defines business logic once, creating a single source of truth that governs every dashboard, report, and AI query.
Works with Looker Standard, Enterprise, and Embed editions. Embed supports external-facing analytics at scale.
Works with Looker Standard, Enterprise, and Embed editions. Embed supports external-facing analytics at scale.
Data coverage
Every Looker 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 Azure SQL database credentials are available in the Datawarehouse.io app. Add the database as a connection in Looker’s admin panel and start building Explores and dashboards immediately. Full setup instructions are available here.
Use LookML to model your HubSpot data, build Explores and governed dashboards, and ask questions in natural language with Gemini Conversational Analytics. Share trusted insights across your whole team.
Your HubSpot data should be in Looker — not stuck in the platform. Start your free trial today.
Frequently asked questions
Everything you need to know before getting started.
The HubSpot Looker Connector by Datawarehouse.io automatically allows you to connect HubSpot to Looker. 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 your user panel. Add the database as a data source in Looker 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 dashboard template is also included to help you get started quickly.
Sécurité
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.
