{"product_id":"openai-gluecrawl-n8n-workflow-score-local-leads","title":"OpenAI + Gluecrawl n8n Workflow: Score Local Leads","description":"\u003ch3\u003eTurn local lead lists into a ranked outreach target—every week\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically picks a new US niche, city, and state each Monday using OpenAI, scrapes matching local business listings from \u003cstrong\u003eManta\u003c\/strong\u003e via \u003cstrong\u003eGluecrawl.ai\u003c\/strong\u003e, 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly on schedule:\u003c\/strong\u003e A \u003cem\u003eSchedule Trigger\u003c\/em\u003e runs every Monday morning (default 07:00—adjustable to your timezone).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects a weekly prospect segment with OpenAI:\u003c\/strong\u003e It reads past segments from the \u003ccode\u003elocal_segments\u003c\/code\u003e Data Table and uses an OpenAI Chat Model to choose a new \u003cstrong\u003eniche\u003c\/strong\u003e, \u003cstrong\u003ecity\u003c\/strong\u003e, and \u003cstrong\u003estate\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapes Manta listings using Gluecrawl:\u003c\/strong\u003e It builds a Manta search URL, creates a \u003cstrong\u003eGluecrawl\u003c\/strong\u003e job, and extracts business details like \u003cem\u003ename, address, phone, website, and listing URL\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates leads:\u003c\/strong\u003e Businesses already stored in \u003ccode\u003elocal_leads\u003c\/code\u003e are skipped by deduplicating on the directory \u003cstrong\u003elisting URL\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores website health and contact signals:\u003c\/strong\u003e For each business website (when available), it assigns a tier and score using rule-based checks such as \u003cstrong\u003ereachability\u003c\/strong\u003e, \u003cstrong\u003eHTTPS\u003c\/strong\u003e, \u003cstrong\u003eanalytics\u003c\/strong\u003e, and \u003cstrong\u003econtact\/booking signals\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves results and generates a brief:\u003c\/strong\u003e Each scored lead is upserted into \u003ccode\u003elocal_leads\u003c\/code\u003e, and a \u003cstrong\u003emarkdown brief\u003c\/strong\u003e is produced with hot\/warm leads and written back to \u003ccode\u003elocal_segments\u003c\/code\u003e for next week’s selection.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators validating local market opportunities with fresh, ranked prospects.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a repeatable “local lead sourcing + qualification” pipeline in n8n.\u003c\/li\u003e\n  \u003cli\u003eTeams preparing call lists for outbound—focused on website quality and contact readiness.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGluecrawl integration:\u003c\/strong\u003e Uses community node \u003ccode\u003e@gluecrawl\/n8n-nodes-gluecrawl\u003c\/code\u003e with a Gluecrawl API credential.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI segment selection:\u003c\/strong\u003e Configures an OpenAI API credential for the OpenAI Chat Model (via LLM-related nodes).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n components:\u003c\/strong\u003e Code, Data Table, Sticky Note, Manual Trigger, and Schedule Trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage:\u003c\/strong\u003e Initializes and writes to \u003ccode\u003elocal_leads\u003c\/code\u003e and \u003ccode\u003elocal_segments\u003c\/code\u003e using an included “Set Up” manual trigger.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45830396772531,"sku":"N8N-18237","price":69.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/UNN7yrIVBCVug8f4XWiPp_qutyxm4x.png?v=1786698377","url":"https:\/\/buyflowscripts.com\/products\/openai-gluecrawl-n8n-workflow-score-local-leads","provider":"N8N Commerce","version":"1.0","type":"link"}