# Linking Properties

**URL:** <https://community.hubspot.com/t/linking-properties/65564>\
**Category:** 💬 RevOps Discussions\
**Tags:** revops\
**Created:** [September 21, 2022, 3:12pm UTC](https://community.hubspot.com/t/linking-properties/65564 "2022-09-21T15:12:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![SethPerrett](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sethperrett/32/60590_2.png) [@SethPerrett](https://community.hubspot.com/u/SethPerrett)\
**Post date:** [September 21, 2022, 3:12pm UTC](https://community.hubspot.com/t/linking-properties/65564/1 "2022-09-21T15:12:29Z")

</div>

Hopefully I am posting this in the right group. 🙂

Are the any experts out there that have a hack for this scenario?

We have a file being uploaded nightly into Hubspot with these  
two properties. We don’t have the ability to easily modify this file.

email, **company\_employer\_id**  
[test@test.com,ABC123](mailto:test@test.com,ABC123)

[test2@test.com,ATX1234](mailto:test2@test.com,ATX1234)

we also have this file that has additional 3 properties that have associated company information. This file has over 400 companies and is more static.

**company\_employer\_id** ,employer\_name,version  
HBS1309,Company One,SSN  
HBS2B1425D1,Company Two,SSN

We wan’t to link the company information to the contact via the company\_employer\_id. We would then personalize emails and utilize the company information in a workflow.

Hubspot says its not possible and this thread looks similar, but maybe there is a hack.

[HubSpot Community - Comparison of properties as enrollment condition on lists/workflows - HubSpot Community](https://community.hubspot.com/t5/HubSpot-Ideas/Comparison-of-properties-as-enrollment-condition-on-lists/idi-p/24134)

Thanks!

---

<div class="post-metadata">

**Author:** ![TitiCuisset](https://avatars.discourse-cdn.com/v4/letter/t/8baadc/32.png) [@TitiCuisset](https://community.hubspot.com/u/TitiCuisset)\
**Post date:** [September 23, 2022, 9:03am UTC](https://community.hubspot.com/t/linking-properties/65564/2 "2022-09-23T09:03:52Z")

</div>

Hi @SethPerrett

Thank you for reaching out and for the details!

I cannot see a workaroud for this but I want to tag some of our experts here @LMeert [@Mike\_Eastwood](https://community.hubspot.com/t5/user/viewprofilepage/user-id/9259) @Josh can you think of anything else here for @SethPerrett ?

Thank you!

Best

Tiphaine

---

<div class="post-metadata">

**Author:** ![LMeert](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lmeert/32/103847_2.png) [@LMeert](https://community.hubspot.com/u/LMeert)\
**Post date:** [September 23, 2022, 3:34pm UTC](https://community.hubspot.com/t/linking-properties/65564/3 "2022-09-23T15:34:43Z")

</div>

Hi @SethPerrett,

I think you can achieve that easily via the Search the CRM API if you have access to custom coded actions within workflows.

However if you don’t, you can use this marketplace app, [associ8](https://app-eu1.hubspot.com/ecosystem/25940885/marketplace/apps/productivity/workflow-automation/associations-app-272901).

This app lets you associate records and also find them based on a property value.

You could set up a workflow for your imported contacts that searches through the companies email and then makes the association. See screen grab below :

 ![LMeert_0-1663947261472.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/d/8/d8b8ae4042a217e5017c1f491752b712431192c0.png)

Hope this helps !  
If it does, please consider marking this answer as a solution 🙂

Best,

Ludwig

---

<div class="post-metadata">

**Author:** ![SethPerrett](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sethperrett/32/60590_2.png) [@SethPerrett](https://community.hubspot.com/u/SethPerrett)\
**Post date:** [October 6, 2022, 11:59am UTC](https://community.hubspot.com/t/linking-properties/65564/4 "2022-10-06T11:59:36Z")

</div>

Thanks! We will give that a try.