The situation
A scheduled Apify scrape for construction prospects, with wait/poll logic, dedupe against the existing CRM sheet, and append-only writes for new leads.
All case studies
Automation
Construction Lead Scraper
Apify → CRM pipeline that scrapes construction prospects and drops only new leads into the sheet.
n8nApifyGoogle SheetsHTTP / polling
The problem
Sales teams needed structured, repeatable prospect lists instead of manual copy-paste from public listings, and they could not afford duplicates hitting the same inbox twice.
What we built
An n8n workflow that starts an Apify actor, polls until the run finishes, maps results into CRM fields, filters out emails already in the sheet, and appends only new rows.
What the system does
- Scheduled Apify actor runs with status polling and retry
- CRM / sheet dedupe before write
- Email filter and field mapping into outreach-ready columns
- Skip path when a run produces no new leads
Similar systems
All case studiesRelaydeskProduct / Internal Build
Relaydesk: WhatsApp Automation SaaS
Multi-tenant messaging architecture with queues, webhooks, and campaigns.
Next.jsTypeScriptTailwind
Read case study CITA MonitorWorking Software
CITA Monitor: Appointment Availability & Auto-Booking
Working software that watches ICP+ slots and alerts over Telegram.
PythonFastAPISQLite
Read case study AI Voice ReceptionistProduct / Concept
AI Voice Receptionist
Phone conversations that collect structured data and write back to a CRM.
VapiTwilioDeepgram
Read case study