Breaking News: Grepper is joining You.com. Read the official announcement!

write me a google sheet script for email validation

Mohammad Suny Shaikh answered on August 7, 2023 Popularity 2/10 Helpfulness 1/10

answer write me a google sheet script for email validation

write me a google sheet script for email validation

Comment

function validateEmails() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getRange("A2:A" + sheet.getLastRow()); // Adjust the range as needed
  
  var data = range.getValues();
  
  for (var i = 0; i < data.length; i++) {
    var email = data[i][0];
    
    if (isValidEmail(email)) {
      range.getCell(i + 1, 2).setValue("Valid");
    } else {
      range.getCell(i + 1, 2).setValue("Invalid");
    }
  }
}

function isValidEmail(email) {
  var emailPattern = /^[^\s@]+@[^\s@]+\.[^\s@]+$/;
  return emailPattern.test(email);
}

Popularity 2/10 Helpfulness 1/10 Language javascript

Source: chat.openai.com

Tags: email-validation javascript script

Link to this answer
Share Copy Link

Contributed on Aug 07 2023

Mohammad Suny Shaikh

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

write me a google sheet script for email validation

Contents

More Related Answers

write me a google sheet script for email validation

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.