OVERVIEW

Built an automated ICP lead scoring system in Bash that processes Clay lead exports, scores each contact against 6 ICP criteria, and routes hot leads to a Slack channel in real time. What previously required 2 hours of manual lead review now runs in under 5 minutes with zero human input.


PROBLEM

Reviewing Clay exports manually meant opening a spreadsheet, scrolling through 100 rows, and making subjective decisions about which leads were worth pursuing. There was no consistent scoring system, no way to prioritise quickly, and no automation to surface the best leads without human effort. Time spent on manual review was time taken away from actual outreach.


SOLUTION

A Bash script that reads a Clay CSV export, maps each column by header name, runs each lead through a 8 point scoring system, and automatically sends any lead scoring 5 or above to a dedicated Slack channel via webhook. The script runs in seconds, produces a full scored list in the terminal, and fires Slack alerts for hot leads without any manual intervention.


STACK

Bash:

scripting and automation logic

Clay:

lead source and CSV export

Slack Incoming Webhooks:

real time hot lead alerts