How to Integrate the Email Finder feature into Make

1. 1. If you don’t have an existing Google Sheet, create a new one.

   

2. 2. Copy the cells below, replacing the information with the ones you want to use.

   

3. 3. Go to Make and click on Create a new scenario.

   

4. 4. Select Google Sheets.

   

5. 5. Choose Search Rows (Advanced).

   

6. 6. Click on Add and connect to your Google account.

   

7. 7. Click on "Click here to choose file" and select your Google Sheet document.

   

8. 8. Clicl on "Sheet ID" and select the Sheet you created.

   

9. 9. In the Query field, type: "select A, B, C".

   

10. 10. Click on Save.

    

11. 11. Click on Add another module.

    

12. 12. Select "Icypeas" then choose "Single Email Search".

    

13. 13. Click on Add.

    

14. 14. Go to Icypeas.com, sign up or log in, and navigate to the API tab.

    

15. 15. Copy your API key and your User id.

    

16. 16. Go back to the Make tab and paste your API key and your User id.

    

17. 17. Click on Save.

    

18. 18. Click on the "First Name" field and select "(A)".

    

19. 19. Click on the "Last Name" field and select "(B)".

    

20. 20. Click on the "Domain or Company" field and select "(C)".

    

21. 21. Click on Save.

    

22. 22. Click on Run once

    

23. 23. Click on Add another module.

    

24. 24. Select Google Sheets.

    

25. 25. Choose Update a Row.

    

26. 26. Click on "Click here to choose file" and select your Google Sheet document.

    

27. 27. Select the Sheet you created.

    

28. 28. Click on the "Row number" field and select "Bundle order position".

    

29. 29. Click on the "(D)" field and select "status".

    

30. 30. Click on the "(E)" field, select "emails[]" and choose "email".

    

31. 31. Click on the "(F)" field, select "emails[]" and choose "certainty".

    

32. 32. Click on Save.

    

33. 33. Now click on "Run once" on the bottom left.

    

34. 34. Go back to your Google Sheet document, the result will be displayed.