Fivetran connection not syncing to HubSpot Service hub

[heikodam]

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. 

[GiantFocal]

Hi @heikodam,

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

1. Verify that the Fivetran service account has the required permissions to access and sync the necessary HubSpot data.
2. 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.
3. Monitor API usage limits and watch for potential throttling issues that might affect synchronization performance.

[BérangèreL]

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 

[heikodam]

Hi, thanks for tagging those experts. 

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

[zach_threadint · Accepted solution]

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.