Skip to content

CRM and sales

Connect HubSpot to DataxLand

The HubSpot connector reads contacts, companies, deals and pipelines, owners and sales activity from your HubSpot CRM. Si maps deals to the sales team's opportunity model and contacts to marketing leads, giving new opportunities, won amount, win rate, open pipeline value, sales cycle and lead-to-customer rate - one definition for dashboards, Si, Telegram or Slack reports and MCP.

Free plan with no time limit · No card required · Sample workspace ready in minutes

What you can do with HubSpot

  • Track pipeline, win rate and sales cycle per owner without exporting HubSpot reports.
  • Combine with Facebook Ads or Google Ads for cost per lead by campaign.
  • Set sales targets in Google Sheets and measure attainment with won deals in HubSpot.
  • Get a weekly Slack report of won deals and pipeline.

What data you get

Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.

Stream (table)Contents
dealsDeals, amount, stage, created and close dates, owner.
deal_pipelinesPipelines and stages, to know which stages are won or lost.
contactsContacts, source and lifecycle (personal columns such as email and phone hashed on load).
companiesCustomer companies and industry.
ownersOwners (sales reps).
engagementsCalls, emails, meetings, notes tied to deals and contacts.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Fields to fill inAuthentication
DeveloperAirbyte (certified), run inside DataxLand
LicenseELv2
Technical docsConnector documentation ↗

Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.

Metrics computed from this source

Real definitions from the analytics packs; dashboards and Si share them.

MetricDefinitionUnit
New opportunitiesSales opportunities created in the period (by creation date), including open, won and lost ones.Count
Won opportunitiesNumber of opportunities won, by close date.Count
Won amountTotal value of won opportunities, by close date.Currency
Win rateWon opportunities divided by all closed opportunities (won plus lost) in the period. Open opportunities are excluded.= Won opportunities / (Won opportunities + Lost opportunities)Ratio (%)
Open pipeline valueTotal value of opportunities created in the period that are still open (neither won nor lost).Currency
Average deal sizeWon amount divided by the number of won opportunities.= Won amount / Won opportunitiesCurrency
Average sales cycle (days)Average days from creation to win for opportunities won in the period.= won_cycle_days_total / Won opportunitiesNumber
LeadsNumber of leads (prospects) created in the period, by creation date.Count
Lead-to-customer rateLeads created in the period that have become customers divided by leads created in the period.= mkt_converted_leads / LeadsRatio (%)
Cost per lead (CPL)Marketing spend divided by leads created in the period.= Marketing spend / LeadsCurrency

Connect HubSpot in 4 steps

  1. 1

    Create a Private App

    In HubSpot → Settings → Integrations → Private Apps, create an app with read scopes for contacts, companies, deals and owners, and copy the access token.

  2. 2

    Add the source

    In the workspace choose Add source, find HubSpot in the connector library, choose Private App authentication, paste the token, click Test connection.

  3. 3

    Choose streams

    Pick deals, pipelines, contacts, companies and owners; most streams load incrementally by update time.

  4. 4

    Review Si's proposal

    Si proposes which stages are won or lost and how deals join owners; you adjust if needed and approve.

Limits and caveats

  • DataxLand does not run the HubSpot sign-in for you; use a Private App token (the form also accepts an OAuth client and refresh token from your own app).
  • Cost per lead needs an ad spend source as well; HubSpot has no spend.
  • HubSpot limits API calls by subscription; a large CRM can take a while on the first load. This is an Airbyte connector (ELv2) run inside DataxLand.

Frequently asked questions

Are custom deal properties read?

Yes; custom properties are columns of the deals table, and Si uses them as dimensions once mapped.

Does DataxLand edit CRM data?

No. The token needs read scopes only and DataxLand never writes to HubSpot.

Are contact details exposed?

Email, name and phone are hashed on load, masked before they reach Si and never returned through dashboards, the API or MCP.

Dashboard templates that use this source

Ask Si about your HubSpot data →HubSpot + Facebook Marketing →HubSpot + Google Ads →HubSpot + Stripe →All data sources →

Connect HubSpot and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes