Google Sheet to Lead Connector "Email must be an email"

[rmv]

I have a Google Sheet that should create a new contact in Lead Connector when a new row is created. The problem is almost none of these contacts give their email to us, its only a phone number. But if there is nothing in that cell on the sheet, it spits out an error saying "email must be an email". I have built this workflow in the past and it worked. What can I do?

 

[ArshilAhmad]

Hi @rmv,

Could you please share the Workflow URL in which you have this concern?

 

[rmv]

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[Supreme]

Hey @rmv

Regarding your concern, we suggest utilizing the "Create or Update Contact" action step. This feature not only creates the contact but also updates it. Additionally, if you input a phone number or an email address, you can avoid encountering errors.

 

[rmv]

Thanks that worked, but now every contact has a partial DND. How can I fix that?

 

[ArshilAhmad]

You can try selecting the DND Settings as None and see if that fixes your issue.