Scrape G2 and Capterra Reviews for Competitor Leads
The problem
People leaving negative reviews on competitor G2 pages are in-market buyers, but finding them manually is slow.
Implementation steps
- 1
Use Claygent to scrape recent 1-3 star reviews from competitor G2 pages
- 2
Extract reviewer name and company from review byline
- 3
Use Apollo to find reviewer email address
- 4
Categorize pain points mentioned in review using OpenAI
- 5
Add to HubSpot list and trigger personalized outreach sequence referencing their review pain point
Template outline
The structure to recreate in your own workspace. Field names and thresholds are starting points.
Clay Workflow:
1. Claygent: Scrape competitor G2 page (URL: g2.com/products/{{competitor}}/reviews)
2. Extract: Reviewer name, company, rating, review text
3. Filter: Rating <= 3 stars
4. Apollo: Find work email by name + company
5. OpenAI: Summarize pain point from review
6. HubSpot: Add to list "Competitor Switchers {{month}}"
7. Enroll in sequence with email mentioning their specific pain pointKeep going
More Outbound playbooks
- OutboundAdvanced
Auto-Prospect Companies After Funding Announcements
Sales teams miss narrow timing windows when companies raise capital and need new vendors.
ClayClaygentApollo+1Estimate: 8 hrs/week - OutboundIntermediate
Personalize Outbound at Scale Using LinkedIn Data
Generic cold emails get few replies, and reps cannot manually research every prospect on a high-volume list.
ClayClaygentInstantlyEstimate: 10 hrs/week - OutboundBeginner
Track Warm Intro Requests Across Your Network
AEs lose track of warm intro requests sent via email and LinkedIn. Follow-ups fall through the cracks.
Google SheetsZapierGmailEstimate: 3 hrs/week
Need help implementing a playbook?
Our team builds custom Clay workflows and AI automations for revenue teams.
Get it built for you