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 |
|---|---|
| deals | Deals, amount, stage, created and close dates, owner. |
| deal_pipelines | Pipelines and stages, to know which stages are won or lost. |
| contacts | Contacts, source and lifecycle (personal columns such as email and phone hashed on load). |
| companies | Customer companies and industry. |
| owners | Owners (sales reps). |
| engagements | Calls, emails, meetings, notes tied to deals and contacts. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | Authentication |
| Developer | Airbyte (certified), run inside DataxLand |
| License | ELv2 |
| Technical docs | Connector 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.
| Metric | Definition | Unit |
|---|---|---|
| New opportunities | Sales opportunities created in the period (by creation date), including open, won and lost ones. | Count |
| Won opportunities | Number of opportunities won, by close date. | Count |
| Won amount | Total value of won opportunities, by close date. | Currency |
| Win rate | Won 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 value | Total value of opportunities created in the period that are still open (neither won nor lost). | Currency |
| Average deal size | Won amount divided by the number of won opportunities.= Won amount / Won opportunities | Currency |
| Average sales cycle (days) | Average days from creation to win for opportunities won in the period.= won_cycle_days_total / Won opportunities | Number |
| Leads | Number of leads (prospects) created in the period, by creation date. | Count |
| Lead-to-customer rate | Leads created in the period that have become customers divided by leads created in the period.= mkt_converted_leads / Leads | Ratio (%) |
| Cost per lead (CPL) | Marketing spend divided by leads created in the period.= Marketing spend / Leads | Currency |
Connect HubSpot in 4 steps
- 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
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
Choose streams
Pick deals, pipelines, contacts, companies and owners; most streams load incrementally by update time.
- 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
Connect HubSpot and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes