Using LinkedIn Data for personalizing Cold Emails with ChatGPT

Eric Popivker
ENTech Solutions
Published in
4 min readJan 31, 2024

In my previous post I demonstrated how to automate getting LinkedIn data into Google Sheet.

In this one we will use LinkedIn data to personalize content for emails, using ChatGPT.

Prompt Engineering

Prompt Engineering is a way to provide better instructions to AI/ChatGPT, to get better results. With every release ChatGPT keeps improving in understanding what is being asked, by parsing and interpreting common English (and other languages). But it is not quite there yet.

Prompt Engineering is just another way to say:

  • be concise and direct about what you need
  • provide examples
  • test several approaches to improve results

Prompt for Generating Cold Email

Here is a prompt I came up with for Generating Cold email.

Create text for outreach email for leads from LinkedIn.

Tone: conversational.
Length: max of 5 sentences.
Misc: No small talk or corporate jargon.

My Target Audience has following characteristics:
• Small startups with 1-10 employees
• Located in United States
• Had Seed or Angel funding so
• Looking to grow their technology team
• Looking for best value on Senior Developers

My company offers the following Services:
• Fractional CTO Services.
• Help company with technical vision, infrastructure and architecture.
• Optimize Development Processes according to best industry standards
• Teach Agile/Lean methodologies
• Build team with top remote developers

It includes:

  • Specific task for ChatGPT to perform
  • Limitations for content
  • Target Audience
  • Services offered by my company

Here is the reply from ChatGPT:


Subject: Elevate Your Startup's Tech Game with Expert Guidance

Hi there,

I noticed your startup's impressive journey and believe we can help
amplify your tech capabilities. Our team specializes in providing
Fractional CTO services, focusing on crafting your technical vision
and optimizing development processes with industry best practices.
We're passionate about teaching Agile/Lean methodologies and building
your team with top remote developers, ensuring you get the best value
for your investment. Let's connect to explore how we can support
your growth and enhance your technology team.

Best,
[Your Name]

Not bad, but it can be better.

Personalize Cold Email

In last post I retrieved lead information from LinkedIn using Apollo.io and PandaFlow.io.

Now I can take the lead data from Google Sheet and append it to generic prompt. The prompt now looks like this:

Create text for outreach email for leads from LinkedIn.

Tone: conversational.
Length: max of 5 sentences.
Misc: No small talk or corporate jargon.

My Target Audience has following characteristics:
• Small startups with 1-10 employees
• ...

My company offers the following Services:
• Fractional CTO Services.
• Help company with technical vision, infrastructure and architecture.
• ...

Use the following lead data in JSON format:
{
company:
{
name: "ImpactBeta",
summary: "ImpactBeta is a new media platform that redraws the boundaries of business in a new era of investing. Investment News for a Sustainable Edge.",
location: "Berkley, California"
specialities: "Impact Investment Reporting, Transparency, Social Enterprises, and ESG"
},
employee:
{
name: "John Smith",
position: "Chief Operating Officer & Co-founder",
}
}

ChatGPT now responds with:

Hello John,

I came across ImpactBeta and was impressed by your focus
on impact investment and ESG initiatives. I believe our
fractional CTO services could greatly complement your mission,
especially for a forward-thinking company like yours. We offer
personalized guidance in technical infrastructure and architecture,
aiming to align closely with your goals.

If enhancing ImpactBeta's technological framework interests you,
I'd be eager to discuss how we can work together.

Warm regards,
[Your Name]

So ChatGPT was able to use the information I provided to personalize email a bit.

I came across ImpactBeta and was impressed by your focus
on impact investment and ESG initiatives.

is much better than generic:

I noticed your startup’s impressive journey and believe we can help
amplify your tech capabilities.

Write Email Content to Google Sheet using PandaFlow

To automate email content generation and store it in google sheet, once again I will use PandaFlow.io

Here is the updated flow:

I added two steps. A Javascript step to dynamically generate Prompt from LinkedIn data and a second step that calls OpenAI API to get the content for the email.

Afterwards, the content of the email is written to Google Sheet and will be picked up by Email Agent which I will describe in next post.

Conclusion

In this article I demonstrated how to use LinkedIn data to personalize email content. I utilized ChatGPT generative AI to create email content and PandaFlow.io to automate it.

In next post, I will show how to automate sending personalized emails using SmartLead.ai.

--

--

Eric Popivker
ENTech Solutions

Living in .NET world for 20+ years. Founder of .NET Fiddle.