In this guide, we will show you how to connect your HubSpot instance to Census and create your first sync.
Have your HubSpot account ready
Once you are in Census, Navigate to Connections
Click the Add Service button
Select HubSpot in the dropdown list
Follow HubSpot OAuth flow to connect HubSpot. Your end state should look something like this 👇
Please follow one of our short guides depending on your data warehouse technology
After setting up your warehouse, your Census Connections Page should look like this
Now navigate to the Model section of our Dashboard
Here you will have to write SQL queries to select the data you want to see in HubSpot. Here are some ideas of data you should select
The Lifetime Value of a customer and add it to a contact or companies
The end of their trial
The date they became active in your product
The number of key activities a user did in your app in the last 7/30 days
Once you have created your model, click save.
Now head to the Sync page and click the Add Sync button
In the " What data do you want to sync?" section
For the Connection, select the data warehouse you connected in step 2
For the Source, select the model you created in step 3
Next up is the "Where do you want to sync data to?" section
Pick HubSpot as the Connection
For Object, pick the one you want to sync data to; Contact or Company.
For the " How should changes to the source be synced?" section
Select Update Only
Pick the right mapping key, it could be Email for Contacts, Domain for Companies but we recommend you use your own internal id if possible
Finally, select the fields you want to update in the Mapper in the "Which Fields should be updated?" section
Here simply map the field from your HubSpot instance to the column from your model.
The end result should look something like this
Click the Next button to see the final preview which will have a recap of what will happen when you start the sync
Now go back to your HubSpot and go view a record type (Contact or Company) that should have been updated. If everything went well, you should see your data in HubSpot
that's it, in 5 steps, you connect Census to HubSpot and started syncing customer & product data from your warehouse to HubSpot 🎉
With HubSpot, you have both a rate limit and a daily api call limit that is tied to the plan you have. See HubSpot documentation here. HubSpot doesn't have the concept of bulk API so every call is roughly a record being sync.
Public API rate limit
Records sync / Minute
HubSpot (Free & Start Plan)
600 calls / min
HubSpot (Pro & Enterprise)
900 calls / min
API Boost Add-on
1,200 calls / min
Object ID, any Text/Number
Object ID, any Text/Number
Any Custom Object
Object ID, any searchableProperty
Contact us if you want Census to support more objects for HubSpot.
As of March 2021, only properties in the searchableProperties set are usable as sync identifiers to HubSpot Custom Objects. This is a bit confusing as this label only appears in the HubSpot API (Custom Objects API Docs > Object Definitions Tab > searchableProperties). If you need a hand making one of your existing Custom Object fields as searchable, please contact Census's API Support team and we can walk you through it.
Update or Create
Contact us if you want Census to support more Sync Behaviors for HubSpot.
Census requires that the connecting HubSpot user have Super Admin permissions in order to access all supported HubSpot objects. If you have limited permissions and still want to connect Census to HubSpot, contact the contact the Census support team.