Automate LinkedIn profile research & email outreach with Apify, Gemini & Sheets

This n8n template from [Intuz](https://www.intuz.com/) provides a complete and automated solution for deep-dive lead research and hyper-personalized email generation.

It transforms a basic list of LinkedIn profiles into a campaign-ready database by first enriching contacts with detailed career data and then using AI to craft unique, context-aware emails based on each individual's professional journey.

Who's this workflow for? - Sales Development Representatives (SDRs) - Account Executives (AEs) - B2B Marketers & Growth Hackers - Recruiters & Talent Acquisition Specialists - Startup Founders

How it works 1. Scheduled Data Fetch: The workflow runs automatically on a schedule, fetching a list of leads (containing LinkedIn URLs) from a Google Sheet.

2. Enrich Profiles with Apify: For each lead that hasn't been processed, it uses an Apify actor to scrape their LinkedIn profile, extracting key information like their "About" section and detailed work experience.

3. Update Central Database: The scraped career history is saved back into a "Profile Data" column in the original Google Sheet, creating a rich, centralized lead profile.

4. AI Email Personalization: The workflow sends the complete, enriched profile data to a Google Gemini AI model via LangChain, using a sophisticated prompt that instructs it to act as an expert B2B copywriter.

5. Craft a Unique Hook: The AI analyzes the lead's entire career journey to find unique "nuggets"—like long tenure, specific achievements, or unusual career paths—and uses them to write a compelling opening line.