Skip to main content
Best answer

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

  • Feb 24, 2025 9:07 PM UTC
  • 7 replies
  • 252 views

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 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
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

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • Answer
  • Feb 25, 2025 2:17 PM UTC

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
  • Feb 25, 2025 2:48 PM UTC

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
  • Feb 26, 2025 9:45 AM UTC

Hi ​@PaulaKern,

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


  • Author
  • Beginner
  • Feb 26, 2025 2:05 PM UTC

Worked like a champ.  Thank you for all the help


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • Feb 27, 2025 9:50 AM UTC

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
  • Feb 27, 2025 2:43 PM UTC

Thank you very much


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • Feb 28, 2025 9:24 AM UTC

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

Happy Zapping! 😁⚡