Automating LinkedIn Lead Generation with n8n

This scheduled n8n workflow automates LinkedIn prospecting. It runs daily, searches for leads via the Harvest API based on queries defined in Google Sheets, scores and deduplicates the results, and delivers the top 10 best leads straight to Telegram.

How It Works

1. Check Buffer: Runs daily at 7:30 AM. It checks the profile_buffer sheet. If you have 10+ pending leads, it skips searching to save API credits.
2. Search: If the buffer is running low, it reads the next unused search query from the search_configs sheet and queries the Harvest API.
3. Process & Deduplicate: New leads are checked against already-saved profiles to prevent duplicates.
4. Score & Send: Leads are scored based on premium status, profile photos, open profiles, and connection counts. The top 10 leads are formatted and sent to Telegram, then marked as Sent in the sheet.

Download n8n Workflow JSON

Google Sheets Setup

To run this workflow, configure a Google Spreadsheet with two tabs:

1. search_configs

Define your target search parameters. The workflow processes queries one by one, marking them as Used.

2. profile_buffer

Where newly discovered leads are stored, deduplicated, and tracked.

Need help setting up this workflow or connecting other APIs to your pipeline? Get in touch for a free workflow audit.