G
GTM Vault
Browse
  • Dashboard
    • Automations
    • Skills
    • Prompts
    • Makers
  • Sign in
Loading setup wizard...
Back to Generate personalized sales emails with LinkedIn data & Claude 3.7 via OpenRouter

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

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.

What This Automation Does
1

Load leads from Google Sheets

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

2

Search for LinkedIn profiles via Apify

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

3

Fetch detailed LinkedIn profile data

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

4

Gather company information

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

5

Generate personalized email with Claude 3.7

Sends enriched lead and company data to OpenRouter's Claude 3.7 model to create customized outreach emails.

6

Send email via Gmail

Automatically delivers the AI-generated personalized email to the lead through your connected Gmail account.

Prerequisites

  • Google Sheets account with lead data
  • Gmail account with API access
  • Apify account and API credentials
  • OpenRouter account and API key
  • Company details and value proposition configured

Services Used

Http RequestGoogle SheetsLm Chat Open RouterGmail

Services with alternatives — you can swap them in the next step.