How to Integrate the Email Verifier feature into n8n
1. If you don’t have an existing Google Sheet, create a new one.
2. Copy the cells below, replacing the email addresses with the ones you want to verify.
3. Go to n8n and click on Create Workflow.
4. Click on Add first step.
5. Select Trigger manually.
6. Click on the "+" button to add a new node.
7. Select on Action in an app.
8. Choose Google Sheets.
9. Select on Get row(s) in sheet.
10. Click on "Google Sheets account", then select "Create new credential", and connect to your Google Account.
11. Ensure that Sheet Within Document is selected.
12. Click on "Choose" and select your Google Sheet document.
13. Click on "Choose" and select the Sheet you created.
14. Click on Execute step to test, your emails should now appear in the output on the right as shown.
15. Go back to your workflow and click on "+" to add a new node.
16. Select "Action in an app" and choose HTTP Request.
17. Click on GET and select the POST Method.
18. In the URL field, paste the following:
https://app.icypeas.com/api/sync/email-verification
19. Click on "None" and select "Generic Credential Type".
20. Click on "Select" and choose "Header Auth".
21. Click on "Select Credential" and select "Create new credential".
22. In the Name field, type: "Authorization".
23. Go to Icypeas.com, sign up or log in, and navigate to the API tab.
24. Copy your API key.
25. Go back to the n8n tab and paste your API key into the Value field.
26. Click on Save and close the window.
27. Turn on the Send Body option.
28. In the Name field, type: "email".
29. Drag and drop the Email column element (from the left panel) into the Value field. It should display a reference to the email object as shown.
30. Click on Execute step, the result will be displayed on the right, including the status (FOUND / NOT_FOUND) and the confidence level of the email address.
31. Go back to your workflow and click on "+" to add a new node.
32. Select "Action in an app" and choose Google Sheets.
33. Select Update row in sheet.
34. Click on "Choose" and select your Google Sheet document.
35. Click on Choose and select the Sheet you created.
36. Click on "Select" and choose "Email".
37. Drag and drop the email column element (from the left panel) into the Email field. It should display a reference to the email field as shown.
38. Do the same with the status column element—drag and drop it into the "Status" field.
39. Do the same with the certainty column element—drag and drop it into the "Confidence Level" field.
40. Go back to your workflow and click on Execute workflow
41. Go back to your Google Sheet document. The results will now appear automatically. If an email address is not found, the "Status" and "Confidence Level" columns will remain blank, as shown.