Skip to main content
Question

How do I transfer Hubspot deal stages as words, not numbers, to Excel via Zapier?

  • April 22, 2024
  • 7 replies
  • 173 views

Forum|alt.badge.img

Hi,

 

I’m wondering if there’s a way to set up a zap so that the deal stage is presented as the words it should be instead of the numbers. I haven’t got a zap currently set-up for it, and the numbers is how it comes when they are transferred from Hubspot to Excel. Thanks

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34068 replies
  • April 22, 2024

Hi @lachie016 

Which apps are you trying to use in the Zaps? (name)

You may need to use the concept of a lookup table:

 

 

 


Forum|alt.badge.img
  • Author
  • Beginner
  • 21 replies
  • April 22, 2024

I’m using HubSpot and Excel. If the pipeline stage details stage works, would you have an example on it. I played around with it earlier and couldn’t get what I was looking for.


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34068 replies
  • April 22, 2024

@lachie016 

For us to have more context, we would need to see screenshots with how your Zap steps are outlined and configured.

 

Try adding this Zap action: HubSpot - Get Pipeline Stage Details

 


Forum|alt.badge.img
  • Author
  • Beginner
  • 21 replies
  • April 22, 2024

I have stage 1 set up for Deal Stage and Stage 2 to find row by record ID


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6780 replies
  • April 22, 2024

Hi there @lachie016,

I’m jumping in to see if I can help!

It looks like you may have incorrectly mapped the “Pipeline Id” field with the Deal Stage ID. Could you please try remapping the “Pipeline Id” field to the Pipeline ID from the trigger?

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!


Forum|alt.badge.img
  • Author
  • Beginner
  • 21 replies
  • April 22, 2024

 

Hi, they are currently matching but nothings changes. I essentially, just want the numbers that Hubspot is giving me as the deal stage to convert to the writing it should be and how its presented in hubspot

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34068 replies
  • April 22, 2024

@lachie016 

The Pipeline ID field expects a value that is a Pipeline ID instead of a Deal Stage ID