Links

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. 1.
    Go to Settings > Integrations > Private Apps and click Create Private App
  2. 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;
Last modified 7mo ago