Free n8n Workflow

🚀 LinkedIn Lead Scoring Automation

Pull LinkedIn profiles, enrich them with Apify, score every lead with AI based on your ICP, and write results to Google Sheets — automatically. No Clay credits. No manual scoring.

n8nApifyOpenAIGoogle Sheets
LinkedIn Lead Scoring Automation — n8n workflow overview

What You'll Get

1

AI-Powered Lead Scoring

Each LinkedIn profile is scored 0–100 by GPT based on your exact ICP and campaign context — not generic rules.

2

No Clay Credits Required

Runs entirely on n8n + Apify + OpenAI. Score 1,000 leads for ~$1–$3. No expensive SaaS credits ever.

3

Google Sheets Native

Paste LinkedIn URLs, run the workflow, see enriched results with score, label, and fit summary in your sheet.

4

Scales to 1,000+ Leads

Built-in batching handles any list size. 50 leads in ~2 min. 500 leads in ~25 min. Fully hands-off.

5

Full Data Ownership

Everything runs in your n8n with your API keys. No vendor lock-in, no usage credits, no surprise invoices.

6

Fully Customizable

Modify the scoring logic, ICP definition, AI reasoning, and output columns — you own every node.

🧠 How Lead Scoring Works

Each profile is scored 0–100 by AI based on 6 dimensions against your ICP and campaign context.

90–100Dream Lead
75–89Strong Lead
60–74Qualified Lead
40–59Weak Lead
0–39Poor Fit

Quickstart Implementation Guide

7 steps · takes about 15 minutes to set up

1

STEP 1: Download the Workflow

Get the complete n8n workflow file (.json) from Google Drive. This includes all automation logic, AI scoring prompts, and Apify integrations.

2

STEP 2: Import to n8n

Open your n8n dashboard and import the workflow file.

  1. Click Workflows
  2. Select Import from File
  3. Upload linkedin-lead-scoring-workflow.json
  4. Click Import
3

STEP 3: Set API Keys & Campaign Context

Open the "Set API Keys And Context" node. Add your Apify token, OpenAI key, Campaign Context, and Ideal Customer Profile.

The more specific your ICP and campaign context, the better your lead scores will be.
Set API Keys And Context node configuration
4

STEP 4: Copy the Google Sheets Template

You'll use this sheet to input LinkedIn URLs. One column. That's it.

  1. Click File → Make a Copy
  2. Save it to your Google Drive
Google Sheets template with linkedin_url column
5

STEP 5: Connect Google Sheets to n8n

Back in n8n, link your copied Google Sheet to the workflow.

  1. Open the "Read LinkedIn URLs" node
  2. Click Credentials → Add New
  3. Connect your Google account
  4. Select your copied sheet and the correct tab
6

STEP 6: Add LinkedIn URLs & Run

Paste profile URLs into the linkedin_url column. Add 10, 100, or 1,000+ — the system handles batching automatically. Then click Execute Workflow in n8n.

7

STEP 7: View Your Scored Results

Open your Google Sheet. New columns populate automatically: lead_score, score_label, and fit_summary.

Google Sheets results with lead scores and fit summaries

🎉 You're live! Focus your outreach on Dream Leads and Strong Leads first.

📚 Resources & Support

Need Custom Lead Scoring?

We'll build a fully tailored lead scoring system that fits your exact ICP, data sources, and outbound stack — deployed and working in days.

Book a Call