HubSpot
Send data from HubSpot to your destinations through Freshpaint
- A HubSpot Account
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
- Combine your HubSpot data with that of any other source
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
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
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