Email Verification

Email Verification
Description	Validate whether or not an email address exists to maximize deliverability
Platform	Truemail.io and Parabola
Workflow	Parvenu
Schedule/Trigger	0, 1, 2, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 19, 20, 21, 22, 23

Next we'll use an email verifier on the results to maximize deliverability.

1. Check for Emails that Have Not Been Verified.

We start by importing the Parvenu Verifier Sheet and the Parvenu Data Cleaning Sheet. We then Stack tables on Parvenu Verifier 1-10 and Parvenu Data Cleaning. Then we we use a List Contains step to check the Parvenu Verifier Sheet against the results of the Stack tables to find which emails have not already been verified and pass those to the next step of the workflow.

2. Split the workflow into different pieces prior to enriching to any Third Party APIs.

While Parabola doesn't have great native error handing, we mitigate errors ourselves by splitting the data prior to enriching with any third party APIs. For example, if we have 75 people that we want to verify their emails, rather than verifier for 75 people and sending the results to a single Sheet, we can split those 75 people into 8 separate paths with all but the last group has 10 people each. Then as long as each of those paths remains independent after verification, one failing API call does not affect the remaining groups.

If you try to merge the 8 different paths back into a single table using Stack tables or Join, then if 1 API call fails then all 75 will fail. If you send them to 8 different Google Sheets instead of just 1, then if 1 API call fails all the API calls in that group will fail, but the other 7 Google Sheets will proceed without error.

In the below example, if there are a total of 75 people and 1 API call fails, then the 10 API calls in that API call's group will fail and the other 65 will resolve without error. The remaining 10 API calls are not lost and will be retried the next time the workflow runs.

75 Total	Pass/Fail	Amount Passed
10	Pass	10
10	Pass	10
10	Pass	10
10	1 Fails	0
10	Pass	10
10	Pass	10
10	Pass	10
5	Pass	5
75 Total	7 Pass, 1 Fails	65 Pass

3. Verify the Emails

The workflow follows the same steps for each of the sections.

1. Break the larger table into smaller pieces

2. Use TrueMail to verify the email using an API Enrichment step

3. Import the old data from Parvenu Verifier 1-10 using a Sheets Import

4. Merge the new data with the old data using a Stack tables

5. De-dupe and export back to same Parvenu Verifier 1-10 Sheet using a Sheets Export

In a separate workflow, we will merge the Parvenu Verifier 1-10 Sheets back into a single table. Splitting it in this workflow is for the sole purpose of error handling.