{"product_id":"n8n-linkedin-lead-scoring-with-apify-openai-google-sheets","title":"n8n LinkedIn Lead Scoring with Apify, OpenAI \u0026 Google Sheets","description":"\u003ch3\u003eAutomatically score LinkedIn leads, generate a personalized opener, and log everything to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs on a weekly schedule to search LinkedIn profiles using \u003cstrong\u003eApify\u003c\/strong\u003e, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to score each lead and draft a profile-grounded opener, then appends the results (including reasoning and risk notes) to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for your outreach pipeline.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled lead sourcing:\u003c\/strong\u003e Starts with a weekly \u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e to run your search on a consistent cadence.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearch and retrieve LinkedIn profiles via Apify:\u003c\/strong\u003e Uses the \u003cstrong\u003eApify LinkedIn Profile Search Scraper\u003c\/strong\u003e actor (\u003cem\u003edami_studio\/linkedin-profile-search-scraper\u003c\/em\u003e) with your configured search query, locations, customer description, and maximum result limit.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilter for judgeable profiles:\u003c\/strong\u003e Removes profiles that are missing key information (e.g., a headline) so the scoring model has adequate context.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAvoid duplicate scoring:\u003c\/strong\u003e Skips profiles already processed in previous runs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI lead scoring + outreach prep:\u003c\/strong\u003e Sends each remaining profile to an \u003cstrong\u003eOpenAI chat model\u003c\/strong\u003e to return:\n    \u003cul\u003e\n      \u003cli\u003ea \u003cstrong\u003eJSON score (1–5)\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003ea \u003cstrong\u003equoted reason\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003ea \u003cstrong\u003erisk note\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003ea \u003cstrong\u003eprofile-grounded opening line\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLog to Google Sheets:\u003c\/strong\u003e Appends the scored lead details to your specified spreadsheet and worksheet for review and outreach.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators qualifying LinkedIn leads weekly without manual review.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an n8n LinkedIn lead scoring workflow with persistent records in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eTeams generating consistent, personalized outreach openers backed by scored reasoning and risk notes.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used:\u003c\/strong\u003e set, filter, sticky note, \u003cstrong\u003egoogle sheets\u003c\/strong\u003e, \u003cstrong\u003eapifyn8n-nodes-apify\u003c\/strong\u003e (Apify), and \u003cstrong\u003eschedule trigger\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Apify (actor: \u003cem\u003edami_studio\/linkedin-profile-search-scraper\u003c\/em\u003e), OpenAI (chat model for scoring and opener drafting), and Google Sheets (append results).\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup:\u003c\/strong\u003e 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).\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45923065561267,"sku":"N8N-18881","price":35.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7BL5CjNY3aB5_VrDFWKCQ_XkfAP4QX.png?v=1788167621","url":"https:\/\/buyflowscripts.com\/products\/n8n-linkedin-lead-scoring-with-apify-openai-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}