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:
Go to Settings > Integrations > Private Apps and click Create Private App
Name the app "Freshpaint" and give the following scopes based on what objects you want to pull from HubSpot:
Campaigns |
|
Companies |
|
Contact Lists |
|
Contacts |
|
Contacts List Membership |
|
Deal Pipelines |
|
Deals |
|
Email Events |
|
Engagements |
|
Engagement Events |
|
Forms |
|
Form Submissions |
|
Line Items |
|
Owners |
|
Products |
|
Product History |
|
Subscription Changes |
|
Tickets |
|
Workflows |
|
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:
Last updated