Help Needed: Updating HubSpot Contacts and Company Mapping Issues

Share

I need help with creating/updating contacts in Hubspot using this table: https://app.clay.com/workspaces/293034/workbooks/wb_vucmVixmYr3Q/tables/t_fu2xk9pRzwN6/views/gv_FjDotMbgEzTM Specifically, I'm having trouble with the following:

1.
Passing ""GTM Events Source," "STS Event Coupon Code" and "Attended STS Event?" through to Hubspot. The information is correct for some and incorrect for others. Alexandra Trabulsi (row 5) is a good example.
2.
Passing "Contact Owner" through to Hubspot. You'll see there is an error where the "Create or Update Contact" column finds Tiffany Hicks as an owner. I've confirmed the entry maps to the data model in Hubspot so not sure what I'm doing wrong.
3.
Creating a corresponding Company that maps to the Associated Companies object in Hubspot.

I've screenshotted the most recent result of my Clay>Hubspot push below as an added reference. Thanks for your help!!

· Sorted by Oldest

Bo (.
·
·
Hey, thanks for reaching out 1-2. I'm not seeing any errors here, about this. The actual error is because “Tiffany Hicks” is being referenced by name instead of by her HubSpot owner ID. To resolve this: • Retrieve the numerical HubSpot Owner ID for Tiffany by going to the Owners section in HubSpot. • Copy this ID and replace her name in Clay with this number. Alternatively, you could create a formula column in Clay that populates the ID based on the owner’s email. 3. To create a company you need to create a company first with create a company or create or update a company. You can also run a lookup on a domain for example to find the ID of the company https://downloads.intercomcdn.com/i/o/w28k1kwz/1234287889/6d21156830158a4d75f5d0fe1159/CleanShot+2024-10-30+at+_06lCJ5XpYj%402x.png?expires=1730310300&signature=e3143b2a603650882ee63782882086697161181a49b99ffaa566d3fee6fa1fdf&req=dSIkEst2molXUPMW1HO4zVjfbtc%2BkOb%2BZbeYKnxcQhGchjZ%2BCRIFDLOrmrbl%0AQjxz%0A
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.

Bo (.
·
·
Hey, thanks for reaching out 1-2. I'm not seeing any errors here, about this. The actual error is because “Tiffany Hicks” is being referenced by name instead of by her HubSpot owner ID. To resolve this: • Retrieve the numerical HubSpot Owner ID for Tiffany by going to the Owners section in HubSpot. • Copy this ID and replace her name in Clay with this number. Alternatively, you could create a formula column in Clay that populates the ID based on the owner’s email. 3. To create a company you need to create a company first with create a company or create or update a company. You can also run a lookup on a domain for example to find the ID of the company https://downloads.intercomcdn.com/i/o/w28k1kwz/1234287889/6d21156830158a4d75f5d0fe1159/CleanShot+2024-10-30+at+_06lCJ5XpYj%402x.png?expires=1730310300&signature=e3143b2a603650882ee63782882086697161181a49b99ffaa566d3fee6fa1fdf&req=dSIkEst2molXUPMW1HO4zVjfbtc%2BkOb%2BZbeYKnxcQhGchjZ%2BCRIFDLOrmrbl%0AQjxz%0A
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.