Skip to main content

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

Workflow preview

Workflow preview
100%
Scrape LinkedIn comments and score lead intent using ConnectSafely, Azure OpenAI, and Google Sheets preview
Open on n8n.io

1. Workflow Overview

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 comm...

Best for

  • Lead Generation automation workflows
  • AI Summarization automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.manualtrigger, n8n-nodes-base.stickynote, n8n-nodes-serpapi.serpapi, n8n-nodes-connectsafely-ai.connectsafelylinkedin, n8n-nodes-base.code, @n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmchatazureopenai, n8n-nodes-base.googlesheets

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Rahul Joshi.

Original n8n.io source

1.1 Workflow description

Title
Scrape LinkedIn comments and score lead intent using ConnectSafely, Azure OpenAI, and Google Sheets
Workflow name
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

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - When clicking ‘Execute workflow’

Type / Role
n8n-nodes-base.manualTrigger - manualTrigger
Config choices
Version 1

Block 2 - Main Overview

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 3 - Section: Search & Scrape

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 4 - Section: Comment Processing

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 5 - Section: AI Intent Scoring

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 6 - Warning: SerpAPI

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 7 - Warning: ConnectSafely

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 8 - Warning: Azure OpenAI

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 9 - Search LinkedIn Posts via SerpAPI

Type / Role
n8n-nodes-serpapi.serpApi - serpApi
Config choices
Version 1

Block 10 - Fetch Post Comments via ConnectSafely

Type / Role
n8n-nodes-connectsafely-ai.connectSafelyLinkedIn - connectSafelyLinkedIn
Config choices
Version 1

Block 11 - Parse & Filter Search Results

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 12 - AI Intent Detection Agent

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 3

Block 13 - Azure OpenAI GPT-4o-mini

Type / Role
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - lmChatAzureOpenAi
Config choices
Version 1

Block 14 - Flatten Comments into Rows

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 15 - Parse AI Intent Output

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 16 - Save Leads to Google Sheet

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

3. Summary Table

Workflow Scrape LinkedIn comments and score lead intent using ConnectSafely, Azure OpenAI, and Google Sheets
Complexity advanced
Nodes 16
Categories Lead Generation, AI Summarization
Author Rahul Joshi
Published 03 Feb 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/13185/13185.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Scrape LinkedIn comments and score lead intent using ConnectSafely, Azure OpenAI, and Google Sheets do?

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 comm...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Lead Generation, AI Summarization use case.