AutomationMart
Home/Browse/Generate personalized sales emails with LinkedIn data & Claude 3.7 via OpenRouter
n8n

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

n8nn8n19 modulesv1.0
GmailGoogle SheetsLinkedIn

How it works - The automation loads rows from a Google Sheet of leads that you want to contact. - It makes a Google search via Apify for LinkedIn links based on the First name / Last name / Company. - Another Apify actor fetches the right LinkedIn profile based on the first profile which is retuned - The same process is done for the company that the lead works for, giving extra context. If the lead has a current company listed on their LinkedIn, we use that URL to do the lookup, rather than d

At a glance

Generate personalized sales emails with LinkedIn data & Claude 3.7 via OpenRouter is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets, LinkedIn
Modules
19
Price
Free
Version
v1.0
Generate personalized sales emails with LinkedIn data & Claude 3.7 via OpenRouter workflow diagram

About this workflow

How it works - The automation loads rows from a Google Sheet of leads that you want to contact. - It makes a Google search via Apify for LinkedIn links based on the First name / Last name / Company. - Another Apify actor fetches the right LinkedIn profile based on the first profile which is retuned - The same process is done for the company that the lead works for, giving extra context. If the lead has a current company listed on their LinkedIn, we use that URL to do the lookup, rather than doing a separate Google search. - A call is made to OpenRouter to get an LLM to generate an email based on a prompt designed to do personalized outreach. - An email is sent via a Gmail node. Set up steps - Connect your Google Sheets + Gmail accounts to use these APIs. - Make an account with Apify and enter your credentials. - Set your details in the "Set My Data" node to customize the workflow to revolve around your company + value proposition. I would recommend changing the prompt in the "Generate Personalized Email" node to match the tone of voice that you want your agent to have. You can change the guidelines to e.g. change whether the agent introduces itself, and give more examples in the style you want to make the output better.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

🚀 Automated Stripe payment recovery: track failures & follow-up emails

Automated Stripe Payment Recovery Workflow (n8n) Detect failed payments, log them, and send polite follow-up emails to recover revenue — all automated with n8n. --- ✅ Part A – Detect & log failed payments What it does: Listens for failed Stripe payments. Extracts customer & payment info. Logs them neatly in Google Sheets for follow-up. 🧩 Nodes: 1️⃣ Stripe Trigger Listens to: 2️⃣ Set node Extracts & ma

Free

Track new YouTube videos with custom search criteria and save to Google Sheets

Stay updated with the latest YouTube content by tracking new videos using custom search criteria and saving the results to Google Sheets. Effortlessly monitor relevant uploads every hour, with a schedule adjustable via the clock icon on the first module.

Free

Generate consistent styled images from references with Google Gemini and Sheets

Who’s it for This workflow is designed for creators, designers, and automation builders who need to generate visually consistent images at scale. It is ideal for teams producing branded visuals, social media assets, or AI-generated images where preserving a recognizable visual style is important. If you already manage prompts and image references in Google Sheets and want a repeatable, automated image generation pipeline, this template is a good fit. How it works / What it does The workflow is

Free

Create .SRT subtitles & .LRC lyrics from audio with Whisper AI and GPT-5-nano

Overview This workflow automates the entire process of creating professional subtitle (.SRT) and synced lyrics (.LRC) files from audio recordings. Upload your vocal track, let Whisper AI transcribe it with precise timestamps, and GPT-5-nano segments it into natural, singable lyric lines. With an optional quality control step, you can manually refine the output while maintaining perfect timestamp alignment. Key Features - Whisper AI Transcription: Word-level timestamps with multi-language support

Free

Generate visual summary & knowledge graph insights for your email

The Ultimate Gmail Analysis and Visual Summarization Template This workflow showcases various useful Gmail search, filter, and AI categorization operations and generates a knowledge graph for your mail using the InfraNodus GraphRAG API, which you can use to reveal the main topics and blind spots in your correspondence. InfraNodus will then target those blind spots to generate interesting research questions for you and send the topical summary and insights via Telegram. You can also click the ge

Free

Automated customer feedback analysis & response with Jotform, GPT-4.1 & Google Sheets

AI-powered feedback analysis and response automation from Jotform to Google Sheets and Slack Who’s it for Businesses using Jotform to collect customer feedback who want to automate sentiment analysis, email responses, and internal reporting — especially eCommerce, support, or CX teams looking to scale without hiring more agents. --- How it works This workflow captures every new Jotform submission, extracts key fields, and uses OpenAI GPT-4.1 to classify sentiment and root cause. - Negative fe

Free

Generate and Send Personalized Quotations PDF

This Template Demonstrates How To Automate Generating and Sending Personalized Quotations as PDF. Use cases are many: send branded quotations to new leads after a discovery call, distribute pricing proposals to inbound form submissions, or push service packages to prospects. All without manually creating documents, exporting PDFs, or writing individual emails. Good to know OpenAI charges per token. The workflow uses gpt-4o-mini for cost efficiency ($0.15/1M input tokens). Check OpenAI Pricing b

Free

Automate Cal.com meeting attendee management with Google Sheets, Beehiiv & Telegram

This n8n workflow template automates the process of managing meeting guests booked through Cal.com. It captures attendee information, logs it in a Google Sheet, and subscribes new guests to your Beehiiv newsletter, while also notifying you in Telegram. How it Works This workflow is designed to streamline your post-booking process. When a new meeting is booked via Cal.com, the workflow automatically triggers. It extracts the attendee details, adds a new row with the guest's information to a desig

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free