Data Studio data sync - don't overwrite option?

Data Hub Data Hub
1

Hi!

I’m syncing data to HubSpot via Data Studio and connected Google Sheet. I would like to create and update contacts but mark certain colums as “do not overwrite” like in case of regular contacts import. Is it possible with Data Studio and Google Sheet sync?

Thanks!

Jakub

2

Hi @JLewicki ! It doesn’t seem like this functionality is built into the connector yet, as it only allows you to create/update/or create and update in terms of the sync itself:

data studio_google connector.png
data studio_google connector.png1040×870 114 KB

One possible workaround is to use staging properties in HubSpot for the properties you would not like to have overridden, instead of writing directly to the final fields through the connector.

For example:

  1. Connect the Google Sheets file via Data Studio<>Google Sheet sync
  2. Map to the final properties (that you would be ok with if overridden by the value in the sheet) if a new value is added
  3. For the properties that you would not like overridden (but only updated if blank), create a property such as “Company Address (Google Sheet)” and map the data to that property instead
  4. Then, create a workflow that says:
    1. If the property “Company Address” is empty, stamp it with the value “Company Address (Google Sheet)”
3

A good workaround, thank you @EOToole! Would be much cleaner if this was natively avaiaible through the data sync, but this can do the trick.

4

Others have already mentioned this, but unfortunately that “do not overwrite” behavior isn’t supported when syncing via Data Studio / Google Sheets.

That said, since Google Sheets is already sitting in the middle of your workflow, you actually have a pretty clean option.

You could use Coefficient from HubSpot Marketplace, which connects Google Sheets ↔ HubSpot with a two-way sync directly inside the spreadsheet. From there you can control how records update - for example choosing to insert, upsert, or exclude specific fields from being written back to HubSpot.

So instead of Data Studio pushing everything and overwriting fields, you can use the Sheet as your control layer and decide exactly which columns should update HubSpot and which ones shouldn’t. It tends to work really well for this type of setup. I imagine you want Data Studio to stay live as well and Coefficient is a great option to keep the data in your spreadsheet live - so if this is a manual process, too, it could fix this issue as well.

I work at Coefficient, so happy to help if you end up exploring this route.