What you can do with the Detrics HubSpot Integration
- Pull CRM data into spreadsheets. Build pipeline reports, lifecycle analyses, and revenue dashboards in Google Sheets without copy-pasting.
- Power Looker Studio dashboards. Auto-refreshing visualizations of contacts, deals, companies, and email campaigns.
- Ask questions in Claude. Query your HubSpot data with natural language via the Detrics MCP connector.
- Sync to BigQuery. Schedule full and incremental syncs of HubSpot objects into your data warehouse for SQL access and downstream pipelines.
Prerequisites
Before you install the integration, make sure you have:- A HubSpot account on any plan (Free, Starter, Professional, or Enterprise). Core CRM data (contacts, companies, deals, and owners) is available on all plans. Some advanced data (e.g., marketing analytics, workflows) requires a Professional or Enterprise plan and is fetched only when your portal supports it.
- A HubSpot user with Super Admin permission, or App Marketplace Access explicitly granted. HubSpot requires this permission to install any third-party app.
- A Google account, which you will use to sign up for Detrics.
Installation
The Detrics HubSpot Integration is installed and configured from inside the Detrics web app at app.detrics.io. Follow the steps below.Sign up for Detrics
Go to app.detrics.io and sign up with your Google account. Detrics is free to start, with no credit card required. If you already have a Detrics account, just sign in.
Open Data Sources
Once you are signed in, click Data Sources in the left sidebar. This page lists every platform you can connect to Detrics.
Select HubSpot
Find HubSpot in the list of available data sources and click on it. This opens the HubSpot connection page inside Detrics.
Click Connect
Click the Connect button. Detrics redirects you to HubSpot’s official OAuth authorization page.
Authorize the requested permissions
Review the permissions Detrics is requesting and click Connect app on
HubSpot’s screen. See Permissions Detrics
requests below for a full breakdown of every
scope and why we need it. All access is read-only. Detrics cannot modify
your HubSpot records, send emails, or take any action on your behalf.
Permissions Detrics requests
Detrics asks for the minimum HubSpot scopes needed to retrieve the data exposed in the HubSpot Metrics & Dimensions reference. All scopes are read-only. Detrics never requests write, delete, or send permissions.Required scopes
These scopes are requested on every install. They cover the core CRM objects every Detrics HubSpot query depends on.| HubSpot scope | What Detrics uses it for |
|---|---|
oauth | Required by HubSpot for any OAuth-based integration. Identifies the authenticated portal. |
crm.objects.contacts.read | Read your contacts so we can surface contact dimensions and counts (lifecycle stage, source, create date, total contacts, etc.). |
crm.schemas.contacts.read | Read your contact property definitions so custom contact fields are correctly typed in your reports. |
crm.objects.companies.read | Read your companies so we can surface company dimensions and metrics (industry, domain, total revenue, associated deals, etc.). |
crm.schemas.companies.read | Read your company property definitions so custom company fields are correctly typed. |
crm.objects.deals.read | Read your deals so we can surface pipeline reporting (stage, amount, close date, win rate, etc.). |
crm.schemas.deals.read | Read your deal property definitions so custom deal fields are correctly typed. |
crm.objects.owners.read | Read the HubSpot users who own contacts, companies, and deals so owner names appear in your reports instead of opaque IDs. |
Optional scopes
Detrics also requests the following optional scopes. HubSpot silently drops any optional scope your portal does not support (for example, if your plan does not include marketing tools), so requesting them does not block install on lower-tier HubSpot plans.| HubSpot scope | What Detrics uses it for |
|---|---|
business-intelligence | Read marketing campaign performance and engagement metrics (sends, opens, clicks, etc.) for email campaign reporting. |
content | Read marketing emails and blog posts so they appear as queryable dimensions alongside engagement metrics. |
e-commerce | Read line items and products so you can analyze deal composition and product-level revenue. |
forms | Read form definitions and submissions so form-driven funnel analysis is available. |
tickets | Read support tickets so you can build ticket-volume, response-time, and customer-service dashboards. |
Using your HubSpot data after connecting
Once your HubSpot portal is connected, you can query the same data from any Detrics destination:Google Sheets
Pull HubSpot data into a spreadsheet, build reports, and schedule automatic refreshes.
Looker Studio
Power Looker Studio dashboards with live HubSpot CRM and marketing data.
Claude
Ask natural-language questions about your HubSpot data using the Detrics MCP
connector.
BigQuery
Sync HubSpot objects to BigQuery on a schedule for SQL access and downstream pipelines.
Pricing
Detrics is free to start and offers paid plans for teams with higher query volumes and more destinations. The Detrics HubSpot Integration works on every Detrics plan and is included in your standard Detrics subscription, with no separate add-on cost. See the Detrics pricing page for current plans and limits.Data handling and security
- Read-only access. Detrics requests read-only scopes from HubSpot and cannot modify, delete, or send anything from your HubSpot portal.
- Encryption. Access and refresh tokens are encrypted at rest in the Detrics database, and all traffic between Detrics and HubSpot uses HTTPS.
- Token lifecycle. HubSpot access tokens expire every 30 minutes. Detrics refreshes them automatically using the refresh token issued at install. Refresh tokens are revoked the moment you disconnect (see below).
- Data retention. Detrics caches recent query results to speed up repeated requests and to power scheduled refreshes. Cached data is associated with your Detrics workspace and is not shared with any third party.
Uninstalling and disconnecting
You can disconnect the Detrics HubSpot Integration at any time from either side:From inside Detrics
- Sign in to app.detrics.io.
- Open Data Sources in the left sidebar.
- Click your HubSpot connection and select Disconnect.
From inside HubSpot
- In HubSpot, click the Settings gear in the top navigation.
- Go to Integrations → Connected Apps.
- Find Detrics, open its menu, and click Uninstall.
Requesting deletion of cached data
Disconnecting revokes the tokens and stops new syncs, but cached query results may remain in Detrics until they expire. To request immediate deletion of all cached HubSpot data associated with your workspace, email [email protected] with the subject line “HubSpot data deletion request” and the Detrics workspace name.Support
If you run into any issue installing or using the Detrics HubSpot Integration:- Email us at [email protected].
- Visit support.detrics.io for help articles and to open a ticket.
- For general connection problems, see Troubleshooting Connections.