The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
I built targeted B2B lead lists of local businesses, organized by city with category, rating, reviews and contact details. Each list is cleaned, deduplicated and delivered in Google Sheets or Excel, ready for outreach. (Contact details hidden for privacy.)
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
Automated B2B Lead Gen Engine from LinkedIn Jobs (n8n + Apify + Apollo + Gemini)
Project Overview
Hiring intent is the highest-converting B2B buying signal. When a company posts an open role on LinkedIn, they have an active pain point, immediate budget, and executive mandate to solve that problem.
This automated production engine runs every morning without manual intervention. It scrapes fresh LinkedIn job postings via Apify, filters out non-target companies, queries Apollo.io to identify the exact decision-maker (Founder, CEO, VP, or Head of Department) with their verified work email, and uses Google Gemini to write hyper-personalized outbound pitch drafts directly into Google Sheets.
Visual Showcase & Live Architecture
1. Verified Leads Database & AI Outbound Drafts (Google Sheets)
Preview unavailable
Automated output storing company data, verified decision-maker email, LinkedIn profile URL, hiring intent triggers, and ready-to-send AI cold email copy.
2. End-to-End n8n Engine Blueprint
Preview unavailable
Full production pipeline orchestrating Apify actor execution, domain validation, Apollo personnel search, Gemini structured output parsing, and real-time sheet sync.
Technical Workflow Architecture
Targeted Job Extraction (Apify): Triggers an automated actor scraping LinkedIn job postings based on target titles, geographic focus, and date posted.
Data Sanitization & Strict Gatekeeping: Filters dataset entries by company size (< 250 headcount), eliminates recruitment agencies and HR service providers, and verifies live web domain resolution.
Personnel Enrichment & Email Validation (Apollo.io): Targets executive personas matching the hiring team, executes verification checks against corporate MX records, and retrieves direct work emails and LinkedIn URLs.
Context-Aware Email Drafting (Google Gemini): Analyzes job descriptions, extracts company pain points, and drafts personalized 3-sentence email openers with high deliverability scores.
Centralized Data Lake (Google Sheets / CRM Sync): Logs verified contact records, generated copy, and campaign statuses, ready for direct one-click import into Smartlead, Instantly, or Clay.
Key Performance Metrics
Runtime Execution: 2 minutes per batch run (50–100 validated leads).
Email Deliverability: 98%+ valid deliverability via Apollo API verification.
Workflow Efficiency: Replaces 10–15 hours per week of manual SDR prospecting.
Data Quality: 100% deduplicated against previous pipeline runs.
Deliverables Included
Complete standalone n8n workflow JSON blueprint ready for self-hosted or n8n cloud instances.
Pre-configured Apify scraper actor setup and Apollo.io API integration.
Custom Google Sheets outbound tracking dashboard with schema validation.
Gemini prompt engineering optimized for high cold-outreach open and reply rates.
1-on-1 Loom video walkthrough and handover documentatio
This is beautiful
Component interactions for a recent B2B project
📊 Turn Your Excel Data Into a Clear Business Dashboard
Still managing your business reports in Excel and spending hours trying to understand your numbers?
I help small businesses turn their existing Excel/CSV data into simple, interactive Power BI dashboards.
With a dashboard, you can quickly track:
• 📈 Sales performance
• 🏆 Top-selling products
• 👥 Customer trends
• 🏪 Store/branch performance
• 📦 Product performance
• 🎯 KPIs and monthly targets
I recently built a retail analytics dashboard using Power BI, with data cleaning and transformation using Excel/Power Query.
I'm currently looking to work with small businesses, retailers, and growing teams that want their data to be easier to understand and use.
💬 If you already maintain your business data in Excel, feel free to message me. I'd be happy to show you what a dashboard could look like for your business.
