topic Fivetran connection not syncing to HubSpot Service hub in APIs & Integrations

Fivetran connection not syncing to HubSpot Service hub

heikodam — Thu, 28 Nov 2024 08:52:39 GMT

Hi all,

I connected Fivetran to our HubSpot account. It works for our Sales Hub and syncs daily. But for the Service Hub the surveys and the responses are not syncing somehow - we need this e.g. for our NPS score.
I was expecting a data schema to arrive in BigQuery that looks something like this: Service Hub Schema - Source Link

Some additional info:
- I have super admin rights for Service Sub and Sales Hub
- Using BigQuery as the destination (We do not have access somehow to the Hubspot BigQuery App that is in Beta)

I am new to Fivetran and the Hubspot API, would be great if anyone has suggestions of where I can look for a solution.

Re: Fivetran connection not syncing to HubSpot Service hub

BérangèreL — Thu, 28 Nov 2024 16:50:09 GMT

Hi @heikodam and welcome, we are so glad to have you here!

Thanks for asking the Community!

I understand that you are using API calls for that. Please let me know if that's not the case.

Do you know about the "Fivetran" integration? It might be of interest to you.

I'd love to put you in touch with some of our Top Experts and some Community Members:

Hi @DIntegration4, @NArtadi, @LBossi, @zach_threadint, @Mike_Eastwood and @HubSpot_Corey do you have suggestions to help @heikodam, please?

Have a great day and thanks so much!

Best,
Bérangère

Re: Fivetran connection not syncing to HubSpot Service hub

heikodam — Thu, 28 Nov 2024 19:16:06 GMT

Hi, thanks for tagging those experts.

For the connection with Hubspot I am using the "Fivetran" integration.

Re: Fivetran connection not syncing to HubSpot Service hub

GiantFocal — Fri, 29 Nov 2024 08:20:27 GMT

Hi @heikodam,

I'm not a Fivetran expert, but here are some things you can try:

Verify that the Fivetran service account has the required permissions to access and sync the necessary HubSpot data.
Please review the selected fields and tables in your Fivetran connector setup, especially for Service Hub data. You might need to specifically select the survey and NPS-related fields to ensure they are included in the sync.
Monitor API usage limits and watch for potential throttling issues that might affect synchronization performance.

Re: Fivetran connection not syncing to HubSpot Service hub

zach_threadint — Sat, 30 Nov 2024 05:11:17 GMT

Hi @heikodam 👋

Given it sounds like you've integrated via a HubSpot Public App, you're probably best to raise a support ticket directly with the developer of the Fivetran app (see the "Email support" and "Support website" links on their App Marketplace Listing).

I hope this proves helpful. Please let me know if you have any follow-up questions.