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. Select Trigger manually.
5. Click on Trigger manually
6. Click on the "+" button to add a new node.
7. Select on Action in an app.
8. Click on 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. Click on "Choose" and select your Google Sheet document.
12. Click on "Choose" and select the Sheet you created.
13. Click on Execute step.
14. Your information 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-search
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. Click on Go back to the n8n tab and paste your API key into the Value field.field
26. Click on Save and close the window.
27. Turn on the Send Body option.
28. In the Name field, type: "firstname".
29. Drag and drop the "First Name" column element (from the left panel) into the "Value" field. It should display a reference to the first name object as shown.
30. Click on Add Parameter.
31. In the Name field, type: "lastname". Then drag and drop the "Last Name" column element (from the left panel) into the "Value" field.
32. Add another parameter. In the Name field, type: "domainOrCompany". Then drag and drop the "Company Name or Domain" column element (from the left panel) into the "Value" field.
33. Click on Execute step, the result will be displayed on the right, including the status (FOUND / NOT_FOUND), the emails and the confidence level of the email address.
34. Go back to your workflow and click on "+" to add a new node.
35. Select "Action in an app" and choose Google Sheets.
36. Select Update row in sheet.
37. Click on "Choose" and select your Google Sheet document.
38. Click on "Choose" and select the Sheet you created.
39. Click on "Select" and choose "row_number".
40. Drag and drop the "row_number" element (from the left panel) into the "row_number" field.
41. Drag and drop the "status" element (from the left panel) into the "Status" field.
42. Drag and drop the "email" element (from the left panel) into the "Email" field.
43. Drag and drop the "certainty" element (from the left panel) into the "Confidence Level" field.
44. Click on Execute step.
45. Go back to your Google Sheet document. The results will now appear automatically.
