Quick overview
Quick overview This workflow captures new Facebook Marketplace page messages, uses OpenAI (GPT-4o-mini) to extract structured inquiry details, stores them in Supabase, scores the lead based on intent, and posts hot, warm, or cold lead alerts to different Slack channels. How it works Triggers when a new Facebook Page message related to Marketplace activity is received via the Facebook webhook subscription. Sends the message text to OpenAI (GPT-4o-mini) to classify intent, identify the product mentioned, and generate a short summary in strict JSON. Parses the AI output into JSON safely, falling back to “unknown” fields if parsing fails. Inserts the structured inquiry (intent, product_id, product_mentioned, summary) into a Supabase table for tracking. Computes a lead score from the extracted intent and evaluates whether the inquiry is hot (score ≥ 5) or not. Routes non-hot inquiries into warm (score ≥ 3) or cold and posts the appropriate formatted alert to the corresponding Slack channel. Setup Create a Facebook App, connect it to your Facebook Page, and configure the required webhook subscriptions/permissions for Page messages. Add an OpenAI API credential in n8n and ensure the workflow can access the GPT-4o-mini model. Add a Supabase credential and create a marketplace_inquiries table with product_id, product_mentioned, summary, and intent columns. Add a Slack credential and set or replace the target channel IDs for hot, warm, and cold lead notifications. Update the Facebook Trigger node’s App ID placeholder and complete the trigger’s webhook verification steps in the Facebook Developer settings. Additional info How To Customize Nodes Modify the AI prompt to extract additional fields if needed Adjust lead scoring logic in the Code node Change Slack message format to match your team’s preference Update Slack channel IDs based on your workspace setup Customize Supabase table structure if additional tracking is required Modify IF node conditions to change lead classification thresholds Add-ons Add Facebook reply automation for instant responses Integrate CRM systems for lead management Add follow-up workflows using Cron nodes Store analytics data for reporting dashboards Integrate Telegram or email alerts alongside Slack Add sentiment analysis for deeper insights Use Case Examples Automatically identify high-intent buyers from Facebook Marketplace Notify sales teams instantly about hot leads Organize leads based on priority without manual effort Track customer inquiries for reporting and analysis Improve response time and lead conversion rates There can be many more use cases depending on how you extend this workflow with additional integrations and logic. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|--------------|---------| | No data from Facebook | Webhook not configured properly | Verify Facebook App and webhook setup | | AI output parsing fails | Invalid JSON from AI response | Check prompt format and parsing logic | | Data not stored in Supabase | गलत credentials or table issue | Verify Supabase credentials and table mapping | | Slack message not sent | Incorrect channel ID or permissions | Check Slack API credentials and channel access | | Lead classification incorrect | Wrong scoring logic | Update Code node scoring rules | | Workflow not triggering | Trigger not active | Activate workflow and test webhook | Need Help? If you need help setting up this workflow, customizing nodes or extending it with advanced features like CRM integration, auto-replies or analytics dashboards, you can reach out to our n8n workflow developers for expert support. We can help you build scalable automation workflows tailored to your business needs. An n8n automation workflow template by WeblineIndia.
WeblineIndia
web
free
Others in the same category, ranked by how often they are opened.
