Export Sextant France mandataire agents from the public map. Phones, city, GPS location and social profiles (LinkedIn etc.) when present — one row per agent (~95). No login.
Fix: Sextant site redesign returned 0 agents. Now reads the new directory (embedded JSON), ~110 agents with phone + GPS.
Emails are no longer published by Sextant (contact form only); email is usually empty. listingsCount / listingValueTotal are now null.
Minisite social links: retries, failed minisites keep the row.
1.8 - 2026-10-11
Free plan: max 20 advisors exported per run (enforced before push).
1.7 - 2026-10-11
Fix: each exported advisor is now billed with its pay-per-event (advisor / with-phone / with-email / with-whatsapp); stops when the user's max budget is reached.
Changelog
All notable changes to this project will be documented in this file.
listingsCount, listingValueTotal — From agent liste page (urlListe): nombre de biens + somme des prix affichés (€).
[1.4] - 2026-03-10
Added
LinkedIn column included by default — linkedinUrl filled for agents missing it. No input needed. Creator configures API keys via actor.json + apify secrets (OPENAI_API_KEY, AUTOM_DEV_API_KEY). Output: linkedInCorrelationScore (0-100).
Changed
README Also available: retired eXp / Espaces Atypiques Store listings removed — use the French Real Estate Agents hub.
Input simplified — LinkedIn options removed from UI. Only "Agent URLs (optional)" remains.
Logs cleaned — Shorter messages, debug output removed. Social progress every 20 agents; LinkedIn progress format: [done/total] pct% · ETA.
LinkedIn validation — Reject matches when URL slug doesn't contain agent's name (avoids philippe-calvez for Frédérique Calves, florence-malvault for Florent Cifci).
Min score 50 — Kept; slug validation handles false positives.
Input simplified — Mode selector removed. Empty startUrls = full list; with URLs = enrich those only
Social links — Only agent-specific profiles (excludes Sextant brand: sextantproperties, SextantFrance, etc.)
[1.2] - 2026-03-09
Added
phonePro, phonePerso — French heuristic: 01-05 = pro (landline), 06-07 = perso (mobile)
name in proper case — "MALVAULT Florence" → "Malvault Florence", "COLIN D'HIVER" → "Colin d'Hiver"
instagramUrl, facebookUrl, linkedinUrl — Scraped from agent detail pages
Detail page scraping re-enabled for social links extraction only
[1.1] - 2026-03-09
Removed
Detail pages scraping — was not enriching data, caused ENOTFOUND on invalid URLs (e.g. https://.sextantfrance.fr), and wasted ~50 extra requests. All data comes from agents-map.
[1.0.0] - 2026-03-09
Added
Initial release
Map mode: scrape full agents list from agents-map.htm (~95 agents)
URLs mode: enrich from custom agent page URLs
Extracted fields: lastName, firstName, name, phone, email, address, city, postalCode, lat, lng, urls, photoUrl, agency
Windows-1252 decoding for correct accents (Chloé, Déborah, etc.)
