Syncing HubSpot Contact Changes to Notion with Zapier | Clay

Syncing HubSpot Contact Changes to Notion with Zapier | Clay

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.
Sources: Import from CRM [Clay 101] - Clay University HubSpot integration | Documentation | Clay University Import from CRM [Clay 101] - Clay University
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.
Michael J.
·
·
Here's the table link: https://app.clay.com/workspaces/333994/workbooks/wb_5TYpzkk9iQ5x/tables/t_bu5QFXGfg5pn/views/gv_THSrEMk2USzu
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
Loading attachments
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.
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! :)
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.
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?
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.
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!
Michael J.
·
·
Bo (. so the only way to do this instantly is to use something like zapier then, right?
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.
1