Generate personalized sales emails with LinkedIn data & Claude 3.7 via OpenRouter

Automatically scrapes LinkedIn profiles, enriches lead data, and sends personalized outreach emails via Gmail using AI.

workflowlead_generation

by Adam Janeson n8n

Nodes

Triggers

Platform

n8n

Tech Stack

Google Sheets

AI Agent

OpenRouter

Gmail

How It Works

This automation loads leads from Google Sheets, searches for their LinkedIn profiles and company data via Apify, then uses Claude 3.7 through OpenRouter to generate personalized sales emails. The AI-generated emails are automatically sent through Gmail, creating a complete lead enrichment and outreach pipeline.

Load leads from Google Sheets

Retrieves lead data including first name, last name, and company information from your Google Sheets spreadsheet.

Search for LinkedIn profiles via Apify

Performs Google search using Apify to find LinkedIn profile links based on lead name and company information.

Fetch detailed LinkedIn profile data

Uses another Apify actor to scrape comprehensive profile information from the identified LinkedIn profiles.

Gather company information

Collects additional context about the lead's current company, either from their LinkedIn or through separate lookup.

Attached Files

workflow.json