We are using Zapier to build a Zap that looks up deals in HubSpot.
The issue is that the data accessible through the HubSpot Zap only provides the internal property name, not the user-friendly label. We need to access the Property Label.
- Property label: Deal Qualification
- Property Internal name: 123456789
Is there a method for looking up the property label within Zapier or HubSpot instead of relying on the internal property name?
Hey, @Anders_B
Thanks for the question. This one has come up in the past, so you are definitely not alone.
Essentially, this is a Zapier limitation, as the label isn’t exposed (as you noted). Your options are:
- Manual: Go to HubSpot Settings > Properties > [Object] > [YOUR_PROPERTY] and copy the labels you need
- API: Query our Properties API and maintain a lookup table to match internal names to labels
If you were using custom middleware, you could easily expose the labels directly. But since Zapier only provides internal property names, you’ll need to handle label mapping externally.
Talk soon! — Jaycee
Hi @Anders_B
You’re right that Zapier only exposes the internal property names. The user-friendly “Label” isn’t passed through their integration. The two ways around this today are:
- Use HubSpot’s Property Settings to look it up manually under Settings > Properties > Deals, then keep your own mapping table.
- Or, query the HubSpot Properties API, which returns both the name (internal) and the label (friendly name). Docs here:
(Accounts Dashboard | HubSpot )
(Create and edit properties )
From there, you’d maintain a simple lookup (in Google Sheets, Airtable, or in code) that your Zap checks before displaying the final value.
Some folks who hit this same wall lean on platforms like Stacksync, since it can sync both labels and values across HubSpot and other systems automatically, sparing you from having to manage that extra mapping layer yourself.
Hope this clears it up.
Short answer: Zapier’s HubSpot app exposes internal property names by design, so you can’t switch it to “labels.”
Ways to handle it:
-
Map labels via the HubSpot API inside Zapier
- Add a Webhooks by Zapier step to GET:
https://api.hubapi.com/crm/v3/properties/deals (or the object you need)
- This returns metadata with both name (internal) and label (friendly).
-
Build a lookup (internal → label) with Formatter or cache it in Storage by Zapier so later steps can translate. Keep a small lookup table.
-
Store a 2-column map (internal, label) in Zapier Storage or a Google Sheet, then do a lookup each run.
If your end goal is reporting or updating data, not just fixing this ease of use piece, you could use a 2-way connector between HubSpot and spreadsheets like Coefficient, certified on HubSpot’s marketplace, instead of Zapier.
Coefficient can pull HubSpot data with user-friendly field labels into Google Sheets/Excel, and it supports 2-way sync back to HubSpot if you need to update/write back. For reporting, blending, or scheduled refreshes, it’s simpler because you work with labels end-to-end; for data updates, you still get the internal names under the hood when needed.
Which route is best depends on what you do after the lookup. If you only need labels inside a Zap, use the Webhooks + cache approach. If you’re building reports, blending with other sources, or writing data back to HubSpot, Coefficient will likely be cleaner (and you’ll see the friendly names throughout).