{"product_id":"n8n-linkedin-lead-qualification-with-apify-gemini-google-sheets","title":"n8n LinkedIn Lead Qualification with Apify + Gemini + Google Sheets","description":"\u003ch3\u003eTurn LinkedIn searches into qualified leads—with scoring and Turkish outreach\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation workflow pulls LinkedIn profiles using \u003cstrong\u003eApify\u003c\/strong\u003e, extracts key lead fields, then uses an \u003cstrong\u003eOpenRouter (Google Gemini)\u003c\/strong\u003e AI agent to \u003cstrong\u003escore each lead and draft a Turkish outreach angle\u003c\/strong\u003e. Finally, it stores the qualified results directly into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for follow-up.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual start:\u003c\/strong\u003e The workflow begins when you manually execute it in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearch \u0026amp; collect LinkedIn profiles (Apify):\u003c\/strong\u003e It runs the \u003cstrong\u003eApify LinkedIn Profile Search Scraper\u003c\/strong\u003e actor using your configured search query and max items to fetch matching profiles.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtract \u0026amp; normalize lead fields:\u003c\/strong\u003e It pulls and normalizes important fields from the profile data, including \u003cstrong\u003eemail (from profile text)\u003c\/strong\u003e when available and a `website domain` if present.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI lead qualification (OpenRouter + Gemini):\u003c\/strong\u003e The collected profiles are sent to an OpenRouter chat model (configured as \u003cstrong\u003egoogle\/gemini-2.5-pro\u003c\/strong\u003e) to:\n    \u003cul\u003e\n      \u003cli\u003eScore each lead\u003c\/li\u003e\n      \u003cli\u003eExplain the score in \u003cstrong\u003eTurkish\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003ePropose a \u003cstrong\u003eTurkish outreach angle\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStructured output parsing:\u003c\/strong\u003e The AI response is parsed into structured lead records containing score, reason, and outreach angle.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSave to Google Sheets:\u003c\/strong\u003e Each qualified lead is appended as a new row in your selected spreadsheet and sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGenerate sales-ready prospect lists for a Turkish-speaking outreach motion using LinkedIn search criteria.\u003c\/li\u003e\n  \u003cli\u003eQualify inbound leads from specific job titles\/industries and keep a clean CRM-like table in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators and automation engineers need an end-to-end “search → qualify → messaging angle → store” workflow in n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e Manual Trigger, Code, Sticky Note, Google Sheets, Apify (\u003cstrong\u003eapifyn8n-nodes-apify\u003c\/strong\u003e), and \u003cstrong\u003en8n-nodes-langchainagent\u003c\/strong\u003e (AI agent).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Apify LinkedIn Profile Search Scraper, OpenRouter (Google Gemini), Google Sheets OAuth.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup required:\u003c\/strong\u003e Apify credentials + actor input (search query, max items), OpenRouter API key (ensure \u003cstrong\u003egoogle\/gemini-2.5-pro\u003c\/strong\u003e availability), and Google Sheets spreadsheet\/sheet mapping.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45985528250547,"sku":"N8N-19383","price":9.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/0fyfkTXgetwP6kHWcZzij_nBQsW7fW.png?v=1788945558","url":"https:\/\/buyflowscripts.com\/products\/n8n-linkedin-lead-qualification-with-apify-gemini-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}