Problem: I needed to find Company URLs from company names to sync contacts to companies in HubSpot.

Solution:

1. Use, “https://autocomplete.clearbit.com/v1/companies/suggest?query=” along with the company name to fetch data on the company
2. Create this function in Google Sheet scripts:

   function FETCH(url) {
   var response = UrlFetchApp.fetch(url);
   Logger.log(response.getContentText());
   var out = JSON.parse(response.getContentText());
   return out[0][“domain”];
   }

3. Run the function using: fetch(Field of URL)