How to Automatically Extract Company Website URLs from LinkedIn Profiles Using Company Names?

I need help with this table of mine. How do I get all company website URLs if I only have company name and person linkedin profiles. I have manually been looking at the company name, going to the persons linkeidn profile and then grabbing the company website URL and company linkedin URL from there. I want this to be set up automaticllay. How do I do it? app.clay.com/workspaces/…/…