- Copy-paste the formula below
- Remove the spaces in the URL from step 1
- Replace {{company}} with the cell containing your company names
- Drag the formula down
Copy-paste this formula:
=IMPORTXML("https:// www. capterra. fr"&IMPORTXML("https:// www. capterra. fr/search/product?q="&{{company}},"/html/body/div[3]/div[2]/div/div/div/a[1]/@href",),"//*[@id='productHeaderInfo']/div[2]/div/a[1]/span[2]")
