# Output from HubSpot \`Get a Contact\` module is limited

**URL:** <https://community.make.com/t/output-from-hubspot-get-a-contact-module-is-limited/19766>\
**Category:** Questions\
**Tags:** hubspot, webhooks\
**Created:** [November 16, 2023, 5:06pm UTC](https://community.make.com/t/output-from-hubspot-get-a-contact-module-is-limited/19766 "2023-11-16T17:06:13Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Keymaker](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/keymaker/32/68222_2.png) [@Keymaker](https://community.make.com/u/Keymaker)\
**Post date:** [November 16, 2023, 5:06pm UTC](https://community.make.com/t/output-from-hubspot-get-a-contact-module-is-limited/19766/1 "2023-11-16T17:06:14Z")

</div>

**Objective**  
I want to create a Scenario that adds a new row in a Google Sheets spreadsheet when a new Contact is created in HubSpot. I only want several fields from the Contact to be populated in the new row of the spreadsheet, delimited by columns.

**Context**  
I created a Private App in HubSpot and configured everything as instructed, including authorizing Make to have access to all Contact data. The webhook works reliably, and I am also able to retrieve the relevant Contact without issue.

**Workflow**

1. Webhooks (Custom webhook): listens to HubSpot for new Contacts (immediate)
2. HubSpot CRM (Get a Contact): finds the Contact in HubSpot
3. Google Sheets (Add a row): Adds a row into a spreadsheet with select fields from the newly created Contact

**Problem**  
I am unable to populate the Google Sheet spreadsheet with data from all of the fields I desire from the HubSpot Contact. There are currently 2 things I am having trouble with:

1. While building out the HubSpot (Get a Contact) module, I am unable to find all of the fields I want to pull into the spreadsheet
2. While troubleshooting, I noticed that the HubSpot (Get a Contact) module only produces an Output consisting of several fields, which do not include all of the inputs provided during the creation of the Contact in HubSpot

The way I see it, when I fetch the Contact from HubSpot, HubSpot only passes a few fields about the Contact, from which only one or two fields are ones I actually want. Any other fields I try to pass into the spreadsheet (outside of what is in the Output in Step 2) is ignored and left blank in the spreadsheet.

What am I doing wrong, or what can I do to accomplish my objective? Thank you in advance!

---

<div class="post-metadata">

**Author:** ![NolaDigital](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/noladigital/32/226_2.png) [@NolaDigital](https://community.make.com/u/NolaDigital)\
**Post date:** [November 16, 2023, 6:00pm UTC](https://community.make.com/t/output-from-hubspot-get-a-contact-module-is-limited/19766/2 "2023-11-16T18:00:43Z")

</div>

Hey @Keymaker,

By default the `Get a Contact` module only returns a handful of items.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/7/573fd0cfb74f705d131b83e5547e7e4b32776795.png)

A solution for your problem would be to use the `Make an API Call` module instead. Here you an address the Contacts [endpoint](https://developers.hubspot.com/docs/api/crm/contacts) `/crm/v3/objects/contacts/{contactID}`. Using that, you can add properties to the Query string:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/b/2b153237873ee1920a8f8b10d1b9f42f8219aff6.png)

This will then return those properties:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/4/a485b46c371b90fefbd8554c317d00952cd85554.png)

Please note, that if the property is empty, it will not be shown. Hubspot doesn’t return empty ones.

---

<div class="post-metadata">

**Author:** ![Keymaker](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/keymaker/32/68222_2.png) [@Keymaker](https://community.make.com/u/Keymaker)\
**Post date:** [November 17, 2023, 2:11pm UTC](https://community.make.com/t/output-from-hubspot-get-a-contact-module-is-limited/19766/3 "2023-11-17T14:11:13Z")

</div>

That’s annoying. Okay, I’ll try making an API call instead and will follow-up once I’ve had a chance to implement. Thank you!

---

<div class="post-metadata">

**Author:** ![Keymaker](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/keymaker/32/68222_2.png) [@Keymaker](https://community.make.com/u/Keymaker)\
**Post date:** [November 17, 2023, 2:55pm UTC](https://community.make.com/t/output-from-hubspot-get-a-contact-module-is-limited/19766/5 "2023-11-17T14:55:24Z")

</div>

It worked, thank you! Any tips for getting an Association from the Contact? For example, the Contact Owner? I’ve tried ‘properties=contact\_owner’ but it hasn’t worked for me yet.

---

<div class="post-metadata">

**Author:** ![Keymaker](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/keymaker/32/68222_2.png) [@Keymaker](https://community.make.com/u/Keymaker)\
**Post date:** [November 17, 2023, 3:38pm UTC](https://community.make.com/t/output-from-hubspot-get-a-contact-module-is-limited/19766/6 "2023-11-17T15:38:49Z")

</div>

Found the solution to how to get the Contact Owner:

1. Add a query parameter (“properties”:“hubspot\_owner\_id”) to get the Contact Owner’s object ID ([source](https://community.hubspot.com/t5/APIs-Integrations/Get-Owner-of-a-Contact-by-Contact-API-Endpoint/m-p/513658))
2. Create a second HubSpot API call to fetch details about the Contact Owner (such as name/email) (endpoint: /crm/v3/owners/{ownerId} ([source](https://developers.hubspot.com/docs/api/crm/owners)))

Pull records into the GSheet module with data from both preceding steps.

---

<div class="post-metadata">

**Author:** ![Michaela-Inactive](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/michaela-inactive/32/29_2.png) [@Michaela-Inactive](https://community.make.com/u/Michaela-Inactive)\
**Post date:** [November 21, 2023, 8:45am UTC](https://community.make.com/t/output-from-hubspot-get-a-contact-module-is-limited/19766/7 "2023-11-21T08:45:49Z")

</div>

Heya @Keymaker welcome to the community 👋

I am just quickly stepping in to say congrats on getting the ball rolling with the assistance of @NolaDigital 💪

Thank you very much for circling back and sharing what did the trick for the benefit of the community. This could prove incredibly helpful to many 🙏

_Just FYI: I marked your last comment as a solution to keep the community organized and easy to look for answers ✅_

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [December 5, 2023, 9:07am UTC](https://community.make.com/t/output-from-hubspot-get-a-contact-module-is-limited/19766/8 "2023-12-05T09:07:26Z")

</div>


