This guide walks you through setting up HubSpot on Sequin.
In just a couple of minutes, you'll have your HubSpot data syncing to your Postgres database.
Connect with HubSpot
Step 1: Create a new Sequin account at https://app.sequin.io/signup.
Step 2: Select HubSpot as the platform you want to sync.
Step 3: Under the "Add Key" section, select "Add new API key" from the drop-down and then "Connect to HubSpot".
Step 4: This will open a new window for you to log in with your HubSpot credentials. Authorize the connection with Sequin.
If you receive an error that says "You don't have permission to connect this app" please contact us. We can help you sort out which permissions your users needs to connect HubSpot to Sequin.
Step 5: Select the tables you want to sync. By default, we'll sync all tables supported by Sequin. You can adjust which tables you sync at anytime.
Step 6: You can configure which columns you want to sync for each table. Click the gear icon next to the table to open up the column mapping modal:
While we are in alpha for HubSpot, we will only sync the following tables plus any custom tables in your account. Need more tables? Send us a note!
- Line item
Step 6: Connect the destination database you want to sync your data to. We'll sync to a new schema in your Postgres database. Or, you can try Sequin out by syncing to a Postgres database we host for you (on Amazon RDS).
Step 8: Click Create.
After you click Create, we'll connect to HubSpot and begin back-filling all your data. Depending on how much data is in your HubSpot account, this process can take a while. We'll email you when your backfill is complete.
Connect to your HubSpot database
While the backfill can take a while, you can connect to your database and start querying right away.
You might use a SQL client like TablePlus to connect to your database and get a feel for how your HubSpot data is organized:
Step 1: After connecting, open TablePlus and click Create a new connection...
Step 2: Click the Import from URL button.
Step 3: Copy and paste the Connect URL from Sequin into the Connection URL in TablePlus then click Import.
Step 4: Then name your TablePlus connection and click Create.
If you're syncing to your database, you probably chose a schema like
hubspot to sync the data to. After connecting to your database, you can query your HubSpot data like this:
-- see how many contacts you have in each industry
select industry, sum(id) as count
group by industry;