How To
Feb 16, 2024

Lead Nurturing Using AI Generated Text Messages

How much time does it take you to draft a message campaign for your leads? 

You segment your leads to cold, warm, and hot. Then, think of a perfect message for each segment. You either write them yourself or use an AI tool like ChatGPT for each of these 3 messages. But what if you wanted to generate an individualized prompt for each lead?

You are going to need a way to repeat the AI prompt over and over again.

What if I say you can use Gigasheet to craft custom messages for all your leads - no matter how many they are - in seconds, using an individualized AI prompt? And yes, you won’t be the one writing a single one those messages.

Let’s see how you can use Gigasheet to create AI generated text messages for your leads. 

AI Text Message Generator

The goal is to use Gigasheet AI to write custom messages for your leads. This blog is  not about the Sheet Assistant Co-pilot that helps you analyze your data - another notable feature of Gigasheet AI. You can watch a video about Sheet Assistant here. This one’s all about enrichment! 

Here’s how you ChatGPT to generate messages in bulk

Suppose you want to reach out to several leads about a new product update. Here’s how you can go about it. 

Step 1: Upload/ Create a list of leads. 

If you’re already using Gigasheet, you’ll have your own list of leads within the software. If not, you can import one, no matter what the size is. 

You just have to sign up (for free) and then click on “New > File Upload.” 

Upload list of leads to create ai generated text messages

As you can see, there are multiple sources from where you can upload a file. It includes Google Drive, Dropbox, One Drive, AWS S3, and more. 

Once you upload a file, it will look like this in Gigasheet: 

Leads in Gigasheet

Step 2: Find “OpenAI-GPT for Gigasheet Enrichment

You’ll find “enrichments” on the taskbar in Gigasheet. 

Click Enrichments to begin ai generated text messages

If not, you can find “Functions > Enrichments”

Select “OpenAI - GPT for Gigasheet”. 

Select the GPT enrichment

Step 3: Enter your prompt

Now, you enter the prompt for ChatGPT to create a custom message for your leads.

Insert a prompt to create ai generated text messages

Here’s a prompt for this scenario:

“Act as the marketing head at Zavier who wants to inform his leads about the latest feature launch - Automated Flows. You want to run a text message campaign customized with their First Name and Last Name. Guess their pain points by keeping their Job Title in mind. Also, make sure the email subject starts with their First Name. If their first name is missing, guess it from their Email Address. The tone should be semi-profession with a balance of formality and friendliness.”

Paste it into the box:

The prompt is ready for customization

Now it's time to customize it! Use the Insert Column Reference button to merge in columns from your spreadsheet for the words highlighted in bold. Simply highlight text where you want to place the value from a column and click Insert Column Reference. You will be presented with a list of columns. Choose the appropriate one and click on the column name.

Merge in columns to create individualized prompts for ai generated text messages

Think of an old fashioned mail merge, or a Mad Libs if you want to go way back to childhood! The values denoted by the "****" are where your spreadsheet values will be merged in. Here's what it looks like when we have done it for all columns:

The prompt is ready for execution

and it reads like this:

“Act as the marketing head at Zavier who wants to inform his leads about the latest feature launch - Automated Flows. You want to run a text message campaign customized with their first name  ****First Name**** and Last Name ****Last Name****. Guess their pain points by keeping their Job Title ****Title**** in mind. Also, make sure the email subject starts with their First Name ****First Name****. If their first name is missing, guess it from their Email Address ****Email****. The tone should be semi-profession with a balance of formality and friendliness.”

The ‘temperature’ feature is to set the tonality of your messages. It ranges from 0 for well-defined to 1 for creative.  Here we will go with the middle option.

Once you write the prompt and set the temperature, click on test. 

Step 4: Preview

At this point, Gigasheet will provide 3 responses based on your prompt. You can read what ChatGPT generated and if you don’t like any of them, you can simply go back and edit your prompt. This may take some trial and error.

Once you’re satisfied with the generated messages, click on Apply

Sample of ai generated text messages

Next, Gigasheet will ask you to confirm your enrichment request. Click Run.

Confirm execution on entire list

Step 5: Generate messages 

Time to sit back and relax while Gigasheet auto-generates your messages. 

The enrichment is running

Once complete, you will be notified!

It worked! You now have ai generated text messages

Gigasheet will add brand-new columns to your spreadsheet. 

This is how it looks: 

ai generated text messages

Use the right panel to view the row data. It makes it easier to read paragraphs.

Viewing in paragraph form

You can click on a specific row to view the full message and customize it to your requirements. 

Pretty neat, in my opinion. The file is ready to be exported and loaded into your SMS tool for sending.

Lead Nurturing with AI Generated Text Messages Made Easy

Gone are the days when you spent hours crafting the perfect messages for your leads. Gigasheet has successfully reduced that time to mere seconds. 

Do you have a list of leads that you want to reach out to? Sign up for Gigasheet today and start sending those messages. 

The ease of a spreadsheet with the power of a database, at cloud scale.

No Code
No Database
No Training
Sign Up, Free

Similar posts

By using this website, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.