HubSpot
Read CRM records from HubSpot into a Strata flow. Oplema can't write to HubSpot.
Before you start
- A HubSpot account with access to the records you want to read.
- Required permissions:
oauth,crm.objects.contacts.read,crm.objects.companies.readandcrm.objects.deals.read. - Optional permissions, which unlock more objects if granted:
crm.objects.tickets.read,crm.objects.products.read,crm.objects.line_items.read,crm.objects.custom.readandsales-email-read. - Requests to HubSpot come from Oplema's servers, not your browser. If your HubSpot account restricts access by network, it must allow them. Oplema doesn't promise a fixed IP address; contact us if you need to allowlist.
Connect
- In Strata, select an Input block.
- Set Source to Connectors.
- In the connector dropdown below it, choose HubSpot.
- Open the Connection dropdown and choose Create new connection.
- Set Name (optional). Without a name, the connection is labeled with your HubSpot domain.
- Select Connect to HubSpot. HubSpot's own sign-in opens in a popup. Approve access there.
The popup closes, the new connection is selected and the pickers below it load. If access later expires or you need more permissions, select the connection, then select Reconnect to HubSpot.
Read
| Setting | What it does |
|---|---|
| Object | Only objects your connection can access appear: Contacts, Companies, Deals, Tickets, Products, Line items, Emails, Calls, Meetings, Notes, Tasks and custom objects. Reconnect to grant access to more. |
| Archived only | Select to read only archived records. |
| Columns | Selected columns starts with a suggested set for standard objects, or use All columns. Record metadata is always included. |
| Related record links | Adds the IDs and labels of related records, not the records themselves. |
Select Refresh data to read again.
Limits and billing
- Reads: the first 50 MB of each download is free. After that, each download costs $0.01 per GB from your usage. Failed reads aren't charged, and a read stops when your usage runs out.
- Rate-limited or failed requests are retried up to twice.
See Billing for who pays and how usage works.
Troubleshooting
| Message | What to do |
|---|---|
HubSpot: HTTP 401. Reconnect your HubSpot account. | Select Reconnect to HubSpot. |
HubSpot: HTTP 403. This connection or account cannot access the selected data. Check permissions or reconnect. | Check your HubSpot permissions, then reconnect. |
HubSpot: selected object is unavailable; check permissions or reconnect | Reconnect and grant the object, or choose another. |
HubSpot: reconnect to verify granted permissions | Select Reconnect to HubSpot. |
HubSpot: Select at least one column | Select a column, or choose All columns. |
HubSpot: property <name> is unavailable; select properties again | The property was removed or renamed. Select columns again. |
This transfer exceeds the free 50 MB and the available usage credits | The read passed 50 MB and your usage ran out. Add usage, or read less data. |
Prepare your data. Build it in Strata.
Strata opens in your browser, with no account.