🎣 Qualify LinkedIn leads with Apify, Gemini via OpenRouter, and Google Sheets
⚡ 8 views · 🎣 Lead Generation & Enrichment
💡 Pro Tip — If you’re pulling LinkedIn data through HTTP requests or dealing with API restrictions, there’s a community node called ScraperNode that handles this natively. It has dedicated scrapers for profiles, companies, jobs, and people search — you just pass a URL and get structured data back.
Description
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
- Starts when you manually execute the workflow.
- Uses Apify’s LinkedIn Profile Search Scraper actor to fetch a list of LinkedIn profiles matching a configured search query.
- Extracts and normalizes lead fields, including email (from profile text) and a website domain if present.
- 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.
- Parses the AI output into structured lead records with score, reason, and outreach angle.
- Appends each lead as a new row in Google Sheets.
Setup
- Connect your Apify account credentials and configure the Apify actor input (search query and max items) to match your target audience.
- Add an OpenRouter API credential and ensure the selected model (google/gemini-2.5-pro) is available in your account.
- Connect your Google Sheets OAuth credential and update the spreadsheet, sheet name, and column mapping to match your Google Sheet.
🔗 Nodes Used
Google Sheets, AI Agent, OpenRouter Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File