Move Contacts to Data Cleaning

Move Contacts to Data Cleaning
Description	Move contacts from the Parvenu Verified Sheet to Parvenu Data Cleaning Sheet after the emails have been verified.
Platform	Paraobla.io
Workflow	Parvenu
Schedule/Trigger	0, 1, 2, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 19, 20, 21, 22, 23

After we have verified the emails using the Verify Emails with TrueMail via TexAu workflow, we want to keep Emails with valid and unverifiable Verification Status and remove invalid and unknown emails.

We start by importing the Parvenu Verifier and Parvenu Verified Sheets and using a Join step by Email. Then we use a Row Filter to remove any rows where Email does not contain "@."

Then we split the table down two paths using Row Filters. Path A keeps valid and unverifiable emails and Path B keeps invalid and unknown emails. Since we can still connect with contacts who have an invalid or unknown Verification Status, we don't want to remove these contacts entirely. We then use a Column Filter step to remove the Email column of Path B.

Then we use a Sheets Import to import the Parvenu Data Cleaning Sheet and use a Stack Tables step to merge Path A, Path B, new contacts who went through the Search Results Email Enrichment workflow and didn't have an email, and the Parvenu Data Cleaning Sheet together. Then we De-Dupe and use a Sheets Export to send it back to the cleaning Sheet to run the Data Cleaning workflow on.

Data Cleaning

Then we want to remove the contacts who have been passed to the next step of the workflow from the Parvenu Verified Sheet so it doesn't grow infinitely. To do this we use a List Containsstep to remove matching contacts and Sheets Export back to the Parvenu Verified Sheet.