Google Sheets + Clearout
Determine the validity of Google Spreadsheet list email addresses with Clearout
Use this Clearout Zap template to determine the Google Spreadsheet list email address with the Clearout verification status. This template is configured to verify the email address using Clearout as part of any new row added/updated into Google Spreadsheet list, the verification status will be updated as part of custom column cell, so it is recommended to create a new custom column inside Google Spreadsheet(eg: Clearout Verification Status) in your Google Spreadsheet list if not already been created.
Use this Clearout Zap template to determine the Google Spreadsheet list email address with the Clearout verification status. This template is configured to verify the email address using Clearout as part of any new row added/updated into Google Spreadsheet list, the verification status will be updated as part of custom column cell, so it is recommended to create a new custom column inside Google Spreadsheet(eg: Clearout Verification Status) in your Google Spreadsheet list if not already been created.
- When this happens...New or Updated Spreadsheet Row
Triggers when a new row is added or modified in a spreadsheet.
- automatically do this...Verify Email Address
Verify an email address to know its status (Valid or Invalid or Catch-All or Disposable or Free Account, Spamtrap or Toxic)
- then do this!Update Spreadsheet Row
Update a row in a specific spreadsheet with optional formatting.
- Free forever for core features
- 14 day trial for premium features & apps
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItDrive
Try ItDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
