How to Integrate the Profile URL Finder feature into Make
1. If you don’t have an existing Google Sheet, create a new one.
2. Copy the cells below, replacing the information with the ones you want to use.
Note: This feature can find someone's URL using a first name, last name, and either a company name/domain, a job title, or both.
The three valid input combinations are demonstrated below.
3. Go to Make and click on Create a new scenario.
4. Select Google Sheets.
5. Choose Search Rows (Advanced).
6. Click on Add and connect to your Google account.
7. Click on "Click here to choose file" and select your Google Sheet document.
8. Clicl on "Sheet ID" and select the Sheet you created.
9. In the Query field, type: "select B, C, D, E".
10. Click on Save.
11. Click on Add another module.
12. Select "Icypeas" then choose "Profile URL Search".
13. Click on Add.
14. Go to Icypeas.com, sign up or log in, and navigate to the API tab.
15. Copy your API key and your User id.
16. Go back to the Make tab and paste your API key and your User id.
17. Click on Save.
18. Click on the "First Name" field and select "(B)".
19. Click on the "Last Name" field and select "(C)".
20. Click on the "Company Name or Domain" field and select "(D)".
21. Click on the "Job Title" field and select "(E)".
22. Click on Save.
23. Click on Run once.
24. Click on Add another module.
25. Select Google Sheets.
26. Choose Update a Row.
27. Click on "Click here to choose file" and select your Google Sheet document.
28. Select the Sheet you created.
29. Click on the "Row number" field and select "Bundle order position".
30. Click on the "(F)" field and select "status".
31. Click on the "(G)" field and choose "result".
32. Click on Save.
33. Now click on "Run once" on the bottom left.
34. Go back to your Google Sheet document, the result will be displayed.
