Quick overview
Quick overview This workflow runs scheduled LinkedIn hiring-signal searches via Unipile, qualifies posts with Google Gemini, logs new leads to Google Sheets, and notifies recruiters by Gmail, plus a daily Microsoft Teams digest that summarizes recruiter outreach activity, funnel status, and SLA flags. How it works 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 post a performance digest. Searches LinkedIn posts from the past day via the Unipile API using rotating keyword queries and normalizes the results into one item per post. Reads the existing Leads spreadsheet in Google Sheets and deduplicates posts so previously logged posts (and recently seen authors) are skipped. Filters remaining posts with a regex gate, then sends survivors to Google Gemini to extract hiring details and generate an ICP fit score. Keeps only qualified posts (hiring=true and score ≥ 40), assigns each lead to a recruiter via round-robin, and uses Google Gemini to draft a four-message LinkedIn outreach sequence. Appends the qualified lead, recruiter assignment, score, and drafted messages to Google Sheets and sends an HTML lead notification email through Gmail. For the daily digest, reads all rows from Google Sheets, calculates signals captured yesterday, touches per recruiter versus the daily target, funnel counts by status, and SLA action flags, then posts the summary to Microsoft Teams via an incoming webhook. Setup Add credentials for Google Sheets OAuth2 (all Sheets steps) and Gmail OAuth2 (lead notification email). Provide a Unipile API key and set your Unipile DSN and LinkedIn account ID used for search. Provide a Google Gemini API key for both Gemini HTTP requests. Update the Google Sheets document URL/ID and ensure the sheet has columns matching the workflow’s lead and outreach fields (Lead ID, Signal Date, Recruiter, Touch dates, Reply Date, Status, and draft message columns). Set your Microsoft Teams incoming webhook URL for the daily digest (and optionally for recruiter pings) and update the recruiter names, emails, and target touch-per-day settings in the configuration code blocks. Remove or bypass the “Limit (Testing Only)” cap before going live, then activate both schedule triggers. An n8n automation workflow template by Rahul Joshi.
Rahul Joshi
web
free
Others in the same category, ranked by how often they are opened.
