Doc 18 of 20RUNBOOK · SCRAPINGSearch IOComplete

Execution Prompts · Apify

Sixteen ready-to-run prompts: pre-flight check, eleven Google Maps scrapes by medical category, four LinkedIn searches, one website crawl, master list consolidation.

AD
Andrew Danner
Listing Broker · Windfield Real Estate
Generated 2026-04-299 min read
ready prompts
16
1 pre-flight + 11 Maps + 4 LinkedIn + 1 crawl
phases
4
discovery → decision-makers → enrichment → consolidation
est. results
445–780
before deduplication
est. cost
≈$5.50
across the full sweep

§ 01Pre-flight check

Pre-flight prompt \u00B7 verify Apify connection and actor availabilityprompt
Check Apify MCP connection status. List all available actors related to
Google Maps scraping and LinkedIn profile scraping. Confirm the following
actors are available:

  - lukaskrivka/google-maps-with-contact-details
  - compass/crawler-google-places
  - harvestapi/linkedin-profile-search
  - dev_fusion/Linkedin-Profile-Scraper
  - apify/website-content-crawler

Report the actor IDs and current credit balance.

§ 02Phase 1 \u00B7 Google Maps (11 prompts)

Phase 1 \u00B7 Google Maps medical discovery11 prompts \u00B7 run in parallel \u00B7 \u2248$0.85 total
PromptCategoryPer-search capPriority
1AChiropractic Practices30High
1BOptometry & Eye Care25High
1CMed Spa & Aesthetic Medicine30HIGHEST
1DPhysical Therapy & Rehabilitation30Medium-High
1EUrgent Care & Walk-In Clinics25HIGHEST
1FDental & Orthodontic30High
1GBehavioral Health & Counseling25HIGHEST
1HSpecialty Medical (Derm/Pod/ENT/Allergy)25High
1IMedical Labs · Imaging · Pharmacy25Medium-High
1JMedical Staffing · Home Health25Medium
1KComprehensive Catch-All Medical30Medium
Sample \u00B7 Prompt 1C (Med Spa, HIGHEST priority)prompt
Run the Apify actor "lukaskrivka/google-maps-with-contact-details" with:

{
  "searchStringsArray": [
    "med spa near Kansas City MO 64154",
    "medical spa Kansas City Northland",
    "Botox clinic near Kansas City MO",
    "laser hair removal Kansas City MO",
    "CoolSculpting near Kansas City MO",
    "aesthetic clinic Kansas City MO",
    "skin care clinic near Platte County MO",
    "medspa near Overland Park KS"
  ],
  "maxCrawledPlacesPerSearch": 30,
  "scrapeEmails": true,
  "scrapeSocials": true,
  "proxyConfiguration": { "useApifyProxy": true, "apifyProxyGroups": ["SHADER"] }
}

Filter results within 15 miles of 39.2511104, -94.6316167.

# Score using the standard medical qualification matrix
# Output: markdown table → /scrape_results/03_med_spa.md
Standard scoring matrix (applied in every Phase 1 prompt)
Google Rating \u22654.0 = +15 \u00B7 Reviews \u226550 = +15 \u00B7 Reviews \u2265200 = +10 bonus \u00B7 Within 5 mi = +15 \u00B7 Within 2 mi = +5 bonus \u00B7 Has website = +10 \u00B7 Medical category match = +20 \u00B7 Has email or owner = +5 \u00B7 Multiple locations = +10. Tiers: A 80\u2013100 \u00B7 B 60\u201379 \u00B7 C 40\u201359 \u00B7 D 20\u201339.

§ 03Phase 2 \u00B7 LinkedIn (4 prompts)

Phase 2 \u00B7 LinkedIn decision-maker search4 prompts \u00B7 run in parallel \u00B7 \u2248$2.40 total
PromptAudienceActorOutput
2AMedical Practice Owners — KC Metroharvestapi/linkedin-profile-search/scrape_results/13_medical_practice_owners.md
2BMed Spa & Aesthetic Operatorsharvestapi/linkedin-profile-search/scrape_results/14_medspa_operators.md
2CUrgent Care & Franchise Developmentharvestapi/linkedin-profile-search/scrape_results/15_urgent_care_franchise.md
2DHealthcare Real Estate Investorsharvestapi/linkedin-profile-search/scrape_results/16_healthcare_re_investors.md
Sample \u00B7 Prompt 2A (Medical Practice Owners \u2014 KC Metro)prompt
Run harvestapi/linkedin-profile-search with:

{
  "keywords": "practice owner OR medical director OR managing partner",
  "locations": ["Kansas City Metropolitan Area"],
  "industries": ["Hospital & Health Care", "Medical Practice"],
  "seniority": ["Owner", "Partner", "CXO", "Director"],
  "maxResults": 100
}

For each profile, extract: name, current title, current company,
company domain (if visible), location, profile URL.

Output: markdown table → /scrape_results/13_medical_practice_owners.md

§ 04Phase 3 \u00B7 Website enrichment crawl

Prompt 3A \u00B7 top-20 medical practice websitesprompt
After Phase 1 completes, take the top-20 highest-scoring practice domains.
Run apify/website-content-crawler with:

{
  "startUrls": [{{TOP_20_DOMAINS}}],
  "maxCrawlDepth": 2,
  "includeUrlGlobs": [
    "**/about**", "**/team**",
    "**/providers**", "**/contact**",
    "**/locations**"
  ]
}

For each domain, extract: staff names, titles, emails, location count.
Join to the Phase 1 business records by domain.

Output: /scrape_results/17_website_enrichment.md

§ 05Phase 4 \u00B7 Master prospect list builder

Prompt 4A \u00B7 master list consolidationprompt
After all 16 prompts above complete, consolidate every result into the
master medical prospect list.

# Steps
1. Read every file in /scrape_results/ (01–17)
2. Deduplicate by domain (case-insensitive)
3. Deduplicate by phone number (E.164 normalization)
4. Re-score using the standard scoring matrix
5. Apply tier (A / B / C / D)
6. Sort by score descending

# Outputs
  - /MASTER_MEDICAL_PROSPECT_LIST.md  (markdown)
  - /MASTER_MEDICAL_PROSPECT_LIST.csv  (csv for Clay)

# Final summary report
  - Total unique businesses
  - Total by category
  - Total by tier
  - Total with email
  - Total with website
  - Top-25 hottest prospects with full detail
Hand-off to Clay
The CSV from Phase 4 is the input to the Clay enrichment runbook (Doc 19). Both files ship to /Users/virgil/Desktop/8630 N Green Hills Rd-MASTER-PROPERTY-PROFILE/.