← All Apps Scripts templates
Extract Trustpilot Ratings

Extract Trustpilot Ratings

  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


Reach us if the process is unclear or if the script is outdated
Apps Scripts template

Extract Trustpilot Ratings

Last updated
Built by
Avatar Placeholder

Similar Apps Script for


in Google Sheets

No similar items yet.