Making sure all the email addresses you have for your customers are correct can be a pain. Syncing contacts from Pipedrive to Mailchimp and have the latter reject emails can be annoying, to say the least.
Although Pipedrive doesn’t have any baked-in invalid email detection, there is a fairly simple workaround that suits 99% of cases. Here, I’ll show you how to quickly create a Pipedrive filter that will clean out your invalid email addresses.
Step 1: Create a people filter that looks for ANY of the following conditions:
Person, email, is empty
Person, email, contains, ‘
Person, email, contains, ?
Person, email, contains, !
Person, email, contains, ,
Person, email, contains, /
Person, email, contains, [insert any other symbol]
Please note that the above symbols are just an example of some common characters that are accidentally added to emails. You might want to add other symbols for a more thorough check.
Step 2: And, for extra peace of mind, have a last look through the list and see if you spot any other invalid email address.