Export Trustpilot Reviews to Google Sheets, Find Churn Fast

=TRUSTPILOT("yourdomain.com", {1,2}, "last3months", 200) exports your recent 1 and 2 star Trustpilot reviews into Google Sheets as rows with the rating, title, review text, reviewer country, verified flag and your TrustScore. You see the complaint that is costing you customers in one sorted table instead of scrolling Trustpilot and copying reviews by hand.

Take a SaaS support lead who copies about 200 complaint reviews a quarter into a spreadsheet to find patterns. At roughly 30 seconds per review, that is about 100 minutes of copying before any analysis starts. One formula replaces the copying.

How do I export Trustpilot reviews to Google Sheets?

Type the formula into any empty cell:

=TRUSTPILOT(companyUrls, starRatings, dateRange, maxResults)

• companyUrls: a bare domain like "monday.com" or a full Trustpilot review URL like "https://www.trustpilot.com/review/www.amazon.com". A range of companies works too.
• starRatings: optional star ratings to keep, as whole numbers 1 to 5, like {1,2} for complaints or 5 for praise. Leave it empty for every rating.
• dateRange: optional, how far back to look.
• maxResults: optional number of reviews. The default is 50.

The cell shows ⏳ Scraping... first. When the run finishes, SheetMagic writes the reviews to a new tab called Trustpilot Reviews Results.

Can I pull only 1 and 2 star reviews, or only the last 30 days?

Yes. starRatings keeps only the ratings you list, so {1,2} returns complaints only and {5} returns praise only. A rating that is not a whole number from 1 to 5 stops the run with an error, so you never pay for every rating when you asked for one.

dateRange takes one of these exact values:

• "all"
• "last30days"
• "last3months"
• "last6months"
• "last12months"

What columns come back?

Each review row has Company, Rating, Review Title, Review, Reviewer, Reviewer Country, Reviewer Review Count, Published, Experienced, Verified, Verification Level, Likes, Language and Source, plus company columns: Company TrustScore, Company Total Reviews, Company Website, Company Trustpilot URL, Review URL and Review ID. Later columns add Updated, Company Stars, Company 1-Star Count, Company 5-Star Count, Company Categories and Company Claimed. Review text is cut at 1,000 characters.

Because the TrustScore and total review count sit on every row, one export answers both "what are people saying" and "how well rated is this company".

Example output (illustrative rows, not real data):

What can I do with the results?

1. Fix the complaint that costs you the most customers. In a new column of the results tab, enter =AITEXT("Name the main complaint in 3 words", E2) and drag it down, then count the answers. Column A of the results tab is Source, so the Review text sits in column E. Fix the top theme first. See AI in Google Sheets for more prompts like this.
2. Benchmark before a pricing or positioning change. Put your domain and three competitors in a range and compare Company TrustScore and the Company 1-Star Count column side by side. If a competitor's 1-star reviews all say "too expensive", that is a gap you can price into.
3. Give support a reply queue. Filter Verified to TRUE and Rating to 1, then work down the Review URL column. Every complaint answered is a customer less likely to leave quietly.
4. Collect praise for landing pages. Run {5} with "last3months" to find fresh, specific quotes.

Scenario math: in this example, 200 reviews at 30 seconds each is about 100 minutes by hand. One formula is about a minute of typing and 563 scraping credits (see the cost section).

How do I scale to several companies?

Pass a range of domains: =TRUSTPILOT(A2:A5, {1,2}, "last3months", 200). maxResults is split across the companies, so 50 reviews over 2 companies is about 25 each. For a fixed count per company, put one company per row and give each its own formula. SheetMagic also drops any reviews that come back for a company you did not name.

How much does it cost?

A Trustpilot run costs 163 scraping credits to start plus 2 credits for each review delivered.

The start fee is paid once per run, so one formula with four companies and 200 reviews costs 563 credits, while four separate formulas of 50 cost 1,052. If nothing is found, the cell says so and you are not charged.

Paid plans include 10,000 scraping credits a month on Solo, 45,000 on Growth and 115,000 on Scale. The Free plan includes 100 scraping credits.

What are the common pitfalls?

• No reviewer-country or language filter. Pull the reviews, then filter the Reviewer Country or Language column in the sheet.
• Results land later. The cell shows a loading indicator first. Do not nest TRUSTPILOT inside AITEXT; put AITEXT in its own column and point it at the Review cells in the results tab.
• Short balance means a shorter run. If your credits cannot cover the run, SheetMagic shrinks it to fit and adds a row that says it was limited, so a short table is never mistaken for "that is all there is".
• Use exact dateRange values. "last3months", not "3 months".

For more review and data scrapers, see the web scraping guide and data analysis. For local businesses, the sibling guide export Google Maps reviews works the same way.