Email Validation is one of the APIs provided by OneSimpleApi. It allows you to verify and validate emails before they go through your workflow to ensure you only have genuine, high-quality addresses.

OneSimpleApi offers a multi-level Email Validation approach that eliminates throwaway addresses, invalid domains, and non-canonical addresses. OneSimpleApi is specially designed to work out of the box with Excel and Google Spreadsheets using the IMPORTDATA function. It provides lots of granularity to help you decide which emails to keep or discard. Today’s tutorial shows how to use this API easily.

Common use cases📎

OneSimpleApi helps to reduce the Bounce rate of Email lists, which increases the value of your mailings. One of the benefits of Email Validation is that it lowers spam complaints. This could be especially true for role addresses (addresses like sales@, support@, etc.). If you send emails without an email validation, some of your emails may be sent to role addresses on your list.

After our email checker has cleaned up the mailing list, you will have valid email addresses on hand. When you run your email campaign, recipient actions will be more reliable for analysis. The fact that you are sending emails to real email addresses makes every reply from the recipients valuable.

Saving email addresses and sending e-mails is expensive, and money is needed to maintain a database and send emails. When you validate and verify email addresses, the unwanted ones are removed from the list, and your database size is reduced. You will also send emails to real people. And that means saving money.

The accuracy of your mailing list is really important; otherwise, your team will not be able to make the most of it. If you don't validate the emails on your list, your outreach campaign won't get the results you want, and the metrics won't be as expected. You can prevent that from happening by giving your team a list of verified email addresses in the first place. After all, the outcome depends on your input, and if you provide the team with a good list, the team’s efforts will bear fruit.

Results Provided by OneSimpleApi📎

OneSimpleApi returns the deliverability score, ensuring that the address is up to your standards. It will return Good, Fair, or Bad.

1. Good emails are valid, non-disposable, non-role-based addresses and canonical addresses.
2. Fair emails are valid reputations that can be delivered but may not be canonical or are from a free email provider.
3. Bad deliverability means that address is not good, and you should leave it out.

Example Using Google Spreadsheet or Excel📎

1. Create a new spreadsheet.

2. Enter the list of Emails in the first column.

3. Enter the below formula in the second column.

   CONCATENATE("https://onesimpleapi.com/api/email?token=YOUR_TOKEN
   &output=csv&email=", A2)
   

4. Create 9 different columns to store the output provided by OneSimpleApi. Each of these columns stores the result in this order: is format valid, is domain valid, the domain has valid MX records, is email free, is email disposable, is email role, canonical, deliverability, safe to register as a user.

5. Click in the third column and paste the following code: =IMPORTDATA(B2)

   

6. Replace the YOUR_TOKEN text with the token/API key generated by OneSimpleAPI. Follow the below steps to create the token.

   i. Go to https://onesimpleapi.com/.

   ii. Sign in to your account or create one if you don't already have one.

   iii. Click on the right corner and click on your profile.

   iv. Select Api Token and enter a new key name.

   

   v. Make sure the validate_email option is checked and click the Create button.

   vi. Voila! Your API is ready.

   

   vii. Copy it and replace the text YOUR_TOKEN with the API code in your spreadsheet.

7. Hit enter & wait for the magic to happen in the background.

8. It will auto-fill all nine columns with the API Email Validation results.

9. You can simply filter out invalid or role addresses in your spreadsheet and have a clean email list!