Google Sheets - Get First Google Search Result URL into a Google Sheet

It's up to the freelancer to decide on the best approach. I am looking for the following I have a list of company names e.g. "IBM, Glaxosmith, Apple"... and I am looking for a Google Sheet script that will provide me with the domain name of each company in the list. Example >>> Assume the company name is Apple The script will then go to [login to view URL] and search for keyword Apple It will then find the first result of the search and fetch the page URL e.g. [login to view URL] (because the company's website usually pops up in the first search result) and then the URL will be prased into the domain name e.g. [login to view URL] I'd like to have next to the company name on the Google Sheet the domain name, [login to view URL] In your cover letter please advise on the best approach, and have you done something like this before I tried setting up google sheets and using XML retrieval function but Google is blocking it for some reason.