Qualify LinkedIn leads with Apify, Gemini via OpenRouter, and Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
Community nodes
These come from third-party npm packages. In n8n 3.0 unverified community packages are off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
@apify/n8n-nodes-apify(Retrieve LinkedIn Profiles)
Nodes used (6)
- Apify
@apify/n8n-nodes-apify.apify - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Manual Trigger
n8n-nodes-base.manualTrigger
What it does
Quick overview This workflow pulls LinkedIn profiles with Apify, extracts key fields, uses an OpenRouter (Gemini) AI agent to score and draft Turkish outreach messaging, and saves the qualified lead details to a Google Sheets spreadsheet. How it works 1. Starts when you manually execute the workflow. 2. Uses Apify’s LinkedIn Profile Search Scraper actor to fetch a list of LinkedIn profiles matching a configured search query. 3. Extracts and normalizes lead fields, including email (from profile text) and a website domain if present. 4. Sends the collected profiles to an OpenRouter chat model (Google Gemini) to score each lead, explain the score in Turkish, and propose a Turkish outreach angle. 5. Parses the AI output into structured lead records with score, reason, and outreach angle. 6. Appends each lead as a new row in Google Sheets. Setup 1. Connect your Apify account credentials and configure the Apify actor input (search query and max items) to match your target audience. 2. Add an OpenRouter API credential and ensure the selected model (google/gemini-2.5-pro) is available in your account. 3. Connect your Google Sheets OAuth credential and update the spreadsheet, sheet name, and column mapping to match your Google Sheet.