What This Workflow Does
This automation solves the challenge of scaling personalized outreach while maintaining quality. Traditional sales emails often feel generic, while truly personalized emails take too much time to research and write manually.
The workflow automatically generates highly relevant emails by combining LinkedIn profile data with Claude 3.7's advanced natural language capabilities. It pulls key details from LinkedIn profiles to create emails that reference specific interests, job roles, and mutual connections—resulting in 3-5x higher response rates compared to generic templates.
How It Works
1. Lead List Processing
The workflow starts by reading your Google Sheet containing lead names, companies, and basic contact information. Each row represents a potential prospect you want to reach out to.
2. LinkedIn Profile Lookup
Using Apify's Google search integration, the workflow finds LinkedIn profiles matching each lead's name and company. It extracts key profile details like job title, recent posts, skills, and mutual connections.
Pro tip: Add a "personalization score" column to your spreadsheet to prioritize leads most likely to respond to personalized outreach.
3. AI Email Generation
The workflow sends the LinkedIn data to Claude 3.7 via OpenRouter, with instructions to craft a natural, personalized email that references specific profile details while maintaining your brand voice.
4. Email Delivery
The final personalized email can be delivered through your preferred email service (Gmail, Outlook, etc.) or added back to your CRM for manual review before sending.
Who This Is For
This workflow is ideal for:
- Sales teams doing outbound prospecting
- Recruiters reaching out to potential candidates
- Business development professionals
- Anyone who needs to scale personalized communication
What You'll Need
- An n8n instance (cloud or self-hosted)
- Google Sheets with your lead list
- Apify account for LinkedIn searches
- OpenRouter API key for Claude 3.7 access
- Email service connected to n8n
Quick Setup Guide
- Download the JSON template file
- Import into your n8n instance
- Connect your Google Sheets, Apify, and OpenRouter credentials
- Customize the AI prompt to match your brand voice
- Test with a small batch of leads before full deployment
Key Benefits
5x faster outreach: Generate personalized emails in seconds that would take 10-15 minutes to research and write manually.
Higher response rates: Emails referencing specific LinkedIn details get 3-5x more replies than generic templates.
Consistent quality: Maintain high personalization standards across your entire outreach team.
Scalable process: Handle hundreds of personalized outreaches with the same effort as a few dozen manual emails.