How to Clean an Email List Free in 2026

Example 1: Verifying Email Addresses with AbstractAPI in Google Sheets

Get an AbstractAPI API Key: Sign up for a free account at AbstractAPI and obtain your API key.
Create a Google Sheet: Create a new Google Sheet with a column containing the email addresses you want to verify (e.g., column A).
Open the Script Editor: In Google Sheets, go to “Tools” > “Script editor”.
Paste the following code into the Script Editor:

function verifyEmail(email) {
  // Replace with your AbstractAPI API key
  var apiKey = "YOUR_ABSTRACTAPI_API_KEY";
  var url = "https://emailvalidation.abstractapi.com/v1/?api_key=" + apiKey + "&email=" + email;

  var response = UrlFetchApp.fetch(url);
  var json = JSON.parse(response.getContentText());

  // Return validation results. Adjust these based on AbstractAPI's response fields.
  if (json.is_valid_format.value && json.deliverability === 'DELIVERABLE') {
    return "Valid";
  } else {
    return "Invalid";
  }
}

function processEmailList() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var lastRow = sheet.getLastRow();

  // Assuming email addresses are in column A, starting from row 2 (row 1 is the header)
  for (var i = 2; i <= lastRow; i++) {
    var email = sheet.getRange("A" + i).getValue();
    var verificationResult = verifyEmail(email);
    sheet.getRange("B" + i).setValue(verificationResult); // Write result to column B
    Utilities.sleep(200); //Pause briefly to avoid rate limiting.
  }
}

Replace “YOUR_ABSTRACTAPI_API_KEY” with your actual API key.
Save the script: Click the save icon and give your script a name (e.g., “EmailVerifier”).
Run the script: Select the processEmailList function in the function dropdown and click the “Run” button. You’ll need to authorize the script to access your Google Sheet and make external API calls.
Check the results: The script will write “Valid” or “Invalid” in column B next to each email address in column A.

Explanation:

The verifyEmail function calls the AbstractAPI email verification API for a single email address. It constructs the API URL with your API key and the email address. It then parses the JSON response from the API and returns “Valid” if the email is considered valid based on the API’s criteria. Otherwise, it returns “Invalid.” Adapt the condition based on the exact AbstractAPI response fields.
The processEmailList function iterates through the email addresses in column A of your Google Sheet, calls the verifyEmail function for each address, and writes the result to column B. The Utilities.sleep(200) line adds a short delay between API calls to avoid exceeding rate limits (the number of API calls you can make in a given time period). Adjust this value as needed based on the API provider’s rate limits.

Important Considerations:

API Usage Limits: Be mindful of the API’s usage limits. Free plans typically have a limited number of requests per month. You may need to upgrade to a paid plan if you have a large list.
Error Handling: The script provided is a basic example and doesn’t include extensive error handling. You may want to add error handling to catch API errors or invalid email addresses.
Data Security: Ensure you are using a reputable email verification API provider and that your API key is kept secure.

Adapting the Script for Other Email Verification APIs The script above can be adapted to work with other email verification APIs. You’ll need to modify the verifyEmail function to:

Use the correct API endpoint URL.
Pass the API key and email address in the format required by the API.
Parse the JSON response from the API and extract the relevant validation results.
Return a consistent “Valid” or “Invalid” result based on the API’s criteria.

Example: Adapting the Script for another API If another API requires the email to be in the body of a POST request, and returns a ‘score’ field instead of ‘deliverability’, the code would look like:

function verifyEmail(email) {
  // Replace with your API details
  var apiKey = "YOUR_OTHER_API_KEY";
  var apiUrl = "https://api.example.com/verify";

  var payload = {
    "email": email
  };

  var options = {
    "method": "post",
    "contentType": "application/json",
    "payload": JSON.stringify(payload),
    "headers": {
      "Authorization": "Bearer " + apiKey
    }
  };

  var response = UrlFetchApp.fetch(apiUrl, options);
  var json = JSON.parse(response.getContentText());

  // Return validation results based on 'score'.  Adjust threshold as needed.
  if (json.score > 0.7) {
    return "Valid";
  } else {
    return "Invalid";
  }
}

Key changes: The `options` object is used to configure a POST request with a JSON payload and an authorization header. The validation logic now depends on the `json.score` field and a threshold of 0.7. You need to adapt this to match the specifics of the API you are using.

Implementing Best Practices Going Forward to Maintain List Health

Cleaning your email list is an ongoing process, not a one-time event. To maintain a healthy list and prevent deliverability issues, it’s crucial to implement best practices for email list management. This section focuses on strategies for acquiring high-quality subscribers and keeping your list clean over time. Prioritizing Opt-In and Double Opt-In Opt-in and double opt-in are the gold standards for building a clean and engaged email list. Opt-in requires subscribers to actively consent to receive your emails, while double opt-in requires them to confirm their email address via a confirmation email. Double opt-in is strongly recommended, as it helps to prevent typos, fake email addresses, and spam traps from entering your list. Example 1: Implementing Double Opt-In with Your Email Marketing Platform Most email marketing platforms offer built-in support for double opt-in.

In your email marketing platform, navigate to the settings for your signup forms or email lists.
Enable the double opt-in option.
Customize the confirmation email that will be sent to new subscribers. Make sure the email clearly explains that subscribers need to click the confirmation link to verify their address and subscribe to your list.
Test the signup process to ensure that double opt-in is working correctly.

Example 2: Clearly Stating Email Subscription Intent Make sure your website or signup form clearly states that users are subscribing to receive email updates. Don’t bury the subscription option in fine print or pre-check boxes. Transparency is key to gaining genuinely interested subscribers. For instance, on a blog, the signup form might say: “Subscribe to our newsletter for weekly updates on our latest blog posts!” Regularly Segmenting and Engaging Your List Segmenting your email list allows you to send targeted emails to specific groups of subscribers based on their interests, demographics, or engagement levels. This increases engagement and reduces the likelihood of subscribers becoming inactive. Regularly engaging your list with valuable content keeps subscribers interested and reduces the risk of them forgetting about you or marking your emails as spam. Example 1: Segmenting Based on Purchase History If you sell products or services online, you can segment your email list based on customers’ purchase history. For example, you could create a segment for customers who have purchased a specific product and send them targeted emails about related products or special offers.

In your email marketing platform, create a new segment based on purchase history.
Define the criteria for the segment (e.g., customers who have purchased product X).
Send targeted emails to this segment, promoting related products or offering special discounts.

Example 2: Sending Re-Engagement Campaigns to Inactive Subscribers Subscribers who haven’t opened or clicked on your emails in a long time are likely to be disengaged or have abandoned their email address. Sending a re-engagement campaign can help you win them back or remove them from your list if they’re no longer interested.

Segment your email list based on engagement.
Identify subscribers who haven’t opened or clicked on your emails in a defined period (e.g., 6 months).
Send a re-engagement campaign to these subscribers, offering them an incentive to stay subscribed (e.g., a discount, a free gift, or access to exclusive content).
Track the results of the re-engagement campaign. Remove subscribers who don’t respond from your list.

Providing Easy Unsubscribe Options Making it easy for subscribers to unsubscribe is crucial for maintaining a healthy email list. Subscribers who can’t easily unsubscribe are more likely to mark your emails as spam, which can damage your sender reputation. Providing a clear and easily accessible unsubscribe link in every email is a legal requirement in many jurisdictions. Example 1: Adding a Clear Unsubscribe Link to Your Email Footer

In your email marketing platform, edit the email template you use for your campaigns.
Add a clear and easily visible unsubscribe link to the footer of the email. The link should say something like “Unsubscribe” or “Click here to unsubscribe”.
Ensure that the unsubscribe link works correctly and takes subscribers to a page where they can easily unsubscribe from your list.

Example 2: Offering a One-Click Unsubscribe Option Some email marketing platforms allow you to offer a one-click unsubscribe option, which allows subscribers to unsubscribe from your list with a single click, without having to confirm their decision. This can improve the user experience and reduce the likelihood of subscribers marking your emails as spam. Consult your email marketing provider’s documentation for how to implement this. Expert Quote: “Email marketing is a permission-based marketing channel. Respect your subscribers’ choices and make it easy for them to unsubscribe.” – *Email Marketing Expert* Example 2: Using EmailListVerify’s Free Credits EmailListVerify sometimes offers a small number of free credits for new users.

Sign up for an account at EmailListVerify.com.
Check if any free credits are offered upon signup.
Upload your email list.
Use the credits to verify a portion of your list. Focus on cleaning the most questionable segments first.
Download the cleaned segment.

Important Note: Carefully review the terms and conditions of free trials and limited plans. Pay attention to the verification limits, feature restrictions, and auto-renewal policies. Always cancel the trial before the renewal date if you don’t want to continue with a paid plan. Analyzing Bounce Rates from Email Campaigns Your email marketing platform provides valuable data about which email addresses are bouncing. This is an important way to identify and remove invalid addresses. Hard bounces (permanent delivery failures) are a clear indication that an address is invalid and should be removed immediately. Soft bounces (temporary delivery failures) may indicate temporary issues, but frequent soft bounces should also raise concerns. Example 1: Removing Hard Bounces from Your List

Log in to your email marketing platform (e.g., Mailchimp, Sendinblue, ActiveCampaign).
Navigate to the reports section for a recent email campaign.
Find the bounce report. This report typically lists the email addresses that hard bounced and soft bounced.
Export the list of hard bounces to a CSV file.
Open the CSV file in a spreadsheet program.
Remove the hard bounced email addresses from your main email list.
Upload the updated email list back to your email marketing platform.

Example 2: Monitoring Soft Bounce Rates and Taking Action High soft bounce rates suggest deliverability issues or that an inbox is consistently full or temporarily unavailable. Investigate addresses with repeated soft bounces.

In your email marketing platform’s reports, identify subscribers with a high number of soft bounces across multiple campaigns.
Consider sending these subscribers a re-engagement email asking them to confirm they still want to receive your emails.
If you don’t receive a response or the soft bounces persist, remove these subscribers from your list.

Advanced Techniques: Google Sheets & Email APIs (Limited Free Usage)

For those with some technical skills, using Google Sheets in conjunction with email verification APIs can offer a more automated (though still limited in free usage) approach to email list cleaning. This involves writing scripts in Google Apps Script to interact with email verification services and process the results directly within a spreadsheet. Keep in mind that these APIs are generally paid, but many offer a small number of free requests per month, which can be useful for smaller lists or testing. Setting up a Google Apps Script for Email Verification This example uses the AbstractAPI email verification API (you’ll need an API key, which you can get with a free account that offers a limited number of free requests). Example 1: Verifying Email Addresses with AbstractAPI in Google Sheets

Get an AbstractAPI API Key: Sign up for a free account at AbstractAPI and obtain your API key.
Create a Google Sheet: Create a new Google Sheet with a column containing the email addresses you want to verify (e.g., column A).
Open the Script Editor: In Google Sheets, go to “Tools” > “Script editor”.
Paste the following code into the Script Editor:

function verifyEmail(email) {
  // Replace with your AbstractAPI API key
  var apiKey = "YOUR_ABSTRACTAPI_API_KEY";
  var url = "https://emailvalidation.abstractapi.com/v1/?api_key=" + apiKey + "&email=" + email;

  var response = UrlFetchApp.fetch(url);
  var json = JSON.parse(response.getContentText());

  // Return validation results. Adjust these based on AbstractAPI's response fields.
  if (json.is_valid_format.value && json.deliverability === 'DELIVERABLE') {
    return "Valid";
  } else {
    return "Invalid";
  }
}

function processEmailList() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var lastRow = sheet.getLastRow();

  // Assuming email addresses are in column A, starting from row 2 (row 1 is the header)
  for (var i = 2; i <= lastRow; i++) {
    var email = sheet.getRange("A" + i).getValue();
    var verificationResult = verifyEmail(email);
    sheet.getRange("B" + i).setValue(verificationResult); // Write result to column B
    Utilities.sleep(200); //Pause briefly to avoid rate limiting.
  }
}

Replace “YOUR_ABSTRACTAPI_API_KEY” with your actual API key.
Save the script: Click the save icon and give your script a name (e.g., “EmailVerifier”).
Run the script: Select the processEmailList function in the function dropdown and click the “Run” button. You’ll need to authorize the script to access your Google Sheet and make external API calls.
Check the results: The script will write “Valid” or “Invalid” in column B next to each email address in column A.

Explanation:

The verifyEmail function calls the AbstractAPI email verification API for a single email address. It constructs the API URL with your API key and the email address. It then parses the JSON response from the API and returns “Valid” if the email is considered valid based on the API’s criteria. Otherwise, it returns “Invalid.” Adapt the condition based on the exact AbstractAPI response fields.
The processEmailList function iterates through the email addresses in column A of your Google Sheet, calls the verifyEmail function for each address, and writes the result to column B. The Utilities.sleep(200) line adds a short delay between API calls to avoid exceeding rate limits (the number of API calls you can make in a given time period). Adjust this value as needed based on the API provider’s rate limits.

Important Considerations:

API Usage Limits: Be mindful of the API’s usage limits. Free plans typically have a limited number of requests per month. You may need to upgrade to a paid plan if you have a large list.
Error Handling: The script provided is a basic example and doesn’t include extensive error handling. You may want to add error handling to catch API errors or invalid email addresses.
Data Security: Ensure you are using a reputable email verification API provider and that your API key is kept secure.

Adapting the Script for Other Email Verification APIs The script above can be adapted to work with other email verification APIs. You’ll need to modify the verifyEmail function to:

Use the correct API endpoint URL.
Pass the API key and email address in the format required by the API.
Parse the JSON response from the API and extract the relevant validation results.
Return a consistent “Valid” or “Invalid” result based on the API’s criteria.

function verifyEmail(email) {
  // Replace with your API details
  var apiKey = "YOUR_OTHER_API_KEY";
  var apiUrl = "https://api.example.com/verify";

  var payload = {
    "email": email
  };

  var options = {
    "method": "post",
    "contentType": "application/json",
    "payload": JSON.stringify(payload),
    "headers": {
      "Authorization": "Bearer " + apiKey
    }
  };

  var response = UrlFetchApp.fetch(apiUrl, options);
  var json = JSON.parse(response.getContentText());

  // Return validation results based on 'score'.  Adjust threshold as needed.
  if (json.score > 0.7) {
    return "Valid";
  } else {
    return "Invalid";
  }
}

Implementing Best Practices Going Forward to Maintain List Health

In your email marketing platform, navigate to the settings for your signup forms or email lists.
Enable the double opt-in option.
Customize the confirmation email that will be sent to new subscribers. Make sure the email clearly explains that subscribers need to click the confirmation link to verify their address and subscribe to your list.
Test the signup process to ensure that double opt-in is working correctly.

In your email marketing platform, create a new segment based on purchase history.
Define the criteria for the segment (e.g., customers who have purchased product X).
Send targeted emails to this segment, promoting related products or offering special discounts.

Segment your email list based on engagement.
Identify subscribers who haven’t opened or clicked on your emails in a defined period (e.g., 6 months).
Send a re-engagement campaign to these subscribers, offering them an incentive to stay subscribed (e.g., a discount, a free gift, or access to exclusive content).
Track the results of the re-engagement campaign. Remove subscribers who don’t respond from your list.

In your email marketing platform, edit the email template you use for your campaigns.
Add a clear and easily visible unsubscribe link to the footer of the email. The link should say something like “Unsubscribe” or “Click here to unsubscribe”.
Ensure that the unsubscribe link works correctly and takes subscribers to a page where they can easily unsubscribe from your list.

How to Clean an Email List for Free

A clean email list is the foundation of successful email marketing campaigns. Sending emails to invalid, inactive, or spam trap addresses damages your sender reputation, leading to lower deliverability and ultimately hurting your bottom line. Fortunately, you don’t always need expensive software to maintain a healthy list. This article provides a practical guide to cleaning your email list for free, focusing on manual methods and leveraging free tools to identify and remove problematic addresses, improving your campaign performance and protecting your sender reputation.

Manual Email List Cleaning: Your First Line of Defense

Manual cleaning is often the most overlooked, yet most effective, method for maintaining a healthy email list. While it can be time-consuming, it’s completely free and allows you to identify and remove problematic email addresses that automated tools might miss. This section focuses on specific manual techniques you can use to improve your list quality. Identifying and Removing Role Accounts Role accounts are email addresses like sales@example.com, support@example.com, or info@example.com. These aren’t tied to individual users and often have multiple people monitoring them. While not inherently bad, they tend to have lower engagement rates because the email is often forwarded and may get lost in the shuffle. Removing them can improve your engagement metrics. Example 1: Using a Spreadsheet to Filter Role Accounts

Open your email list in a spreadsheet program like Google Sheets or Microsoft Excel.
Create a new column titled “Role Account?”.
Use the following formula (adapt to your spreadsheet program’s syntax) to check for common role account prefixes: =IF(OR(LEFT(A1,4)="info",LEFT(A1,7)="support",LEFT(A1,5)="sales",LEFT(A1,6)="admin@"),"Yes","No") This formula checks if the first few characters of the email address in cell A1 match common role account prefixes.
Apply the formula to all rows in your email list.
Filter the “Role Account?” column to show only “Yes” values.
Review the filtered list. Some accounts may be legitimate (e.g., a small business owner using info@), so use your judgment. Delete the rows containing identified role accounts that you don’t want to target.

Example 2: Identifying Role Accounts with Regular Expressions If you’re comfortable with regular expressions, you can use them in spreadsheet software or a text editor to identify role accounts more efficiently. For example, in Google Sheets, you could use the `REGEXMATCH` function. The following formula checks for common role account prefixes using a regular expression: =IF(REGEXMATCH(A1, "^(info|support|sales|admin|contact)@"), "Yes", "No") This regex looks for lines that start (`^`) with one of the listed prefixes (info, support, sales, admin, contact), followed by the “@” symbol. Adapt the list of prefixes as needed for your specific industry and audience. The output will be “Yes” if a match is found and “No” otherwise. Spotting and Removing Typos and Common Misspellings Typos in email addresses are a significant source of deliverability issues. Addresses like “gmail.con” or “yaho.com” are obviously invalid and will bounce. Example 1: Searching for Common Domain Misspellings

Open your email list in your spreadsheet program.
Sort the list alphabetically by email address. This groups similar domains together.
Manually scan the domain portion of the email addresses (the part after the “@” symbol) for common typos. Look for variations like “gnail.com,” “gamil.com,” “yahho.com,” “yahoocom,” or “outlok.com”.
Correct the typos if you know the intended address (e.g., change “gamil.com” to “gmail.com”) or remove the invalid address if the correct spelling is uncertain.

Example 2: Using Find and Replace for Common Typos For common typos like “gmail.con,” you can use the “Find and Replace” function in your spreadsheet program to quickly correct multiple entries.

Open your email list in your spreadsheet program.
Select the entire column containing email addresses.
Open the “Find and Replace” dialog (usually Ctrl+H or Cmd+H).
In the “Find” field, enter the typo (e.g., “gmail.con”).
In the “Replace with” field, enter the correct spelling (e.g., “gmail.com”).
Click “Replace All”.

Be cautious when using “Replace All,” as it could inadvertently change valid addresses containing the search term. Always double-check the results. Identifying and Removing Spam Traps (Honeypots) – Prevention is Key Spam traps are email addresses used by mailbox providers (like Gmail or Yahoo) and anti-spam organizations to identify spammers. Sending emails to spam traps can severely damage your sender reputation. Finding them manually is nearly impossible. The best approach is prevention. Example 1: Implementing Double Opt-In Double opt-in requires new subscribers to confirm their email address before being added to your list. This ensures that the address is valid and that the subscriber genuinely wants to receive your emails. This is the single best preventative measure.

Configure your email signup form to send a confirmation email to new subscribers.
The confirmation email should contain a link that the subscriber must click to verify their address and subscribe to your list.
Only add subscribers to your list after they have clicked the confirmation link.

Example 2: Regularly Pruning Inactive Subscribers Subscribers who haven’t opened or clicked on your emails in a long time (e.g., 6-12 months) are more likely to be disengaged or have abandoned their email address, which could have turned into a spam trap. Regularly removing inactive subscribers reduces the risk of hitting a trap.

Segment your email list based on engagement. Most email marketing platforms offer this feature.
Identify subscribers who haven’t opened or clicked on your emails in a defined period.
Send a re-engagement campaign to these subscribers, offering them an incentive to stay subscribed.
Remove subscribers who don’t respond to the re-engagement campaign from your list.

Expert Tip: Always prioritize acquiring email addresses through opt-in methods. Avoid purchasing or scraping email lists, as these often contain spam traps and invalid addresses.

Leveraging Free Email Verification Tools

While fully comprehensive email list cleaning often requires paid services, several free tools can provide a valuable first pass at identifying invalid or risky email addresses. These tools typically offer a limited number of free verifications per day or month. This section explores how to effectively utilize these free resources. Free Email Verification Websites: Quick Single-Email Checks Many websites offer free single-email verification. You can input an email address, and the tool will perform basic checks to determine its validity. This is useful for verifying individual addresses or testing small samples of your list. However, it’s impractical for cleaning large lists. Example 1: Using Mailtester.com Mailtester.com is a free online tool that checks the existence of an email address without sending an actual email.

Go to Mailtester.com.
Enter the email address you want to verify in the provided field.
Click the “Check address” button.
Mailtester will display the results, indicating whether the address is valid and whether the mail server is configured correctly. Look for red warnings. Green is generally good, but pay attention to the details.

Example 2: Using Email Hippo’s Free Online Tool Email Hippo offers a free online email checker.

Go to Email Hippo Single Email Checker
Enter the email address into the field.
Click “Verify Email”
The tool returns a quality score and some reasons why the score was assigned.

Important Note: These free tools are limited in their capabilities. They may not detect all types of invalid addresses, such as spam traps or temporary email addresses. Free Trials and Limited Plans from Paid Services Many email verification services offer free trials or limited free plans. These can be a more effective way to clean a larger list than single-email checkers, although they typically have restrictions on the number of verifications or features available. Example 1: Using ZeroBounce’s Free Trial ZeroBounce offers a limited free trial that allows you to verify a certain number of email addresses.

Sign up for a free trial at ZeroBounce.net.
Upload your email list to ZeroBounce.
Configure the cleaning options (e.g., remove invalid addresses, spam traps, and role accounts).
Run the email verification process.
Download the cleaned list, which will contain only valid email addresses.
Important: Be sure to cancel the free trial before it expires if you don’t want to be charged for a paid subscription.

Example 2: Using EmailListVerify’s Free Credits EmailListVerify sometimes offers a small number of free credits for new users.

Sign up for an account at EmailListVerify.com.
Check if any free credits are offered upon signup.
Upload your email list.
Use the credits to verify a portion of your list. Focus on cleaning the most questionable segments first.
Download the cleaned segment.

Log in to your email marketing platform (e.g., Mailchimp, Sendinblue, ActiveCampaign).
Navigate to the reports section for a recent email campaign.
Find the bounce report. This report typically lists the email addresses that hard bounced and soft bounced.
Export the list of hard bounces to a CSV file.
Open the CSV file in a spreadsheet program.
Remove the hard bounced email addresses from your main email list.
Upload the updated email list back to your email marketing platform.

In your email marketing platform’s reports, identify subscribers with a high number of soft bounces across multiple campaigns.
Consider sending these subscribers a re-engagement email asking them to confirm they still want to receive your emails.
If you don’t receive a response or the soft bounces persist, remove these subscribers from your list.

Advanced Techniques: Google Sheets & Email APIs (Limited Free Usage)

Get an AbstractAPI API Key: Sign up for a free account at AbstractAPI and obtain your API key.
Create a Google Sheet: Create a new Google Sheet with a column containing the email addresses you want to verify (e.g., column A).
Open the Script Editor: In Google Sheets, go to “Tools” > “Script editor”.
Paste the following code into the Script Editor:

function verifyEmail(email) {
  // Replace with your AbstractAPI API key
  var apiKey = "YOUR_ABSTRACTAPI_API_KEY";
  var url = "https://emailvalidation.abstractapi.com/v1/?api_key=" + apiKey + "&email=" + email;

  var response = UrlFetchApp.fetch(url);
  var json = JSON.parse(response.getContentText());

  // Return validation results. Adjust these based on AbstractAPI's response fields.
  if (json.is_valid_format.value && json.deliverability === 'DELIVERABLE') {
    return "Valid";
  } else {
    return "Invalid";
  }
}

function processEmailList() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var lastRow = sheet.getLastRow();

  // Assuming email addresses are in column A, starting from row 2 (row 1 is the header)
  for (var i = 2; i <= lastRow; i++) {
    var email = sheet.getRange("A" + i).getValue();
    var verificationResult = verifyEmail(email);
    sheet.getRange("B" + i).setValue(verificationResult); // Write result to column B
    Utilities.sleep(200); //Pause briefly to avoid rate limiting.
  }
}

Replace “YOUR_ABSTRACTAPI_API_KEY” with your actual API key.
Save the script: Click the save icon and give your script a name (e.g., “EmailVerifier”).
Run the script: Select the processEmailList function in the function dropdown and click the “Run” button. You’ll need to authorize the script to access your Google Sheet and make external API calls.
Check the results: The script will write “Valid” or “Invalid” in column B next to each email address in column A.

Explanation:

The verifyEmail function calls the AbstractAPI email verification API for a single email address. It constructs the API URL with your API key and the email address. It then parses the JSON response from the API and returns “Valid” if the email is considered valid based on the API’s criteria. Otherwise, it returns “Invalid.” Adapt the condition based on the exact AbstractAPI response fields.
The processEmailList function iterates through the email addresses in column A of your Google Sheet, calls the verifyEmail function for each address, and writes the result to column B. The Utilities.sleep(200) line adds a short delay between API calls to avoid exceeding rate limits (the number of API calls you can make in a given time period). Adjust this value as needed based on the API provider’s rate limits.

Important Considerations:

API Usage Limits: Be mindful of the API’s usage limits. Free plans typically have a limited number of requests per month. You may need to upgrade to a paid plan if you have a large list.
Error Handling: The script provided is a basic example and doesn’t include extensive error handling. You may want to add error handling to catch API errors or invalid email addresses.
Data Security: Ensure you are using a reputable email verification API provider and that your API key is kept secure.

Adapting the Script for Other Email Verification APIs The script above can be adapted to work with other email verification APIs. You’ll need to modify the verifyEmail function to:

Use the correct API endpoint URL.
Pass the API key and email address in the format required by the API.
Parse the JSON response from the API and extract the relevant validation results.
Return a consistent “Valid” or “Invalid” result based on the API’s criteria.

function verifyEmail(email) {
  // Replace with your API details
  var apiKey = "YOUR_OTHER_API_KEY";
  var apiUrl = "https://api.example.com/verify";

  var payload = {
    "email": email
  };

  var options = {
    "method": "post",
    "contentType": "application/json",
    "payload": JSON.stringify(payload),
    "headers": {
      "Authorization": "Bearer " + apiKey
    }
  };

  var response = UrlFetchApp.fetch(apiUrl, options);
  var json = JSON.parse(response.getContentText());

  // Return validation results based on 'score'.  Adjust threshold as needed.
  if (json.score > 0.7) {
    return "Valid";
  } else {
    return "Invalid";
  }
}

Implementing Best Practices Going Forward to Maintain List Health

In your email marketing platform, navigate to the settings for your signup forms or email lists.
Enable the double opt-in option.
Customize the confirmation email that will be sent to new subscribers. Make sure the email clearly explains that subscribers need to click the confirmation link to verify their address and subscribe to your list.
Test the signup process to ensure that double opt-in is working correctly.

In your email marketing platform, create a new segment based on purchase history.
Define the criteria for the segment (e.g., customers who have purchased product X).
Send targeted emails to this segment, promoting related products or offering special discounts.

Segment your email list based on engagement.
Identify subscribers who haven’t opened or clicked on your emails in a defined period (e.g., 6 months).
Send a re-engagement campaign to these subscribers, offering them an incentive to stay subscribed (e.g., a discount, a free gift, or access to exclusive content).
Track the results of the re-engagement campaign. Remove subscribers who don’t respond from your list.

In your email marketing platform, edit the email template you use for your campaigns.
Add a clear and easily visible unsubscribe link to the footer of the email. The link should say something like “Unsubscribe” or “Click here to unsubscribe”.
Ensure that the unsubscribe link works correctly and takes subscribers to a page where they can easily unsubscribe from your list.

Implementing Best Practices Going Forward to Maintain List Health

Advanced Techniques: Google Sheets & Email APIs (Limited Free Usage)

Implementing Best Practices Going Forward to Maintain List Health

How to Clean an Email List for Free

Manual Email List Cleaning: Your First Line of Defense

Leveraging Free Email Verification Tools

Advanced Techniques: Google Sheets & Email APIs (Limited Free Usage)

Implementing Best Practices Going Forward to Maintain List Health

sell Tags

Article Monster

Ready to Boost Your Outreach?