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

Description

📊 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