Skip to main content
The HubSpot live data source reads your HubSpot CRM deals, contacts and companies, each as its own table. Lightdash turns each query into a HubSpot CRM search and shows the records HubSpot returns. CRM data stays in HubSpot. It’s a level 2 integration: its API filters records and reports a total, but doesn’t group.

Before you start

  • Live data sources enabled for your organization. See Live data sources.
  • Admin role in the Lightdash project.
  • A private app access token. In HubSpot, go to Settings → Integrations → Private Apps, create an app, and give it read scopes for all three objects: crm.objects.deals.read, crm.schemas.deals.read, crm.objects.contacts.read, crm.schemas.contacts.read, crm.objects.companies.read and crm.schemas.companies.read. Copy the app’s access token.

Connect HubSpot

  1. On the nav bar, click Browse → Semantic Layer.
  2. In the sidebar, select Live data sources, then click Add.
  3. Select HubSpot.
  4. Enter a Name, such as HubSpot. People see this name in Explore and agents use it to refer to the source.
  5. Enter the Access token, then click Test access.
  6. Click Add source.
Lightdash adds Deals, Contacts and Companies tables to Explore, grouped under the source’s name.

Dimensions and metrics

Each table has these fields: Select Refresh fields from the source’s menu to read the properties again after you add one in HubSpot. A property’s field is named after its internal name, so renaming its label in HubSpot doesn’t change it. Dropdown, radio and checkbox properties show HubSpot’s internal option values, such as closedwon, not their labels. Filter with those values; each field’s description lists them. Text properties can be filtered with equals and contains, which matches whole words or part of one word. Number, date, checkbox and dropdown properties can be filtered too. Date filters work on whole days in UTC and can look ahead, which suits fields like a deal’s close date: in the next 90 days runs from today, and in the current month covers the whole month, including days still to come.

Supported features

Limits

When more records match than a query reads, Lightdash shows the first ones in the sort order you picked. Add a filter, or use Count to see how many match.

Example questions

  • “How many deals in the closed won stage closed this quarter?”
  • “Contacts created in the last 7 days, with their email and lifecycle stage.”
  • “The 50 largest open deals, by amount.”
  • “Open deals closing in the next 90 days, by close date.”

Troubleshooting

HubSpot rejected the access token. Copy the private app’s token again, or rotate it, and update the source. The private app is missing a scope. Give it the read scopes for deals, contacts and companies listed in Before you start. HubSpot rate limit reached. HubSpot allows a few searches a second per account. Wait a few seconds and run the query again. Count can’t be split by a field. Filter by the field instead, or list records without Count.