I've been testing a structured community outreach pipeline for B2B lead gen, and consistency is the piece that still eludes me. The workflow seems straightforward on paper:
- Scan communities for posts mentioning a specific business pain
- Tag the pain point in your tracking system
- Craft a genuinely helpful public reply
- Only DM if the person asks for more or engages back
- Log everything to avoid duplicate or random follow-ups
The part that breaks after day two is the cognitive load of qualifying the post and writing the reply in the same pass. I've since split the discovery run from the response run. I use a Zapier alert that pings me when targeted keywords appear in relevant forums, so I'm not manually refreshing threads. That alone saved me about four hours a week.
For tracking I use a Google Sheet with a simple script that flags threads older than 48 hours or any reply where the author hasn't responded. Here's the core of the Apps Script:
function flagStaleLeads() {
var sheet = SpreadsheetApp.getActiveSheet(),
var data = sheet.getDataRange().getValues(),
for (var i = 1, i < data.length, i++) {
var replyDate = new Date(data[i][2]),
var daysElapsed = (new Date() - replyDate) / (1000*60*60*24),
if (daysElapsed > 2 && data[i][4] !== 'engaged') {
sheet.getRange(i+1, 5).setValue('stale'),
}
}
}
This keeps the pipeline clean without manual triage.
For those of you running cold email, consulting, or SaaS - what's your best lever? Is it offering a free audit, sharing case studies, or moving the conversation into DMs straight after a good reply? I'm curious which action yields the most qualified conversations.