{"product_id":"n8n-template-find-candidate-emails-from-linkedin-apify-google-sheets","title":"n8n Template: Find Candidate Emails from LinkedIn (Apify + Google Sheets)","description":"\u003ch3\u003eTurn LinkedIn candidate lists into recruiter-ready email leads (automatically)\u003c\/h3\u003e\n\u003cp\u003eThis n8n template reads LinkedIn profile URLs from your Google Sheets talent pool, uses Apify to find matching candidate email addresses, and writes the results back to your sheet—so your outreach list stays current without manual searching.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns automatically\u003c\/strong\u003e (manually or on a schedule; default is every minute) to pick up newly added candidates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScans your Google Sheets\u003c\/strong\u003e and processes only rows where the \u003cem\u003eemail\u003c\/em\u003e and \u003cem\u003econtactFinder\u003c\/em\u003e columns are still empty.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLimits each batch\u003c\/strong\u003e to \u003cstrong\u003e50 candidates per run\u003c\/strong\u003e for predictable processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects the LinkedIn URLs\u003c\/strong\u003e from those rows into a single list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls an Apify actor\u003c\/strong\u003e to look up email addresses for each LinkedIn profile in a single run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches results back to the correct row\u003c\/strong\u003e using LinkedIn URL normalization (ignores differences like \u003cem\u003ewww\u003c\/em\u003e, trailing slashes, and letter case).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets\u003c\/strong\u003e with the found email (or leaves it empty if none was found) and marks the row as \u003ccode\u003edone\u003c\/code\u003e in \u003ccode\u003econtactFinder\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRecruiting teams maintaining a Google Sheets pipeline of LinkedIn candidates.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who need to enrich leads for outbound campaigns without leaving spreadsheets.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an email-finding step powered by Apify and tracked in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: reads candidate rows and writes back \u003cem\u003eemail\u003c\/em\u003e + \u003ccode\u003econtactFinder\u003c\/code\u003e status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify (via n8n)\u003c\/strong\u003e: finds candidate emails from LinkedIn URLs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used\u003c\/strong\u003e: Manual Trigger \/ Schedule Trigger, Google Sheets, Limit (50 per run), Code (URL normalization + row matching), and supporting notes like Sticky Note.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup\u003c\/h3\u003e\n\u003cp\u003eCopy the example Google Sheet, add your candidates (including LinkedIn URLs), connect your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and \u003cstrong\u003eApify\u003c\/strong\u003e credentials, select your sheet in the nodes, test with Execute workflow, then activate the schedule to process new candidates automatically.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46232382701747,"sku":"N8N-21068","price":47.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/F0Bq58SFgfYX119ZiossH_aIKmPh4D.png?v=1792141564","url":"https:\/\/buyflowscripts.com\/products\/n8n-template-find-candidate-emails-from-linkedin-apify-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}