Datapipe
Deals
A HubSpot report of deals.
Live
HubSpot for agencies and in-house teams
Sales and marketing teams use HubSpot in Datapipe to see contacts, deals, and email results from the CRM.
What connects
A HubSpot private-app token you paste, or HubSpot OAuth when the owner has added an app. Token exchange uses https://api.hubspot.com/oauth/2026-09/token. The private token is the path that works before that app exists.
What you can report on
- Contact (dimension). Contact first and last name, plus email and lifecyclestage.
- Deal (dimension). Deal name, amount, and close date for closed-won deals.
- Stage (dimension). Pipeline stage label, with deal count and amount in that stage.
- Email (dimension). Marketing email name from the email statistics API.
- Sent (metric). Recipients on a marketing email.
- Opens (metric). Opens on that email.
- Clicks (metric). Clicks on that email.
What you set up
- In HubSpot, create a private app that can read contacts, deals, and marketing emails, and paste the token.
- Or use Sign in after the owner adds a HubSpot public app.
- Create the contacts, deals, pipeline, or email report.
Limitations
The live pull reads CRM contacts, deals, pipeline totals, and marketing email counters. It does not read every property in the HubSpot catalog on this page. The older /oauth/v1 and /oauth/v3 token hosts are not used.
Last reviewed 2026-10-29. Owner: Datapipe.
Connection
Live with your own API key
Live with a private app token you paste, or with HubSpot sign-in once the owner adds an app.
Fields
Default HubSpot contact, deal, and marketing-email properties. Custom properties created in a portal are not included. Source: https://developers.hubspot.com/docs/guides/api/crm/properties. Read on 2026-10-27. 20 fields.
Synced today
- Date
date - Stage
properties.dealstage - Pipeline
properties.pipeline - Deals created
deals_created - Amount
properties.amount - Deals won
deals_won - Win rate
win_rate
Advertising
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Clicks | emails.click | Marketing email clicks. | metric · integer | Advertising |
Conversions
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Lead status | contacts.hs_lead_status | The sales lead status. | dimension · string | Conversions |
Dimensions
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
contacts.email | The contact email. | dimension · string | Dimensions | ||
| First name | contacts.firstname | The contact first name. | dimension · string | Dimensions | |
| Last name | contacts.lastname | The contact last name. | dimension · string | Dimensions | |
| Phone | contacts.phone | The contact phone number. | dimension · string | Dimensions | |
| Company | contacts.company | The contact company. | dimension · string | Dimensions | |
| Job title | contacts.jobtitle | The contact job title. | dimension · string | Dimensions | |
| Lifecycle stage | contacts.lifecyclestage | Subscriber, lead, opportunity, or customer. | dimension · string | Dimensions | |
| Deal | deals.dealname | The deal name. | dimension · string | Dimensions | |
| Stage | deals.dealstage | The deal stage. | dimension · string | Dimensions | |
| Pipeline · Synced today | deals.pipeline | The pipeline. | dimension · string | Dimensions |
Ecommerce
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Amount · Synced today | deals.amount | The deal amount. | metric · number | Ecommerce |
Engagement
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Sent | emails.sent | Marketing emails sent. | metric · integer | Engagement | |
| Opens | emails.open | Marketing email opens. | metric · integer | Engagement |
Geography
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| City | contacts.city | The contact city. | dimension · string | Geography | |
| Country | contacts.country | The contact country. | dimension · string | Geography |
Technology
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Won | deals.hs_is_closed_won | Whether the deal was won. | dimension · boolean | Technology |
Time
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Created | contacts.createdate | When the contact was created. | dimension · date | Time | |
| Close date | deals.closedate | The close date. | dimension · date | Time |
Cross-channel metrics
Spend, Impressions, Clicks, Conversions, and Revenue roll up on All channels when a field maps to them. ROAS is revenue divided by spend. CPA is spend divided by conversions. The Cross-channel column above shows the match.
Example reports
Destinations
HubSpot to Google Sheets
A sheet you can open, share, and refresh.
Included on every plan.
HubSpot to Looker Studio
Charts that read the Google Sheet this integration keeps up to date.
Included on every plan. Looker reads the sheet. There is no separate Looker install.
HubSpot to BigQuery
A warehouse table for the same columns.
Pro and Agency plans.
HubSpot to AI and MCP
Ask a question in plain English, or let another tool read the report through MCP.
Included on every plan. An AI key is optional.
HubSpot to the API
Download the rows as CSV or JSON from the report.
Included on every plan.
HubSpot to Google Drive
CSV, Excel, and an optional JSON file in a Drive folder you pick. Each client gets a Datapipe folder. The file can overwrite itself or keep the date in the name.
Included on every plan. Drive API v3 with the drive.file scope only. Enable the Google Drive API in the GCP project. Hourly, daily, or weekly.
How to connect
- Create a free account.
- Open Connections and find this source.
- Paste the key the page asks for. The steps next to the box say where to copy it.
- Open the sample report. It switches to your numbers after the key is accepted.
Refresh by plan
| Plan | Refresh | BigQuery | Price |
|---|---|---|---|
| Free | Daily | No | $0/mo |
| Starter | Daily | No | $15/mo |
| Pro | Hourly | Yes | $49/mo |
| Agency | 15 minutes | Yes | $149/mo |
FAQ
Is the HubSpot connection live?
Live with a private app token you paste, or with HubSpot sign-in once the owner adds an app.
Do I have to talk to sales?
No. Create an account, connect the source, and the first report is on Home. Sample numbers stay available when a key is missing.
How often do the numbers refresh?
Free and Starter refresh daily. Pro refreshes hourly. Agency refreshes every 15 minutes on up to 50 accounts and hourly on the rest. We keep the history for you: 90 days on Free, and for as long as you subscribe on paid plans. No warehouse to set up.
Which fields are synced today?
The list marks Synced today on the fields the current connector pulls. The rest of the list is what the platform publishes, so you can see it before you sign up.