Skip to main content

Score LinkedIn comments and draft replies with Azure OpenAI and Google Sheets

Workflow preview

Workflow preview
100%
Score LinkedIn comments and draft replies with Azure OpenAI and Google Sheets preview
Open on n8n.io

1. Workflow Overview

Description Automate LinkedIn comment monitoring and turn conversations into qualified sales opportunities using AI . This intelligent agent continuously scans LinkedIn posts mentioning your b...

Best for

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

Tools used

n8n-nodes-base.stickynote, n8n-nodes-base.cron, @n8n/n8n-nodes-langchain.agent, n8n-nodes-base.code, n8n-nodes-base.googlesheets, n8n-nodes-base.googlesheetstrigger, n8n-nodes-base.gmail, n8n-nodes-serpapi.serpapi

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
Score LinkedIn comments and draft replies with Azure OpenAI and Google Sheets
Workflow name
Score LinkedIn comments and draft replies with Azure OpenAI and Google Sheets

📊 Description

Automate LinkedIn comment monitoring and turn conversations into qualified sales opportunities using AI 🤖. This intelligent agent continuously scans LinkedIn posts mentioning your brand, analyzes every comment for buyer intent and sentiment, and drafts context-aware replies automatically. High-intent leads are scored and organized in Google Sheets, while your media team receives structured email reports 📧 for fast action. Perfect for brands that want real-time social listening, lead intelligence, and AI-powered engagement without manual monitoring.

What This Template Does

⏰ Triggers every 15 minutes to monitor LinkedIn brand mentions automatically. 🔍 Searches LinkedIn posts via SerpAPI based on your defined keywords. 💬 Fetches all post comments using ConnectSafely LinkedIn API. 🧠 Uses an AI Intent Detection Agent (Azure OpenAI) to score buyer intent and sentiment. 📊 Saves structured lead data (intent score + label) into Google Sheets. ✍️ Generates AI-powered reply drafts tailored to comment sentiment. 📧 Sends a formatted email report to your media team for approval and publishing.

Key Benefits

✅ Fully automated LinkedIn comment monitoring ✅ AI-powered buyer intent detection and scoring ✅ Zero manual scraping or tracking required ✅ Context-aware reply generation for higher engagement ✅ Centralized lead tracking inside Google Sheets ✅ Real-time reporting for faster sales follow-ups

Features

  • Cron-based automated social listening
  • LinkedIn post discovery via SerpAPI
  • Comment extraction using ConnectSafely
  • AI sentiment & intent classification (Azure OpenAI GPT-4o-mini)
  • Automated reply drafting agent
  • Google Sheets logging & workflow triggers
  • Gmail-based HTML reporting system
  • Multi-stage automation architecture (Scrape → Analyze → Reply → Report)

Requirements

  • SerpAPI API key
  • ConnectSafely LinkedIn API credentials
  • Azure OpenAI API credentials
  • Google Sheets OAuth2 connection
  • Gmail OAuth2 connection
  • A configured Google Sheet for storing comments and leads

Target Audience

🎯 B2B founders building authority on LinkedIn 📈 Social media & growth teams managing brand engagement 💼 Sales teams looking for warm inbound intent signals 🤖 Automation agencies building AI-powered social listening systems

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 - Sticky Note – Workflow Overview

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

Block 2 - Sticky Note – Trigger

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

Block 3 - Sticky Note – SerpAPI Search

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

Block 4 - Sticky Note – Parse & Filter

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

Block 5 - Sticky Note – Fetch Comments

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

Block 6 - Sticky Note – Flatten Comments

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

Block 7 - Sticky Note – AI Intent Agent

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

Block 8 - Sticky Note – Parse Sentiment Output

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

Block 9 - Sticky Note – Save to Sheet

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

Block 10 - Sticky Note – Pipeline 2 Header

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

Block 11 - Sticky Note – Sheet Trigger P2

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

Block 12 - Sticky Note – Reply Agent

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

Block 13 - Sticky Note – Format Reply

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

Block 14 - Sticky Note – Write Reply

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

Block 15 - Sticky Note – Pipeline 3 Header

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

Block 16 - Sticky Note – Approved Trigger

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

Block 17 - Sticky Note – Build Report

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

Block 18 - Sticky Note – Send Email

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

Block 19 - Trigger Every 15 Minutes1

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

Block 20 - AI Sentiment & Intent Detection Agent1

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

Block 21 - Parse Sentiment & Score Output1

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

Block 22 - Save Comments & Sentiment to Google Sheet1

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

Block 23 - Watch Sheet for New Comment Rows1

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

Block 24 - AI Reply Drafting Agent1

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

Showing the first 24 of 35 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow Score LinkedIn comments and draft replies with Azure OpenAI and Google Sheets
Complexity advanced
Nodes 35
Categories Lead Generation, AI Summarization
Author Rahul Joshi
Published 09 Mar 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/13958/13958.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 Score LinkedIn comments and draft replies with Azure OpenAI and Google Sheets do?

Description Automate LinkedIn comment monitoring and turn conversations into qualified sales opportunities using AI . This intelligent agent continuously scans LinkedIn posts mentioning your b...

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.