LinkedIn Lead Generation: Auto DM System with Comment Triggers using Unipile & NocoDB

Description

Short Description

This LinkedIn automation workflow monitors post comments for specific trigger words and automatically sends direct messages with lead magnets to engaged users. The system checks connection status, handles non-connected users with connection requests, and prevents duplicate outreach by tracking all interactions in a database.

Key Features

Comment Monitoring**: Scans LinkedIn post comments for customizable trigger words
Connection Status Check**: Determines if users are 1st-degree connections
Automated DMs**: Sends personalized messages with lead magnet links to connected users
Connection Requests**: Asks non-connected users to connect via comment replies
Duplicate Prevention**: Tracks interactions in NocoDB to avoid repeat messages
Message Rotation**: Uses different comment reply variations for authenticity
Batch Processing**: Handles multiple comments with built-in delays

Who This Workflow Is For

Content creators looking to convert post engagement into leads
Coaches and consultants sharing valuable LinkedIn content
Anyone wanting to automate lead capture from LinkedIn posts

How It Works

Setup: Configure post ID, trigger word, and lead magnet link via form
Comment Extraction: Retrieves all comments from the specified post using Unipile
Trigger Detection: Filters comments containing the specified trigger word
Connection Check: Determines if commenters are 1st-degree connections
Smart Routing: Connected users receive DMs, others get connection requests
Database Logging: Records all interactions to prevent duplicates

Setup Requirements

Required Credentials
Unipile API Key**: For LinkedIn API access
NocoDB API Token**: For database tracking

Database Structure
**Table: leads
linkedin_id: LinkedIn user ID
name: User's full name
headline: LinkedIn headline
url: Profile URL
date: Interaction date
posts_id: Post reference
connection_status: Network distance
dm_status: Interaction type (sent/connection request)

Customization Options

Message Templates**: Modify DM and connection request messages
Trigger Words**: Change the words that activate the workflow
Timing**: Adjust delays between messages (8-12 seconds default)
Reply Variations**: Add more comment reply options for authenticity

Installation Instructions

Import the workflow into your n8n instance
Set up NocoDB database with required table structure
Configure Unipile and NocoDB credentials
Set environment variables for Unipile root URL and LinkedIn account ID
Test with a sample post before full use