1. Copy-paste the formula below
2. Remove the spaces in the URL from step 1
3. Replace {domain} with the cell containing your domain names
   
4. Drag the formula down

‍

Copy-paste this formula:

=IMPORTXML(CONCAT("https: //www. trustpilot. com/review/",{domain}),"//*[@id='business-unit-title']/div/div/p")

‍

🎁 Bonus: use the formula below to display it in a nice format

 =REPT("⭐️",ROUND({rating}))