Clutch.co Scrape + Data Mining and verification

THIS CAN LEAD TO LONG-TERM WORK! I need 100,000 qualifying agencies scraped from Clutch.co with decision-maker contacts, delivered as a single Google Sheet. We start with a paid trial of 10,000 leads. If the trial passes QA, you're awarded the remaining 90,000, for $1,500 total across the full 100,000. The trial is real work and the first slice of the project, not throwaway. See the attached CSV for the exact format and match it row-for-row. ═══════════════════════════════ THE WORK ═══════════════════════════════ Scrape 100,000 qualifying agencies from Clutch.co. Required columns per agency: - Agency name - Agency website URL (the actual website, not the Clutch profile) - Clutch profile URL - Portfolio / case studies / testimonials page URL (found on the agency's own website) - Country (US, UK, CA, or AU) - Decision maker full name (Founder, CEO, Managing Director, or Head of Growth only) - Decision maker position / title - Decision maker verified email (Hunter.io, Apollo.io, or Snov.io) - Email verification tool used (Clay or similar, NOT Apollo) - Decision maker LinkedIn URL - Generic contact email (the info@/contact@/hello@ found on the agency's contact or about page, separate from the verified personal email above) - Source Clutch Category - Email Catch-All Status (TRUE/FALSE, returned by Hunter/Apollo/Snov in the same call) - Date of Most Recent Review - LinkedIn Company Page URL - Clutch Rating Hard criteria, non-negotiable: - English-speaking markets only: USA, UK, Canada, Australia - Listed on Clutch.co with at least 1 review (rating field is unreliable, a reviewCount of at least 1 is required) - Live, working website. "Live" = HTTP 200 on the root domain via httpstatus.io or curl. Parked domains, GoDaddy holding pages, Cloudflare errors, and "under construction" pages do NOT count as live - Agency size: 2-9 or 10-49 employees (Clutch's two smallest buckets). No solo freelancers, no 50+ - No duplicates on agency website OR Clutch profile URL - Decision-maker email must be a personal/named email, no role-based as the verified email - Generic contact email goes in its own column, leave blank if the agency doesn't publish one Pull evenly across these 4 Clutch categories (~20,000 each, or trial 2,500 each): -agencies/content-marketing -agencies/seo -agencies/digital-marketing -agencies/pay-per-click If a category runs out of qualifying agencies, tell me before padding from elsewhere. ═══════════════════════════════ TRIAL FIRST (10,000 LEADS) ═══════════════════════════════ Before the full 100,000, deliver a 10,000-lead trial: ~2,000 per category, same columns, same criteria, same format. This is paid ($150) and counts as the first slice of the 100,000. If the trial passes QA, you continue straight to the remaining 90,000. If it fails QA twice, the project ends. ═══════════════════════════════ DELIVERABLE FORMAT ═══════════════════════════════ - Match the attached CSV exactly, columns pre-defined and locked, do not rename/reorder/add columns - Empty fields = blank cell, never "N/A" or "-" - All URLs include https:// - Country values: only US, UK, CA, AU - Delivered as a single Google Sheet I share ═══════════════════════════════ PAYMENT ═══════════════════════════════ - Total: $1,500 for 100,000 leads ($0.015/lead) - Trial: $150 for the first 10,000, paid in full when the trial passes QA - Remaining 90,000: $1,350, paid in full when the full delivery passes QA - No partial payments within a batch. Submit only when complete and QA-ready If the trial fails QA, the remaining 90,000 is not awarded. ═══════════════════════════════ QA ACCEPTANCE ═══════════════════════════════ I spot-check 50 random rows on the trial and again on the full delivery. Thresholds: - At least 95% of agency websites return HTTP 200 - At least 95% of agencies are in the correct employee bucket (2-9 or 10-49) - At least 95% of agencies are in US/UK/CA/AU - At least 90% of decision-maker emails verify as "valid" or "accept-all" on Hunter/Apollo - Zero role-based emails in the verified-email column - Zero duplicates on agency website or Clutch profile URL Below thresholds = rework at no extra cost. Two failed reworks on a batch = that batch terminated with no payment. ═══════════════════════════════ HARD RULES ═══════════════════════════════ - AI-generated or pattern-guessed emails = entire batch rejected - Pasting raw scraper output without filtering = batch rejected - Do not contact me outside Upwork ═══════════════════════════════ TO APPLY ═══════════════════════════════ Start your application with the letter X, then answer: 1. What tools do you use to scrape Clutch and verify emails? 2. What's your QA process for catching parked domains and unverified emails before delivery? 3. Confirm the budget: $150 for the 10,000-lead trial, $1,350 for the remaining 90,000, $1,500 total for 100,000 leads, each paid in full only on QA approval.