Scrape LinkedIn comments and score lead intent using ConnectSafely, Azure OpenAI, and Google Sheets

📊 Description Automate LinkedIn lead discovery by identifying high-intent prospects directly from post comments using ConnectSafely and AI 🤖. This workflow searches LinkedIn posts related to common sales pain points, extracts all comments safely, and evaluates each commenter’s buying intent using AI. The scored leads are automatically stored in Google Sheets for easy follow-up and prioritization 📈. Perfect for sales, growth, and RevOps teams looking to turn conversations into qualified opportunities.

🔍 What This Template Does 🔎 Searches LinkedIn posts via SerpAPI using predefined pain-point keywords 🔗 Filters and validates relevant LinkedIn post URLs 🛡️ Fetches all post comments using ConnectSafely (safe, compliant LinkedIn access) 📄 Flattens comments into individual lead records 🤖 Uses AI to analyze each comment and score buying intent (0–100) 📊 Saves enriched lead data into Google Sheets automatically

✅ Key Benefits ✅ Discover warm LinkedIn leads from real conversations ✅ Uses ConnectSafely for reliable and compliant comment extraction ✅ AI-powered intent scoring removes manual lead qualification ✅ Automatically prioritizes high-intent prospects ✅ Centralized lead tracking in Google Sheets ✅ Zero manual scraping or copy-pasting

⚙️ Features LinkedIn post discovery via SerpAPI Comment scraping powered by ConnectSafely AI intent detection using Azure OpenAI (GPT-4o-mini) Intent labels: No-Intent → High-Intent Google Sheets integration for lead storage Modular, customizable n8n workflow

🔐 Requirements SerpAPI account ConnectSafely LinkedIn API credentials Azure OpenAI account (GPT-4o-mini deployment) Google Sheets OAuth credentials n8n instance (self-hosted or cloud)

🎯 Target Audience B2B sales teams & SDRs Growth marketers & lead generation agencies RevOps & automation specialists Founders using LinkedIn for outbound prospecting