HubSpot Setup Guide
Follow our setup guide to connect HubSpot to Fivetran.
Prerequisites
To connect HubSpot to Fivetran, you need a HubSpot account with Super Admin access.
Only use an HTTPS URL with TLS version 1.2 or above.
Setup instructions
Find webhook URL
- In the Fivetran dashboard, go to your HubSpot connection setup form.
- Make a note of the Webhook URL. You will need it to configure your private app.
Create private app
Create a private app in HubSpot to enable Fivetran to access and sync your data.
Provide basic app information
- Log in to your HubSpot account.
- On the left navigation menu, select Development > Legacy Apps.
- On the top right, click Create legacy app.
- Select Private.
- Enter a Name for your private app.
- Click Upload logo to upload a logo for your app.
- Enter a Description for your app. Once you update the app details, configure the required scopes for your app.
Configure app scopes
Go to the Scopes tab.
Click Add new scope.
Select the following scopes to allow Fivetran's access to your data.
Expand to see the list of scopes
automationautomation.sequences.readaccount-info.security.readbehavioral_events.event_definitions.read_writebusiness-intelligencecommunication_preferences.readcommunication_preferences.statuses.batch.readcontentconversations.readcrm.dealsplits.read_writecrm.exportcrm.lists.readcrm.objects.appointments.readcrm.objects.carts.readcrm.objects.companies.readcrm.objects.commercepayments.readcrm.objects.contacts.readcrm.objects.courses.readcrm.objects.custom.readcrm.objects.deals.readcrm.objects.feedback_submissions.readcrm.objects.goals.readcrm.objects.invoices.readcrm.objects.leads.readcrm.objects.line_items.readcrm.objects.listings.readcrm.objects.marketing_events.readcrm.objects.marketing_events.writecrm.objects.orders.readcrm.objects.owners.readcrm.objects.partner-clients.readcrm.objects.partner-services.readcrm.objects.projects.readcrm.objects.quotes.readcrm.objects.services.readcrm.objects.subscriptions.readcrm.pipelines.orders.readcrm.schemas.companies.readcrm.schemas.contacts.readcrm.schemas.custom.readcrm.schemas.deals.reade-commerceformsmarketing.campaigns.readmarketing.campaigns.revenue.readsales-email-readsettings.users.readsettings.users.teams.readtickets
Click Update.
Setup webhook
Go to the Webhooks tab.
In the Target URL field, enter the webhook URL you found.
In the Event throttling field, enter
100.Click Create subscription to enable the webhook.
In the Which object types drop-down menu, select the Contact, Company, and Deal checkboxes.
In the Listen for which events drop-down menu, select the Deleted checkbox.
Click Subscribe.
Click Create app and then click Continue creating.
Once the app is created, validate the webhook configuration. If you want to make any modification to the webhook configuration, click Edit app.
Find access token and client secret
- In your HubSpot account, select the private legacy app you created.
- Go to the Auth tab.
- Make a note of Access token and Client secret. You will need them to configure the Fivetran.
Finish Fivetran Configuration
In the connection setup form, enter the Destination schema name of your choice.
Enter the Access Token you found.
Enter the Client Secret you found.
In the Historical Sync Time Frame field, choose how you want to sync your app data.
- If you choose Sync all historical data option, Fivetran will sync all the historical data.
- If you choose Sync data from selected date option, enter a date in the Historical Sync Start Date field. Fivetran will sync the data from the specified date.
Click Save & Test. Fivetran will take it from here and sync your data from your HubSpot account.