Skip to main content
Best answer

How to update deal stages in HubSpot using Zapier from an incoming email


I have an email that comes into Zapier from Corebridge.  It has the status of the deal on it and its an alpha status.Ex:  IN PRODUCTION.  So I go into Hubspot to Update the status but Hubspot returns the deal Status  ID.  EX:  1234567.  Since I cannot compare IN PRODUCTION TO 1234567 how do I have Hubspot return the Alpha of 1234567 or in this case IN PRODUCTION.  Can someone please help me with this.  I’m a newbie so I’m not sure how to go about it.

 

 

Best answer by SamBBest answer by SamB

Hi there ​@PaulaKern! 👋

I’d suggest setting up a lookup table for this. A lookup table can be used to convert values—like the deal status name from the email into the corresponding status ID that HubSpot is expecting. You can learn more about how to set up lookup tables here: Create lookup tables in Zaps.

Hope that helps to get you pointed in the right direction. If you run into any issues on that or have further questions at all, just let me know! 🙂

View original
Did this topic help you find an answer to your question?

7 replies

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7472 replies
  • Answer
  • February 25, 2025

Hi there ​@PaulaKern! 👋

I’d suggest setting up a lookup table for this. A lookup table can be used to convert values—like the deal status name from the email into the corresponding status ID that HubSpot is expecting. You can learn more about how to set up lookup tables here: Create lookup tables in Zaps.

Hope that helps to get you pointed in the right direction. If you run into any issues on that or have further questions at all, just let me know! 🙂


  • Author
  • Beginner
  • 3 replies
  • February 25, 2025

Thank you so much for the reply.  I will let you know how it goes.

Best Regards,

Paula Kern


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6380 replies
  • February 26, 2025

Hi ​@PaulaKern,

Please keep us updated and let us know if you need any further assistance. We’re happy to help! 🤗


  • Author
  • Beginner
  • 3 replies
  • February 26, 2025

Worked like a champ.  Thank you for all the help


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6380 replies
  • February 27, 2025

That’s awesome ​@PaulaKern! We’re glad to hear that your Zap is up and running now!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗


  • Author
  • Beginner
  • 3 replies
  • February 27, 2025

Thank you very much


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7472 replies
  • February 28, 2025

You’re most welcome, ​@PaulaKern! 🤗 Really pleased that lookup table did the trick.

Happy Zapping! 😁⚡