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.