SM
Sheby M
Loading portfolio experience
Sales · Automation, Website
RestaurantProspect Flow – Lead Filtering & Lemlist Routing
An automated restaurant prospecting workflow that applies exclusion rules, detects reservation technology, protects existing client lists, and assigns qualified businesses to the correct Lemlist sequence.
Stack and focus areas
Automationn8n/MakePythonn8nGoogle SheetsGoogle MapsWebsite ScrapingReservation Software DetectionTableFeverLemlistLead FilteringData ValidationDuplicate DetectionClient ExclusionSequence AssignmentAirtableWebhooksCRM
Project description
The existing restaurant-scraping workflow added irrelevant business categories, failed to exclude some current clients and previously contacted restaurants, and did not correctly separate TableFever websites from restaurants merely using a TableFever reservation widget.
I rebuilt the filtering and routing logic around configurable Google Sheets tabs. Excluded categories are removed before results are created. Websites carrying the Powered by TableFever footer are excluded, while ordinary TableFever widget users remain eligible. Fine-dining restaurants are routed to a manual-contact tab. Existing clients and already-contacted businesses are normalized and checked before results proceed. Eligible restaurants receive a Lemlist sequence according to reservation software and language rules.
