Clay Icon

Syncing HubSpot Contact Changes to Notion with Zapier

Ā·
Ā·

I have a clay table that polls a large list in hubspot and writes those enriched contacts to a list in notion for my team. I need to figure out how to sync these clay rows with new changes on the hubspot contact properties for people within that list. The approach i thought would be best for this would be a zapier zap that is triggered upon a change of the desired contact property that needs to update, once a change is found I search for the row in my clay table, and update the record using the update record step in the zap. This didn't update the participated events row in my table, the only effect I can see that it had was removing the persons email from the import objects cell. I just want to update this participated events value for now. Am I unable to update this property because it's nested inside of my import object from hubspot? What is a solution that I can implement to update this property in order for it to sync with my hubspot values for that contact

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    For nested properties like "participated events" within an imported HubSpot object, you'll need to use Clay's "Update object" action rather than Zapier. 1. In your Clay table, add the HubSpot "Update object" enrichment 2. Configure it with: • Object type: Contact • HubSpot Object ID: The ID from your import • Set the specific property you want to update This approach directly updates the property in Clay while maintaining the connection to HubSpot.

  • Avatar of Michael J.
    Michael J.
    Ā·
    Ā·

    No, that doesn't help. I am not trying to write new updates to objects into hubspot from changes made in clay, I am trying to update values that already exist in my clay table that are out of sync with the value they represent from a hubspot object.

  • Avatar of Michael J.
    Michael J.
    Ā·
    Ā·

    Here's my zap steps: 1: trigger checks property change I want to update: 2: find row in table associated with changed object's ID 3: update record in clay

  • Avatar of Michael J.
    Michael J.
    Ā·
    Ā·

    I guess the solution was just to create a new 'Text' column and write to that instead of trying to access a value within the import objects column array.. I feel like the feature of writing to nested value should be added in the future. This is solved.

  • Avatar of Owen C.
    Owen C.
    Ā·
    Ā·

    Hey there, just wanted to check in and see if you needed a hand with any of this! Your last message makes me think this was resolved, but I just wanted to double check! :)

  • Avatar of Michael J.
    Michael J.
    Ā·
    Ā·

    I solved it by just using a new column, if there is a way for me to access the actual value from the import hubspot object array then that would be ideal, but my solution works for now.

  • Avatar of Owen C.
    Owen C.
    Ā·
    Ā·

    Ah gotcha! Glad this was resolved. Are you referring to being able to access the array of data within the HubSpot object from Zapier? Or where are you trying to access this data exactly?

  • Avatar of Michael J.
    Michael J.
    Ā·
    Ā·

    Yea exactly, was trying to access a contact property from the import object from hubspot array inside of my clay table from zapier. The zap for updating a record in a table does not allow you to access formulas and and I think it interpreted the nested value in the import object array as a formula. Once I added a plaintext column I was able to edit that field. Owen C. if there's an easier way to have my objects in the clay table automatically sync whenever changes are made to the source objects in hubspot that would be great. I played with using a lookup object to get these updated contact properties as well, but I don't think it automatically looks up the contacts when changes are made in hubspot.

  • Avatar of Bo (.
    Bo (.
    Ā·
    Ā·

    Hey, The best way to keep everything in sync is to set HubSpot as a source directly in your table. Then, turn on the ā€œUpdate Cellā€ option—this ensures each run updates the values automatically. For any lookups, you can set them to run on a daily schedule so they always pull in the latest values from HubSpot. Let me know if you need help setting that up!

  • Avatar of Michael J.
    Michael J.
    Ā·
    Ā·

    Bo (. so the only way to do this instantly is to use something like zapier then, right?

  • Avatar of Bo (.
    Bo (.
    Ā·
    Ā·

    Hey!

    You could also use a webhook—it’s a good way to send the data instantly. Just note that Clay doesn’t support true upserts, so you’ll want to manage duplicates on your end. Let me know if you have more questions.

Syncing HubSpot Contact Changes to Notion with Zapier | Clay