My Role: Automation Engineer / API Integration Specialist
Project description.
Built an end-to-end clinic lead generation automation MVP using Apify, n8n, and Google Sheets. The system scrapes public clinic and doctor listing pages, extracts structured data such as doctor name, specialty, consultation fee, ratings, and images, then normalizes and deduplicates the data before exporting it to Google Sheets. The workflow handles inconsistent result counts, pagination limits, and nested API responses, producing 30–100 qualified leads per run. This solution is reusable for other industries like local services, real estate, and B2B lead generation.
Workflow Overview.
Data Output.
Key Features.
- Automated data scraping with Apify
- Data normalization & deduplication in n8n
- Pagination & edge case handling
- Structured export to Google Sheets
- Scalable workflow design for other industries