n8n LinkedIn Lead Qualification with Apify + Gemini + Google Sheets

Turn LinkedIn searches into qualified leads—with scoring and Turkish outreach

This n8n automation workflow pulls LinkedIn profiles using Apify, extracts key lead fields, then uses an OpenRouter (Google Gemini) AI agent to score each lead and draft a Turkish outreach angle. Finally, it stores the qualified results directly into Google Sheets for follow-up.

What this workflow does

• Manual start: The workflow begins when you manually execute it in n8n.
• Search & collect LinkedIn profiles (Apify): It runs the Apify LinkedIn Profile Search Scraper actor using your configured search query and max items to fetch matching profiles.
• Extract & normalize lead fields: It pulls and normalizes important fields from the profile data, including email (from profile text) when available and a `website domain` if present.
• AI lead qualification (OpenRouter + Gemini): The collected profiles are sent to an OpenRouter chat model (configured as google/gemini-2.5-pro) to:
  • Score each lead
  • Explain the score in Turkish
  • Propose a Turkish outreach angle
• Structured output parsing: The AI response is parsed into structured lead records containing score, reason, and outreach angle.
• Save to Google Sheets: Each qualified lead is appended as a new row in your selected spreadsheet and sheet.

Use cases

• Generate sales-ready prospect lists for a Turkish-speaking outreach motion using LinkedIn search criteria.
• Qualify inbound leads from specific job titles/industries and keep a clean CRM-like table in Google Sheets.
• SaaS operators and automation engineers need an end-to-end “search → qualify → messaging angle → store” workflow in n8n.

Technical details

• n8n nodes: Manual Trigger, Code, Sticky Note, Google Sheets, Apify (apifyn8n-nodes-apify), and n8n-nodes-langchainagent (AI agent).
• Integrations: Apify LinkedIn Profile Search Scraper, OpenRouter (Google Gemini), Google Sheets OAuth.
• Setup required: Apify credentials + actor input (search query, max items), OpenRouter API key (ensure google/gemini-2.5-pro availability), and Google Sheets spreadsheet/sheet mapping.