{"product_id":"linkedin-hiring-signal-qualifier-with-gemini-google-sheets","title":"LinkedIn Hiring Signal Qualifier with Gemini \u0026 Google Sheets","description":"\u003ch3\u003eAuto-qualify LinkedIn hiring signals, score fit with Gemini, and route leads to recruiters in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically scans LinkedIn hiring posts on a schedule, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to extract hiring details and generate an \u003cstrong\u003eICP fit score\u003c\/strong\u003e, logs qualified leads to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, notifies recruiters by \u003cstrong\u003eGmail\u003c\/strong\u003e, and sends a \u003cstrong\u003edaily Microsoft Teams digest\u003c\/strong\u003e covering outreach activity, funnel status, and SLA flags.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on two schedules:\u003c\/strong\u003e 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.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches LinkedIn posts from the past day\u003c\/strong\u003e via the \u003cstrong\u003eUnipile API\u003c\/strong\u003e, using rotating keyword queries and normalizing results into one item per post.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates\u003c\/strong\u003e by reading the existing \u003cstrong\u003eLeads\u003c\/strong\u003e spreadsheet in Google Sheets and skipping posts already logged (including recently seen authors).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies a regex gate\u003c\/strong\u003e to filter out non-matching content before qualification.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQualifies leads with Google Gemini:\u003c\/strong\u003e extracts hiring information and computes an \u003cstrong\u003eICP fit score\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOnly keeps qualified posts\u003c\/strong\u003e where \u003cem\u003ehiring=true\u003c\/em\u003e and \u003cem\u003escore ≥ 40\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAssigns leads to recruiters\u003c\/strong\u003e using a \u003cstrong\u003eround-robin\u003c\/strong\u003e approach.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts outreach\u003c\/strong\u003e—Gemini generates a \u003cstrong\u003efour-message LinkedIn outreach sequence\u003c\/strong\u003e per qualified lead.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets\u003c\/strong\u003e with the lead, recruiter assignment, score, and drafted messages, then sends an \u003cstrong\u003eHTML lead notification email\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily Teams digest:\u003c\/strong\u003e summarizes signals captured yesterday, recruiter touch counts vs. daily targets, funnel status counts, and \u003cstrong\u003eSLA action flags\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRecruiting teams automating daily prospecting from LinkedIn hiring posts.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators monitoring outbound pipeline health with funnel + SLA visibility.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying a scalable “qualify → score → route → notify” workflow in n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003elimit\u003c\/strong\u003e, and a \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eUnipile API\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, and \u003cstrong\u003eMicrosoft Teams\u003c\/strong\u003e (incoming webhook digest).\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eHTTP Request\u003c\/strong\u003e for API calls and enforces scheduled execution for timely lead capture.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45945724469427,"sku":"N8N-19081","price":75.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/6-uF3tMkNaLs7Re7f-xRq_T0xbTZv6.png?v=1788426884","url":"https:\/\/buyflowscripts.com\/products\/linkedin-hiring-signal-qualifier-with-gemini-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}