Trustpilot Scraper PPE — Trustpilot, G2 & Customer Reviews

Extract real customer reviews across multiple pages, star ratings, dates of experience, negative churn pain-point categories & B2B competitor switching hooks across Sitejabber, PissedConsumer & review portals.

---

1. Architecture & Extraction Pipeline

• Extraction Mechanism: Direct structured extraction pipeline for Trustpilot Scraper PPE — Trustpilot, G2 & Customer Reviews with flat JSON output schema and deterministic Pay-Per-Event billing.
• Proxy Overhead: None required for standard runs. Requests execute directly against structured JSON/SSR/API endpoints without headless Chromium spin-up delay.
• Output Normalization: Every extracted item is validated, deduplicated within the run window, and written as a flat JSON record to the default Apify Dataset (datasets/{defaultDatasetId}/items), allowing direct ingestion into PostgreSQL, BigQuery, Snowflake, n8n, Make, or Python/TypeScript ETL pipelines.
• Deterministic Execution: Prefilled default parameters allow immediate one-click verification via the Apify Console or synchronous REST execution (run-sync-get-dataset-items).

---

2. Verified Production Dataset Sample

The following JSON record was captured directly from a live production execution of vivid_astronaut/trustpilot-g2-capterra-reviews-scraper on Apify Cloud:

[
  {
    "domain": "stripe.com",
    "sourcePlatform": "Trustpilot",
    "sourcePage": 1,
    "sourceUrl": "https://www.trustpilot.com/reviews/6ae29e77bc7ab608fc6d7cdb",
    "companyOverallRating": 1.6,
    "reviewTitle": "i am 100% sure they will still ignore…",
    "dateOfExperience": "October 28, 2026",
    "reviewText": "i am 100% sure they will still ignore… — i am 100% sure they will still ignore this even after i have emailed them multiple times without any success they pretend not to understand. Dear Stripe Specialist Team, I am writing to request a final review and disposition of the remaining balance on my closed account, following my conversation with standard support.",
    "sentiment": "NEUTRAL",
    "painCategories": [
      "Customer Support Delay",
      "Account Termination / Compliance Lock"
    ],
    "b2bOutreachHook": "Competitor user reported Customer Support Delay & Account Termination / Compliance Lock — high-intent switching candidate.",
    "scrapedAt": "2026-10-29T07:48:36.598Z"
  },
  {
    "domain": "stripe.com",
    "sourcePlatform": "Trustpilot",
    "sourcePage": 1,
    "sourceUrl": "https://www.trustpilot.com/reviews/6ae24249ff68c0995eb0b75e",
    "companyOverallRating": 1.6,
    "reviewTitle": "A Truly Painful and Stressful Experience with Stripe",
    "dateOfExperience": "October 28, 2026",
    "reviewText": "A Truly Painful and Stressful Experience with Stripe — Stripe closed my account despite my submitting the requested documentation to verify my business and transactions. Throughout my time using the service, I have had no chargebacks, disputes, or refunds. My appeal was rejected, and Stripe has informed me that my remaining funds will be held until February 2027. This prolonged restriction is placing unnecessary financial pressure on my business and raises serious concerns about the fairness, transparency, and proportionality of the decision. I understand that payment providers must manage risk and comply with their obligations. However, customers who provide supporting documentation deserve a clear explanation, a meaningful review, and timely access to funds where continued withholding is not justified.",
    "sentiment": "NEUTRAL",
    "painCategories": [
      "Customer Support Delay",
      "Billing / Funds Hold / Pricing Friction",
      "Account Termination / Compliance Lock"
    ],
    "b2bOutreachHook": "Competitor user reported Customer Support Delay & Billing / Funds Hold / Pricing Friction & Account Termination / Compliance Lock — high-intent switching candidate.",
    "scrapedAt": "2026-10-29T07:48:36.598Z"
  }
]

---

3. Input Parameter Specification

Parameter	Type	Default	Technical Specification
domains	array	["stripe.com", "shopify.com", "notion.so", "hubspot.com"]	Enter Company Domains to Extract Customer Reviews For to scrape structured records.
maxPages	integer	3	Number of pagination pages to crawl per query (1 to 10).
maxItems	integer	60	Maximum total records to extract across all queries (up to 500 per run).

Example Input Payload (application/json)

{
  "domains": [
    "stripe.com",
    "shopify.com",
    "notion.so",
    "hubspot.com"
  ],
  "maxPages": 3,
  "maxItems": 60
}

---

4. Measured Runtime & Unit Economics

Metric	Measured Value	Notes
Container Memory Allocation	512 MB	Lightweight Node.js 20 container (apify@^3.2.6)
Median Execution Latency	2.54 s	Cold start to dataset commit for default batch
External Proxy Requirement	$0.00	No residential proxy bandwidth surcharge required
Primary Billing Event	domain-blacklist-audited	Charged strictly per committed dataset record
Unit Price (Pay-Per-Event)	$0.0050 / record	Equivalent to $5.00 per 1,000 records

---

5. Production Integration (cURL, Python, Claude Code MCP)

5.1 Synchronous REST Execution (cURL)

Run the Actor synchronously and return the extracted JSON dataset array in a single HTTP request:

curl -s -X POST \
  "https://api.apify.com/v2/acts/vivid_astronaut~trustpilot-g2-capterra-reviews-scraper/run-sync-get-dataset-items?token=YOUR_APIFY_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"domains": ["stripe.com", "shopify.com", "notion.so", "hubspot.com"], "maxPages": 3, "maxItems": 60}'

5.2 Python Pipeline Integration (urllib.request)

import json
import os
import urllib.request

APIFY_TOKEN = os.environ["APIFY_TOKEN"]
url = (
    "https://api.apify.com/v2/acts/vivid_astronaut~trustpilot-g2-capterra-reviews-scraper/"
    f"run-sync-get-dataset-items?token={APIFY_TOKEN}"
)
payload = {
  "domains": [
    "stripe.com",
    "shopify.com",
    "notion.so",
    "hubspot.com"
  ],
  "maxPages": 3,
  "maxItems": 60
}

req = urllib.request.Request(
    url,
    data=json.dumps(payload).encode("utf-8"),
    headers={"Content-Type": "application/json"},
    method="POST",
)
with urllib.request.urlopen(req, timeout=120) as resp:
    records = json.loads(resp.read().decode("utf-8"))
    print(f"Extracted {len(records)} records from trustpilot-g2-capterra-reviews-scraper")

5.3 Claude Code / Cursor MCP Configuration (.mcp.json)

Expose vivid_astronaut/trustpilot-g2-capterra-reviews-scraper as a callable tool inside Claude Code, Cursor, or any Model Context Protocol client:

{
  "mcpServers": {
    "apify-trustpilot-g2-capterra-reviews-scraper": {
      "command": "npx",
      "args": [
        "-y",
        "@apify/actors-mcp-server",
        "--actors",
        "vivid_astronaut/trustpilot-g2-capterra-reviews-scraper"
      ],
      "env": {
        "APIFY_TOKEN": "YOUR_APIFY_TOKEN"
      }
    }
  }
}