Writing High-Converting Messages with AI (No Copywriting Degree Required)

Let’s be real, writing cold outreach messages sucks.

It takes time, effort, and most people aren’t even good at it.

The result? Low responses, lost leads, and wasted time.

Not only is the time wasted—it’s lots of time wasted: 

If you want to write a good outreach message, you better read your prospect’s profile carefully and include important information.

And this is slow!

But here’s the thing: You don’t need to be a copywriting pro to send killer outreach messages. 

Neither do you need to spend hours on the task.

All you need is AI and a bit of behind-the-scenes automation magic.

Imagine this:

You can draft perfectly tailored messages to every new LinkedIn contact you add in minutes!

AI does it for you, based on Role, Task, and Format (RTF) prompting – something I teach in my course.

Let me break it down:

The Role? The AI is your personal copywriter.

The Task? Write a highly personalized message that gets your contact's attention without sounding spammy.

The Format? Clear language, impressive accomplishment from their profile, and a simple ask about what they’re working on.

All based on profile data you take from the prospect’s LinkedIn profile automatically. 

Here’s the complete prompt:

**Your role:** You’re a proficient copywriter who specializes in writing cold outreach messages to new LinkedIn contacts.

**Example message:** Your message must adhere to the following format:

“Hi [name], saw that you’re [condense their job title into one word] in [condense the industry they’re in into one word] in London. I work as a generative IA consultant, usually living in Barcelona, but staying in Barcelona for a few weeks to meet cool people. You caught my attention with [insert a short and impressive fact from their profile description]. Looking forward to keeping in touch! What are you currently working on that you’re excited about? Cheers, Robert”

**Profile Information (Data):** You’ll be using the following person’s LinkedIn profile information:

 - Name: [insert name]
 - LinkedIn headline: [insert headline]
 - Additional information: [insert additional info]
 - LinkedIn profile description (About section): [insert profile desc]

**Instructions:** Draft an introduction message for this new contact on LinkedIn according to the example format.

Boom. Done.

Now, the prompt is all well and good, but there are a few logistical details to figure out here.

How do you get the person’s profile information from LinkedIn? How do you do this for many contacts without wasting hours on copy-pasting?

First, we’ll have to get the profile data of our prospects into Google Sheets, so we’ll have a structured starting point.

We’ll use a free scraper called Bardeen, which is a browser extension for Chrome.

It basically simulates manual actions on your behalf very fast—such as clicking or copy-pasting information from a web page into spreadsheet fields.

We start with a LinkedIn search, setting a few filters. Say I want to get in touch with marketing executives in Barcelona:

After I’ve set the filters at the top (people, location, industry, and services offered), I see a list of people whom I might be interested in.

Then I open the Bardeen extension to copy all 323 results into a spreadsheet:

The interface is similar to that of Zapier or other no-code automation builders. It essentially consists of three steps:

1. Scrape (i.e. copy) the entries from the opened page

2. Create a new tab in a spreadsheet in my Google Drive

3. Paste all contacts into that sheet

This is how the scraping step looks like:

I changed the names here, but you’ll essentially get all the information that’s visible on the search page. 

Bardeen premium also offers an option to do “deep scraping”, meaning it will open each person’s profile page and copy everything on there. (Remember, the search results page shows a few details only)

For our demo, this should be enough. But you can take the personalization as far as you wish.

How do we get this data and the prompt into ChatGPT? Surely, we won’t copy-paste it… that’s not why you’ve signed up for this newsletter, have you!

There’s a neat Google Sheets extension called GPT for Sheets. It doesn’t look as fancy as Bardeen.

In fact, it looks like nothing at all, because it just introduces new formulas into Google Sheets!

After installation we’ll have access to the =GPT() formula, which sends any data to ChatGPT and fills the cell content with the result.

I see you’re starting to get it by now.

We’ll assemble our prompt inside the spreadsheet for each contact. We’ll use =CONCATENATE(), which glues different pieces of text together.

Our prompt will look like this:

=CONCATENATE("**Your role:** You’re a proficient copywriter who specializes in writing cold outreach messages to new LinkedIn contacts.

**Example message:** Your message must adhere to the following format:

'Hi [name], saw that you’re [condense their job title into one word] in [condense the industry they’re in into one word] in London. I work as a generative IA consultant, usually living in Barcelona, but staying in London for a few weeks to meet cool people. You caught my attention with [insert a short and impressive fact from their profile description]. Looking forward to keeping in touch! What are you currently working on that you’re excited about? Cheers, Robert'

**Profile Information (Data):** You’ll be using the following person’s LinkedIn profile information:

Name: ",B2 ,"
 - LinkedIn headline: ",E2 ,"
 - Additional information: ",G2 ,"
 - LinkedIn profile description (About section): ",C2 ,"

**Instructions:** Draft an introduction message for this new contact on LinkedIn according to the example format.
")

Wow! We’ve just created a prompt template that generates a different prompt for every row!

One last step:

Send it to ChatGPT by wrapping it inside the =GPT() function:

=GPT(CONCATENATE("**Your role:** You’re ... “))

Press enter and BOOM:

Because it’s a formula we can drag it onto as many cells as we want, generating messages in bulk!

The final step is to send the message out. You’ll copy-paste it into the chat box, have a quick look over it to see if nothing’s off & make final adjustments, and click send.

Now, you’ve got a message that doesn’t just sit in their DM inbox—it gets read, and it gets replies.

This isn’t theory.

It’s something you can start doing today with the right AI tools.

I’ve helped tons of business owners use this method, and they’re closing more deals faster than ever.

If you want to see it in action, I’ve got a video case study I can send you.

Just hit reply, and I’ll send it your way.

Or, if you’re ready to stop wasting time on bad outreach, I’ve got a community inside which I’ll show you personally how AI can write your next cold message.

Click the link below and say goodbye to leads that ghost you.

👉 Join Make Work Obsolete and up your outreach game

Cheers,
Robert