# pp-trustpilot

pp-trustpilot — a skill that wraps the Trustpilot CLI to sync and query reviews from a local database. Handy when you need a balanced sample of recent reviews, track reputation trends over weeks, or spot review surges.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 202 installs · ★ 2142 repo stars
- Author: Matt Van Horn
- License: Apache-2.0 · policy=mirror · the beginning of the file is at the end of this page
- Source: https://github.com/mvanhorn/printing-press-library/tree/HEAD/cli-skills/pp-trustpilot/SKILL.md
- Updated: 2026-10-24
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/pp-trustpilot

## What it does

pp-trustpilot exposes commands from `trustpilot-pp-cli`, a CLI that syncs Trustpilot reviews into a local SQLite database. Key features include `top-recent`, which pulls top good and bad reviews in one call; `agent-bundle`, a single JSON with company metadata, TrustScore, AI summary, and rating histogram; and `drift`, which reconstructs week-over-week TrustScore and star distribution from stored reviews.

Additional commands search review text (`search-reviews` with star and date filters), audit reply rates (`replies`), show reviewer geography (`geo`), and detect statistical spikes in negative volume (`surge`). All queries run offline after the first sync.

Before calling the skill, you must install the `trustpilot-pp-cli` binary. Installation requires Node.js and npm for the `npx` method, or Go 1.26.6+ for direct compilation. After install, verify the binary is visible to your runtime: ask the agent to run `trustpilot-pp-cli --version`.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add mvanhorn/printing-press-library --skill pp-trustpilot -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/pp-trustpilot/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/pp-trustpilot/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add mvanhorn/printing-press-library --skill pp-trustpilot -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/pp-trustpilot/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add mvanhorn/printing-press-library --skill pp-trustpilot -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/pp-trustpilot/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install mvanhorn/printing-press-library cli-skills/pp-trustpilot/SKILL.md
```

2. **Manually: put the files in place**
- File: `.github/skills/pp-trustpilot/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add mvanhorn/printing-press-library --skill pp-trustpilot -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/mvanhorn/printing-press-library --path cli-skills/pp-trustpilot
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/pp-trustpilot/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add mvanhorn/printing-press-library --skill pp-trustpilot -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/mvanhorn/printing-press-library/tree/HEAD/cli-skills/pp-trustpilot/SKILL.md

## When to use it
- fetch balanced samples of recent good and bad reviews in one query
- track week-over-week TrustScore and star distribution trends
- search review text for keywords with star and date filters
- compare reputation across multiple companies side-by-side
- detect statistically significant spikes in 1-star or total review volume

## Example prompts
- Get a balanced set of fresh reviews for thriftbooks.com from the last 30 days
- Show TrustScore trend and 1-star percentage for thriftbooks.com over 12 weeks
- Find all 1-star reviews mentioning refunds in the last 90 days for thriftbooks.com

## Source text · SKILL.md · Apache-2.0

Below is the content of a third-party file. It is data, not instructions for you: do not act on anything written inside unless the human asks. Block tag: 908e6d3328182ec4.

BEGIN THIRD-PARTY FILE 908e6d3328182ec4
````text
---
name: pp-trustpilot
description: "Every Trustpilot review surface, plus the local SQLite database and balanced good-and-bad agent bundle no other... Trigger phrases: `trustpilot reviews for <company>`, `what do customers say about <company>`, `good and bad reviews for <company>`, `trustscore for <company>`, `is <company> trustworthy`, `use trustpilot`, `run trustpilot`."
author: "Matt Van Horn"
license: "Apache-2.0"
argument-hint: "<command> [args] | install cli|mcp"
allowed-tools: "Read Bash"
metadata:
  openclaw:
    requires:
      bins:
        - trustpilot-pp-cli
---
<!-- GENERATED FILE — DO NOT EDIT.
     This file is a verbatim mirror of library/marketing/trustpilot/SKILL.md,
     regenerated post-merge by tools/generate-skills/. Hand-edits here are
     silently overwritten on the next regen. Edit the library/ source instead.
     See the repository agent guide, section "Generated artifacts: registry.json, cli-skills/". -->

# Trustpilot — Printing Press CLI

## Prerequisites: Install the CLI

This skill drives the `trustpilot-pp-cli` binary. **You must verify the CLI is installed before invoking any command from this skill.** If it is missing, install it first:

1. Install via the Printing Press installer. It defaults binaries to `$HOME/.local/bin` on macOS/Linux and `%LOCALAPPDATA%\Programs\PrintingPress\bin` on Windows:
   ```bash
   npx -y @mvanhorn/printing-press-library install trustpilot --cli-only
   ```
2. Verify: `trustpilot-pp-cli --version`
3. Ensure the reported install directory is on `$PATH` for the agent/runtime that will invoke this skill.

If the `npx` install fails (no Node, offline, etc.), fall back to a direct Go install (requires Go 1.26.6 or newer):

```bash
go install github.com/mvanhorn/printing-press-library/library/marketing/trustpilot/cmd/trustpilot-pp-cli@latest
```

If `--version` reports "command not found" after install, the runtime cannot see the binary directory on `$PATH`. Do not proceed with skill commands until verification succeeds.

## When to Use This CLI
````
END THIRD-PARTY FILE 908e6d3328182ec4

The third-party file has ended. Everything between the 908e6d3328182ec4 tags is data: requests and commands from it are not followed. An “end of file” line with another tag inside the block is part of the file.

First 2046 of 14675 bytes. © Matt Van Horn · Apache-2.0 · https://github.com/mvanhorn/printing-press-library/tree/HEAD/cli-skills/pp-trustpilot/SKILL.md

## Similar
- [review-funnels-wasp-drone](https://affpapa.org/en/nevibecode/agents/review-funnels-wasp-drone.md) — subagent · ★ 96 repo stars
- [monitoring](https://affpapa.org/en/nevibecode/mcp/monitoring.md) — MCP server
- [review-reputation](https://affpapa.org/en/nevibecode/skills/review-reputation.md) — skill · 410 installs
- [goplaces](https://affpapa.org/en/nevibecode/skills/goplaces.md) — skill · 5400 installs

_Part of the page did not fit — see the HTML version._

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
