Weekly competitor reputation brief from Trustpilot reviews

Every Monday at 8am, build me a competitive reputation brief covering my own company and a short list of competitor domains, log the numbers to a spreadsheet, and post a digest to Slack.

Keep the list of domains at the top of the workflow as an easily edited input so I can add or remove a competitor without touching the rest of the logic. Put my own domain first, then the competitors, for example: mycompany.com, competitor-one.com, competitor-two.com.

For each domain in that list, use the Trustpilot Find Business Unit operation to resolve the domain to its businessUnitId. If Find Business Unit returns no match, fall back to Search Business Units to fuzzy match on the company name or domain. If neither resolves, skip that company and note it in the digest so I know the list needs attention.

With the businessUnitId, call Get Business Unit to read the current TrustScore, the star rating, the star distribution from one through five stars, and the total number of reviews. Then call Get Business Unit Reviews to pull that company's most recent reviews, roughly the latest 20 to 25 or everything posted since last Monday, whichever is smaller. These are all public Trustpilot endpoints, so this works for competitors without their involvement and without a paid Trustpilot plan.

Before writing anything new, use Google Sheets Get Values to read the existing rows in the tracking tab so you can compare this week's TrustScore against the last value recorded for each company. That comparison is what tells you who moved and by how much.

Then use Google Sheets Append Values to append one row per company per week to the tracking tab. Each row should carry the run date, company name, domain, TrustScore, star rating, total review count, and the counts of one star through five star reviews. Appending rather than overwriting is the whole point: over the weeks the tab becomes a TrustScore trend line nobody has to maintain by hand. If the tab is empty on the first run, write a header row first.

Finally, post the digest to Slack with Send a Message. Keep it short and skimmable: a ranked table of every company by TrustScore showing review count and the change since last week, one line calling out who moved most and in which direction, and two or three bullets naming the complaint themes that recur across the competitor reviews, each with a short note on how we could position against it. Read the actual review text to find those themes rather than restating the numbers back to me.

In the first week there is no prior data, so say that plainly instead of inventing movement. Keep the whole Slack message to roughly fifteen lines: a ranked table plus three bullets, not a wall of text.