n8n Facebook Marketplace Lead Scoring to Slack w/ OpenAI & Supabase

Turn Facebook Marketplace messages into scored leads—automatically alert your team on Slack using OpenAI + Supabase

n8n Facebook Marketplace Lead Scoring to Slack w/ OpenAI & Supabase is an automation workflow that captures new Facebook Page Marketplace inquiries, uses OpenAI (GPT-4o-mini) to extract structured intent and product details, stores them in Supabase, scores the lead, and posts hot/warm/cold alerts to different Slack channels.

What this workflow does

• Listens for new Facebook Marketplace page messages via a Facebook webhook subscription triggered when a relevant Page message is received.
• Analyzes the message with OpenAI (GPT-4o-mini) to classify inquiry intent, identify the product mentioned, and generate a short summary in strict JSON.
• Safely parses AI output into JSON, falling back to “unknown” fields if parsing fails.
• Tracks structured inquiries in Supabase by inserting fields like intent, product_id, product_mentioned, and summary into the marketplace_inquiries table.
• Computes a lead score from the extracted intent and determines whether it’s hot (score ≥ 5) or not.
• Routes alerts by priority:
  • Hot leads (score ≥ 5) posted to the “hot” Slack channel
  • Warm leads (score ≥ 3) posted to the “warm” Slack channel
  • Cold leads posted to the corresponding “cold” channel

Use cases

• Auto-triage incoming Facebook Marketplace questions so sales reps act first on high-intent buyers.
• Centralize inquiry history in Supabase for reporting and follow-up workflows in n8n.
• Reduce missed messages by sending formatted lead alerts directly to Slack.

Technical details

• Facebook webhook subscription trigger for Page messages related to Marketplace activity
• OpenAI (GPT-4o-mini) for intent classification + structured JSON extraction
• Supabase insert into marketplace_inquiries
• Slack notifications to hot/warm/cold channel IDs you configure
• Workflow logic uses if, code, slack, supabase, sticky note, and n8nn8n-nodes-langchainagent