Business Automation
Lead Generation Automation Pipeline
End-to-end n8n workflow that scrapes prospects, enriches data with AI, sends personalized outreach via email and LinkedIn, and logs results to a Google Sheet.
Client Demand
The client spent 20 hours a week manually searching for leads on LinkedIn and writing custom emails. They needed this completely automated.
Budget$4,000 - $7,000
Timeline2 Weeks
Step-by-Step Process
1
Planning
I analyzed their manual workflow to determine the exact APIs and tools needed for automation.
2
Building
Created an n8n workflow connecting Apollo, OpenAI for email personalization, and Google Sheets.
3
Testing
Sent 100 test emails internally to ensure the AI did not generate robotic or incorrect text.
4
Revisions
Added a webhook step to notify the sales team in Slack when a hot lead replied.
Technologies Used
n8nOpenAIPythonLinkedIn API
Key Outcome:300 leads/week automated