Data mapping between BQ<>HS

[YutoOshima]

Hi,

I have our own customer data stored in BigQuery, and I would like to synchronize the customer IDs in the BigQuery data set to a specific property in HubSpot's Contact object.
I have already set up the Application Integration connector between the BigQuery dataset containing the corresponding customer ID and the HubSpot contact data. Would it be possible to achieve this by using the data mapping functionality? 

I have tried manipulating the data mapping and looked at the following help page, but I am having trouble understanding the specific method...

https://cloud.google.com/application-integration/docs/data-mapping-overview

[lsolatorio]

Hi @YutoOshima,

Thank you for reaching out to our community.

I get that you wanted to link or synchronize your data between BigQuery and HubSpot, Data Mapping is a good concept to start with. Although HubSpot is not particularly a Google-owned product, let me help you look for answers.

You have mentioned that you are done setting up the integration connector but please consider reviewing Application Integration - Connectors task and Integration Connectors - HubSpot as they are the official guide for this use case.

There are also APIs available in the Google Cloud Marketplace and some other Cloud Data Fusion Plugins that can help you in this scenario. Kindly have the time to check them out.

[YutoOshima]

Hi @lsolatorio ,

Sorry for my late reply, and I appreciate your help.

After this post, I looked up some documents and found this community post is the closest to what I'm looking for. But I am still struggling with the settings...Could you navigate me the right direction?

In my case, my company stores customer info(e.g. login attempts, service usages) in Big Query, including customer ID. And also my HubSpot portal stores another type of customer info(e-mail, address), it also has a customer ID the same as Big Query has.

Then using that customer ID as a key, I would like to sync some information from Big Query to HubSpot properties for ID matched customer data. But I couldn't find the reference that explains how to do the above...
I thought this is the common use case of Google cloud application integration, thus I am hesitating to ask, but do you have the reference that explains how to set up the above? 

Thank you for your help.

[jonte393]

Hey @YutoOshima,

Did you find a way of doing this? I am just about to do the same.

I need to either update contacts in Hubspot if the email is found in my BigQuery dataset or I need to create the user if the email is not found.

Thanks in advance.

[Meenchou]

To sync information from BigQuery to HubSpot, you can use the data mapper task. However, I need to review the schema of the BigQuery and HubSpot connector objects to assist you with this use case. If possible, could you share the schema of your BigQuery connector output payload and the schema of the HubSpot connector object?

[Meenchou]

Let me know if you'd be available for discussion over a call.
@YutoOshima