Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Zapier is not letting me create new contact in hubspot without email address.

G

I'm using a zap where I'm getting the new lead data, passing it to zapier webhook and then creating a contact in hubspot. Hubspot create contact api page says we can create a new contact without email address: https://developers.hubspot.com/docs/methods/contacts/create_contact

However, zapier is insisting on providing an email.

image.png


Best answer by AndrewJDavison_Luhhu

Hi @gourav_evrcare

Sadly, the Zapier integration requires one, so you'll need to provide one.

The best approach is to to create a random number using a "Formatter->Numbers->Perform Spreadsheet Operation" step and the formula "RANDBETWEEN(10000,99999)" and then setting the email address as:

[Random Number From Formatter Step]@random.com


View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

10 replies

AndrewJDavison_Luhhu
Forum|alt.badge.img+10

Hi @gourav_evrcare

Sadly, the Zapier integration requires one, so you'll need to provide one.

The best approach is to to create a random number using a "Formatter->Numbers->Perform Spreadsheet Operation" step and the formula "RANDBETWEEN(10000,99999)" and then setting the email address as:

[Random Number From Formatter Step]@random.com


We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
G

I don't think adding a random email is a right thing to do because it will be then used in hubspot for all lead tracking activities associated with that email address. onboarding email would be sent to this random address etc. you get the idea. It'll create more mess than not associating the lead with email.

If hubspot is allowing the lead to create without email address then zapier shouldn't force this restriction at all.


AndrewJDavison_Luhhu
Forum|alt.badge.img+10

It's worth keeping in mind @gourav_evrcare that most apps build and maintain their own integrations on Zapier, not the Zapier team themselves.

With that in mind, you might want to check with Hubspot support if there is a reason.


We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
G

If you can confirm that this integration is done by hubspot then surely I can approach them


AndrewJDavison_Luhhu
Forum|alt.badge.img+10

@Danvers - is Hubspot Zapier-managed or app-managed?


We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
jesse
Forum|alt.badge.img+9
  • jesseArchitect
  • Architect
  • 1348 replies
  • March 8, 2020

Just stepping in here! Yes @gourav_evrcare, this integration is managed by the HubSpot team. It looks as though we have an open feature request for what you're asking about here as well so we'll go ahead and add you to that so HubSpot is aware of your interest in this as well.

Hope that helps to clarify!


G
1 person likes this
  • G
    gourav_evrcare
G
AndrewJDavison_Luhhu wrote:

Hi @gourav_evrcare

Sadly, the Zapier integration requires one, so you'll need to provide one.

The best approach is to to create a random number using a "Formatter->Numbers->Perform Spreadsheet Operation" step and the formula "RANDBETWEEN(10000,99999)" and then setting the email address as:

[Random Number From Formatter Step]@random.com

 

I talked to hubspot team and not sure if they gonna fix this bug anytime soon. So, I think I’d go with this approach. Can I also somehow clear this [Random Number From Formatter Step]@random.com after creating the contact in crm?

AndrewJDavison_Luhhu
Forum|alt.badge.img+10
gourav_evrcare wrote:
AndrewJDavison_Luhhu wrote:

Hi @gourav_evrcare

Sadly, the Zapier integration requires one, so you'll need to provide one.

The best approach is to to create a random number using a "Formatter->Numbers->Perform Spreadsheet Operation" step and the formula "RANDBETWEEN(10000,99999)" and then setting the email address as:

[Random Number From Formatter Step]@random.com

 

I talked to hubspot team and not sure if they gonna fix this bug anytime soon. So, I think I’d go with this approach. Can I also somehow clear this [Random Number From Formatter Step]@random.com after creating the contact in crm?

 

Hey @gourav_evrcare - what do you need to clarify?

We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
P
AndrewJDavison_Luhhu wrote:

Hi @gourav_evrcare

Sadly, the Zapier integration requires one, so you'll need to provide one.

The best approach is to to create a random number using a "Formatter->Numbers->Perform Spreadsheet Operation" step and the formula "RANDBETWEEN(10000,99999)" and then setting the email address as:

[Random Number From Formatter Step]@random.com

 

Thank you for this!

To clarify, do we need to add the new “formatter” step after our “New SpreadSheet Row in Google Sheets” but before our “Create or Update Contact in Hubspot” step?

Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • April 22, 2020

Hi @Pearl Lemon Leads! In case you’ve not figured this one out - yes you need to have the Formatter step before the Create or Update Contact HubSpot step. You’d then use the output of the Formatter step in the email field. I hope that helps!

Terms & Conditions