LinkedIn Hiring Signal Qualifier with Gemini & Google Sheets

Auto-qualify LinkedIn hiring signals, score fit with Gemini, and route leads to recruiters in Google Sheets

This n8n workflow automatically scans LinkedIn hiring posts on a schedule, uses Google Gemini to extract hiring details and generate an ICP fit score, logs qualified leads to Google Sheets, notifies recruiters by Gmail, and sends a daily Microsoft Teams digest covering outreach activity, funnel status, and SLA flags.

What this workflow does

• Runs on two schedules: every 2 hours (08:00–20:00 IST, Mon–Sat) to discover leads, and daily at 08:00 IST (Mon–Sat) to publish a performance digest.
• Searches LinkedIn posts from the past day via the Unipile API, using rotating keyword queries and normalizing results into one item per post.
• Deduplicates by reading the existing Leads spreadsheet in Google Sheets and skipping posts already logged (including recently seen authors).
• Applies a regex gate to filter out non-matching content before qualification.
• Qualifies leads with Google Gemini: extracts hiring information and computes an ICP fit score.
• Only keeps qualified posts where hiring=true and score ≥ 40.
• Assigns leads to recruiters using a round-robin approach.
• Drafts outreach—Gemini generates a four-message LinkedIn outreach sequence per qualified lead.
• Updates Google Sheets with the lead, recruiter assignment, score, and drafted messages, then sends an HTML lead notification email via Gmail.
• Daily Teams digest: summarizes signals captured yesterday, recruiter touch counts vs. daily targets, funnel status counts, and SLA action flags.

Use cases

• Recruiting teams automating daily prospecting from LinkedIn hiring posts.
• SaaS operators monitoring outbound pipeline health with funnel + SLA visibility.
• Automation engineers deploying a scalable “qualify → score → route → notify” workflow in n8n.

Technical details

• n8n nodes include: if, code, gmail, limit, and a sticky note.
• Integrations: Unipile API, Google Sheets, Google Gemini, Gmail, and Microsoft Teams (incoming webhook digest).
• Uses HTTP Request for API calls and enforces scheduled execution for timely lead capture.