Validate emails added to new Google Sheets rows with DataValidation

Many marketers use Google Sheets to store customers’ contact details. Zapier helps you keep your contact list valid and your email bounce rate low. This Google Sheets-DataValidation integration validates and grades your contacts’ email addresses.

Note: This integration only affects contacts added after it has been set up. Contacts already present in the contact list before this will not be validated. Also, this zap will not be triggered if you make changes to an already present row.

How this Google Sheets-DataValidation-Google Sheets integration works

  1. A new row is added to Google Sheets
  2. Zapier validates the email address from the newly added row
  3. Zapier saves the grade in the new row at the specified column

Apps involved

  • Google Sheets
  • DataValidation
  • Google Sheets
Validate emails added to new Google Sheets rows with DataValidation
Google Sheets integration logo

Google Sheets is the new Google Spreadsheets software. Google Sheets is available on all your devices and has all the features you come to expect from spreadsheet software. Sheets also allows you to collaborate with others in real time.

What Is Zapier?

Get Help