OpenAI + Gluecrawl n8n Workflow: Score Local Leads

Turn local lead lists into a ranked outreach target—every week

This n8n workflow automatically picks a new US niche, city, and state each Monday using OpenAI, scrapes matching local business listings from Manta via Gluecrawl.ai, scores each business’s website health, and saves a ranked call list to n8n Data Tables—so you always have fresh, prioritized leads ready to act on.

What this workflow does

• Runs weekly on schedule: A Schedule Trigger runs every Monday morning (default 07:00—adjustable to your timezone).
• Selects a weekly prospect segment with OpenAI: It reads past segments from the local_segments Data Table and uses an OpenAI Chat Model to choose a new niche, city, and state.
• Scrapes Manta listings using Gluecrawl: It builds a Manta search URL, creates a Gluecrawl job, and extracts business details like name, address, phone, website, and listing URL.
• Deduplicates leads: Businesses already stored in local_leads are skipped by deduplicating on the directory listing URL.
• Scores website health and contact signals: For each business website (when available), it assigns a tier and score using rule-based checks such as reachability, HTTPS, analytics, and contact/booking signals.
• Saves results and generates a brief: Each scored lead is upserted into local_leads, and a markdown brief is produced with hot/warm leads and written back to local_segments for next week’s selection.

Use cases

• SaaS operators validating local market opportunities with fresh, ranked prospects.
• Automation engineers building a repeatable “local lead sourcing + qualification” pipeline in n8n.
• Teams preparing call lists for outbound—focused on website quality and contact readiness.

Technical details

• Gluecrawl integration: Uses community node @gluecrawl/n8n-nodes-gluecrawl with a Gluecrawl API credential.
• OpenAI segment selection: Configures an OpenAI API credential for the OpenAI Chat Model (via LLM-related nodes).
• n8n components: Code, Data Table, Sticky Note, Manual Trigger, and Schedule Trigger.
• Data storage: Initializes and writes to local_leads and local_segments using an included “Set Up” manual trigger.