Google Maps Leads Cleaner — dedupe, format phones, CRM-ready

For sales teams, agencies and lead-gen freelancers who scrape Google Maps. You now have duplicates across runs, phone numbers in five formats, closed businesses and nested fields that your CRM won't import. This Actor turns the output of any Google Maps scraper into a clean, flat lead list in one run — no scraping, no proxies. $0.50 per 1,000 leads written.

• Merge & dedupe several runs (by place ID, then name + address, then name + phone)
• Phones in E.164 (+14155550132), validated — invalid numbers are flagged, not guessed
• Website domain extracted (example.com) for enrichment and email-finder tools
• Opening hours flattened to one readable column
• Filters: drop closed places, keep only leads with a website / valid phone, minimum rating and reviews, include or exclude categories
• Flat columns that import straight into HubSpot, Salesforce, Pipedrive, Google Sheets or CSV
• Reading, duplicates and filtered-out rows are free.

Works with the output of popular Google Maps scrapers (e.g. compass/crawler-google-places) and other tools that use similar field names (title/name, phone, website, address, placeId, totalScore, reviewsCount).

Use cases

• Prepare a cold-outreach list: only open places with a website and a valid phone
• Merge several city or category scrapes into one deduplicated list
• Export a CRM import file (HubSpot, Salesforce, Pipedrive) or Google Sheets from raw scraper output

Input

{
  "datasetIds": ["<dataset ID of your Google Maps scraper run>"],
  "requireWebsite": true,
  "minRating": 4.0,
  "categoriesInclude": ["dentist"]
}

Leave datasetIds empty to see a free demo on sample data.

Output (one row per lead)

{
  "name": "Sample Dental Clinic", "category": "Dentist", "categories": ["Dentist"],
  "phone": "+442079460018", "phoneRaw": "020 7946 0018", "website": "example.org", "domain": "example.org",
  "address": null, "street": null, "city": "London", "postalCode": null, "state": null, "countryCode": "GB",
  "lat": null, "lng": null, "rating": 4.9, "reviewsCount": 57, "openingHours": "Monday: 9 AM–5 PM; …",
  "isClosed": false, "placeId": "…", "mapsUrl": "https://www.google.com/maps/…"
}

Run statistics (itemsRead, duplicates, filteredOut, written, skippedInvalid) are saved in the key-value store as STATS.

Notes

This Actor only processes datasets you already own; it does not access Google Maps. You are responsible for how the underlying data was collected and used.

More tools from the same developer

• Google Maps Reviews Analyzer — per-place ratings, trends, owner response rate and top terms from Google Maps reviews
• Google Maps Market Analyzer — market and competitor tables from Google Maps scraper datasets
• Google Sheets Export — export an Apify dataset to Google Sheets
• Dataset Merge & Dedup — merge Apify datasets and remove duplicates by the fields you choose