HubSpot

Send data from HubSpot to your destinations through Freshpaint

What you'll need

• A HubSpot Account

How this works

With the HubSpot source, Freshpaint can sync data from any and all of your tables in BigQuery into our SQL Engine. You'll be able to access this data as SQL tables.

With that data, you can:

• Send to your destinations on a schedule with our Scheduled Events, keeping them in sync with HubSpot

• Send data as properties of your tracked events with SQL Transformations

• Query the data with our SQL Editor to see what you have and test that your source is working

• Combine your HubSpot data with that of any other source

Connect to HubSpot

First you will need to generate an Access Token Freshpaint can use to pull data from HubSpot. To generate an access token:

1. Go to Settings > Integrations > Private Apps and click Create Private App

2. Name the app "Freshpaint" and give the following scopes based on what objects you want to pull from HubSpot:

Campaigns	content
Companies	crm.objects.contacts.read
Contact Lists	crm.objects.contacts.read
Contacts	crm.objects.contacts.read
Contacts List Membership	crm.objects.contacts.read
Deal Pipelines	crm.objects.contacts.read and tickets
Deals	crm.objects.contacts.read
Email Events	content
Engagements	crm.objects.contacts.read
Engagement Events	sales-email-read
Forms	forms
Form Submissions	forms
Line Items	e-commerce
Owners	crm.objects.contacts.read
Products	e-commerce
Product History	crm.objects.contacts.read
Subscription Changes	content
Tickets	tickets
Workflows	automation

3. After creating the app, you will be given an access key

4. Go to the HubSpot Source in Freshpaint

5. Provide your Access Key and a start date from which you want to start syncing data

6. Select the tables you want to sync from HubSpot to Freshpaint. After setting this up, the UI should look something like this:

Now Freshpaint will continuously sync your data from HubSpot into Freshpaint

Use Cases

Uploading contacts to a destination

You can upload your contacts and all properties associated with them using a SQL query like the following:

SELECT email AS user_id, * 
FROM hubspot_contacts_properties
WHERE email IS NOT NULL;