# Trustpilot Sentiment Tracker

> Automatically pull Trustpilot reviews, score sentiment, log everything to a spreadsheet, and alert your team on Slack.

Source: https://cotera.co/solutions/marketing/trustpilot-sentiment-tracker

---

- **Team:** Marketing
- **Tools:** Trustpilot
- **Difficulty:** medium
- **Setup time:** 10 min
- **Time saved:** 1-2 hrs/week

## How it works
1. **Pull Reviews** — Get recent Trustpilot reviews with ratings and text
2. **Score Sentiment** — Classify each review and extract recurring complaint themes
3. **Log to Sheets** — Append structured data for every review to Google Sheets
4. **Alert on Slack** — Post a sentiment summary and flag negative spikes

## Example requests
- Track sentiment for shopify.com and post weekly to #brand-health
- Pull this week's Trustpilot reviews for our domain and log to my tracking sheet
- Are our Trustpilot reviews getting worse? Check the last 3 pages and alert #cs-team if so

## Prompt

```markdown
## Task

Use @Trustpilot/Get Reviews to pull recent reviews for a domain. Classify each review by sentiment (positive/neutral/negative) and extract recurring themes. Log every review to @Google Sheets/Append Row with structured data. Send a summary to @Slack/Send Message with alerts if negative sentiment exceeds thresholds.

## Input

The user provides their domain, a Google Sheet for logging, and a Slack channel.

**Example:** "Track sentiment for shopify.com and post weekly to #brand-health"

## Context

### What to Track

- Sentiment score per review and overall trends
- Theme extraction (what people praise and complain about)
- Alert triggers when negative sentiment exceeds 30%

## Output

**Slack Summary:**
- Average rating, sentiment breakdown, trending complaints
- Alert banner if negative sentiment is high

**Google Sheets:** Each review logged with Date, Reviewer, Rating, Sentiment, Themes, Review Text
```

## Related reading
- [Automated SEO Competitor Monitoring](https://cotera.co/articles/automated-seo-competitor-monitoring.md)
- [Best Free SEO Competitor Tools](https://cotera.co/articles/best-free-seo-competitor-tools.md)
- [Competitor SEO Tracking Guide](https://cotera.co/articles/competitor-seo-tracking-guide.md)