How to Integrate the Company URL Finder feature into n8n
1. If you don’t have an existing Google Sheet, create a new one.
2. Copy the cells below, replacing the company names with the ones you want to find URLs for.
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. Click on "Choose" and select your Google Sheet document.
12. Click on "Choose" and select the Sheet you created.
13. Click on Execute step to test, the result should now appear in the output on the right as shown.
14. Go back to your workflow and click on "+" to add a new node.
15. Select "Action in an app" and choose HTTP Request.
16. Click on GET and select the POST Method.
17. In the URL field, paste the following:
https://app.icypeas.com/api/url-search/company
18. Click on "None" and select "Generic Credential Type".
19. Click on "Select" and choose "Header Auth".
20. Click on "Select Credential" and select "Create new credential".
21. In the Name field, type: "Authorization".
22. Go to Icypeas.com, sign up or log in, and navigate to the API tab.
23. Copy your API key.
24. Go back to the n8n tab and paste your API key into the Value field.
25. Click on Save and close the window.
26. Turn on the Send Body option.
27. In the Name field, type: "companyOrDomain".
28. Drag and drop the Company column element (from the left panel) into the Value field. It should display a reference to the email object as shown.
29. Click on Execute step, the result will be displayed on the right.
30. Go back to your workflow and click on "+" to add a new node.
31. Select "Action in an app" and choose Google Sheets.
32. Select Update row in sheet.
33. Click on "Choose" and select your Google Sheet document.
34. Click on Choose and select the Sheet you created.
35. Click on "Select" and choose "Company".
36. Drag and drop the Company element (from the left panel) into the Company field. It should display a reference to the email field as shown.
37. Do the same with the status column element—drag and drop it into the "Status" field.
38. Do the same with the result column element—drag and drop it into the "URL" field.
39. Go back to your workflow and click on Execute workflow.
40. Go back to your Google Sheet document. The results will now appear automatically.
