Identifying Deal contacts and Deal companies Separately

Bengaluru
Member

I'm trying to copy my HubSpot Deals which contains both "company deals" and "contact deals" to Google Spreadsheets using Google AppsScript by an API integration that is working completly fine for me. Now, my doubt is, how to identify the deal contacts and deal companies [which are in the 1st (same) column in Google spreadsheet] separately without creating a custom property field for company deals and contact deals. And also, I'm following this link for the coding. https://medium.com/how-to-lean-startup/create-a-hubspot-custom-dashboard-with-google-spreadsheet-and.... For reference, i have attached my dummy spreadsheet, so in order to identify the deal companies and contacts just by looking at it, what should i do ? and how can it be done ? Thank you.

 

.hub1.PNG

0 Upvotes
3 Replies 3
dennisedson
Community Manager

@Bengaluru 

Probably the simplest method would be to be explicit in the deal name. 

Next would probably be a custom property like a dropdown with either contact or company as options and making it a required field

Third would be to check for associations to  the deal and maybe create an if statement looking to see if there is a company or contact associated.

@Kevin-C 👋, what do you think?

 

Thanks,

Dennis




Check out our Community Developer Blog
where we feature our Community driven developer podcast and how to content
Kevin-C
Recognized Expert | Partner

Thanks @dennisedson 

 

Hey @Bengaluru 

 

So you're trying separate the deal line items based on their association to a contact or to a company?

 

@dennisedson suggestion of custom property or naming convention is the absolute least amount work to accomplish this!

 

The other option is to establish this separation using the other Hubspot APIs. This is rather intensive as I'm not sure the association will come through using the batch read endpoint

himanshurauthan
Recognized Expert | Platinum Partner

Hi there,
 

If you are fetching company deals then maybe they are associated with the company so you can use the company name as a trigger to differentiate between company deal and contact deal.

 

Hope this will help you out!

 

Regards,

Digital Marketing & Inbound Expert In Growth Hacking Technology