Syncing HubSpot with your database

[Eric_Goldman]

Hey everyone,

I'm excited to share a new tool we built to make integrating with HubSpot easier - Sequin. With a couple of clicks, we'll sync your HubSpot data with your Postgres database. We keep your database in sync in real-time. Developers are using their Sequin database to build internal tools, applications, and dashboards on HubSpot in no time using SQL.

The HubSpot API is expansive but comes with some limitations. If you are in this community, then you know about how rate limits, refresh tokens, limited webhooks, and association data models make even the most simple integrations complex. With Sequin, you can skip the API and start querying for your Contacts, Companies, Deals, Custom Objects, and more using SQL and the frameworks you know and love.

For instance, what is typically a nested API call complicated by pagination and burst rate limits is now a JOIN away with Sequin:

SELECT firstname, lastname, email
FROM contact
LEFT JOIN company 
   ON contact.associatedcompanyid = company.id
WHERE company.lifecyclestage = 'opportunity';

You can start syncing HubSpot to your database totally free: https://sequin.io

If you're curious about how it all works, check out our docs: https://docs.sequin.io/hubspot/reference

We're looking forward to hearing feedback and answering any questions!

[Eric_Goldman]

Howdy everyone,

Since we first built our syncs for HubSpot last year, we’ve learned a lot about running this system in production with large HubSpot instances. We wanted to share what we learned by writing a blog post about what it takes to build production scale, real-time syncs with HubSpot.

https://blog.sequin.io/hubspot-to-postgres/

[dennisedson]

Awesome!  Thanks for sharing!!