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.

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


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


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.


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


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


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!


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 hRandom Number From Formatter Step]@random.com after creating the contact in crm?

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 hRandom Number From Formatter Step]@random.com after creating the contact in crm?

 

Hey @gourav_evrcare - what do you need to clarify?

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?

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