n8n LinkedIn Lead Scoring with Apify, OpenAI & Google Sheets

Automatically score LinkedIn leads, generate a personalized opener, and log everything to Google Sheets

This n8n workflow runs on a weekly schedule to search LinkedIn profiles using Apify, uses OpenAI to score each lead and draft a profile-grounded opener, then appends the results (including reasoning and risk notes) to Google Sheets for your outreach pipeline.

What this workflow does

• Scheduled lead sourcing: Starts with a weekly Schedule Trigger to run your search on a consistent cadence.
• Search and retrieve LinkedIn profiles via Apify: Uses the Apify LinkedIn Profile Search Scraper actor (dami_studio/linkedin-profile-search-scraper) with your configured search query, locations, customer description, and maximum result limit.
• Filter for judgeable profiles: Removes profiles that are missing key information (e.g., a headline) so the scoring model has adequate context.
• Avoid duplicate scoring: Skips profiles already processed in previous runs.
• OpenAI lead scoring + outreach prep: Sends each remaining profile to an OpenAI chat model to return:
  • a JSON score (1–5)
  • a quoted reason
  • a risk note
  • a profile-grounded opening line
• Log to Google Sheets: Appends the scored lead details to your specified spreadsheet and worksheet for review and outreach.

Use cases

• SaaS operators qualifying LinkedIn leads weekly without manual review.
• Automation engineers building an n8n LinkedIn lead scoring workflow with persistent records in Google Sheets.
• Teams generating consistent, personalized outreach openers backed by scored reasoning and risk notes.

Technical details

• Nodes used: set, filter, sticky note, google sheets, apifyn8n-nodes-apify (Apify), and schedule trigger.
• Integrations: Apify (actor: dami_studio/linkedin-profile-search-scraper), OpenAI (chat model for scoring and opener drafting), and Google Sheets (append results).

Setup: Add Apify API token credentials, an OpenAI API key credential, connect Google Sheets credentials, then set your target persona fields (search query, locations, customer description, max items).