Generate Personalized Sales Emails with LinkedIn Data & Claude 3.7 via OpenRouter
VerifiedGenerates personalized sales emails from Google Sheets leads using OpenRouter AI.
What this workflow does
This automation retrieves rows from Google Sheets and leverages OpenRouter's AI capabilities with structured parsing to produce tailored sales emails based on lead details.
It suits sales teams and marketers seeking to automate personalized outreach while integrating data sources and email delivery in n8n.
Who is this for?
Sales development reps, account executives, and small sales teams who manage lead lists in spreadsheets and want to scale personalized outreach.
What problem it solves
Manually researching LinkedIn profiles and writing tailored emails for each lead is slow and inconsistent; this workflow automates enrichment and generation so reps can focus on sending.
What it automates
Cold outreach to new leads
Import a Google Sheet of prospects and auto-generate personalized emails using LinkedIn profile and company data before sending via Gmail.
Follow-up sequences for warm leads
Trigger the workflow on updated rows in a Google Sheet to refresh LinkedIn context and produce a new personalized email for existing contacts.
Event or campaign-based emailing
Batch-process leads from a specific company list in Sheets to create context-rich emails referencing recent company news pulled from LinkedIn.
How the workflow works
The 6 nodes in this automation, in order.
- 1Google SheetsgoogleSheets
- 2HTTP RequesthttpRequest
- 3Gmailgmail
- 4Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
- 5Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
- 6OpenRouter Chat Model@n8n/n8n-nodes-langchain.lmChatOpenRouter
Apps & integrations used
How to set up Generate Personalized Sales Emails with LinkedIn Data & Claude 3.7 via OpenRouter
- 1Add a Google Sheets node and connect your credential to read lead rows (First name, Last name, Company).
- 2Use HTTP Request nodes to call Apify actors for LinkedIn profile search and full profile scrape.
- 3Add a second HTTP Request or conditional branch to fetch company LinkedIn data when available.
- 4Connect the Basic LLM Chain with OpenRouter Chat Model (Claude 3.7) and Structured Output Parser to generate the email.
- 5Map the generated email body into a Gmail node and send to the lead's address.
- 6Test the full flow on a few rows and activate the workflow.
How to customize this workflow
- →Swap OpenRouter model to any other supported LLM without changing the chain.
- →Replace Gmail with another email node such as Outlook or SMTP.
- →Add a filter after Google Sheets to only process rows where email status is empty.
- →Insert a Set node to store generated emails back into the Google Sheet for logging.
Generate Personalized Sales Emails with LinkedIn Data & Claude 3.7 via OpenRouter: pros & cons
Pros
- +Combines data enrichment and LLM generation in one flow
- +Uses OpenRouter so you can pick cost/performance trade-offs easily
- +Outputs structured email content ready for Gmail
- +Starts from a simple Google Sheet trigger most teams already have
Cons
- –Depends on external Apify actors (extra cost and maintenance)
- –No built-in lead deduplication or consent checking
- –Email quality still requires prompt tuning per industry
Frequently asked questions
It reads leads from Google Sheets, enriches them with LinkedIn data via Apify, generates a personalized sales email with Claude 3.7 on OpenRouter, and sends it through Gmail.
User reviews
Verified reviews from the community shape this listing's rating.
Loading reviews…
Similar workflows
Other ai & llm automations worth a look.