Who is this solution for?

Ideally, in an ideal scenario, each potential customer would transform into a devoted patron, and the necessary data preparation to reach that point would require less time. Luckily, there is a complimentary AI assistant called GPT for Google Sheets that aids in expediting the tasks associated with marketing campaigns. It efficiently cleanses data, generates compelling email subject lines to enhance open rates, and offers additional functionalities.

AI Tools Used


Step 1: Install GPT for Google Sheets

1. Click on this link to Install GPT for Google Sheets from the Google Workspace Marketplace.
2. Once installed, you’ll see the GPT for Sheets icon in the right sidebar of Google Sheets.
3. Open the Extensions menu,  select GPT for Sheets, and Enable custom Functions in this sheet to access all GPT functions.

Step 2: Use GPT for Google Sheets Functions for Email Marketing

First, the basics of how it works. To ask GPT to perform a function, it accepts the following syntax (statements):
=GPT([prompt], [value], [temperature], [max_tokens], [model])
And this is the input accepted for each parameter (definition):
prompt: This parameter shouldn’t be left empty. You can populate it with text, a cell, or a range of cells to tell GPT to do something.
value (optional): This accepts text, a cell, or cell range values to which you want the prompt to apply.
temperature (optional): This controls the creativity level and accepts a number between 0 and 1.
max_tokens (optional): Allows you to control the number of tokens used for each request. The higher the number, the longer and more detailed the text. It accepts a number between 0 and the model limit.
model (optional): You can specify the base model to perform the function. For example, gpt-4 is the default.
We’ll stick to populating the prompt and value parameters in these examples for simplicity. For more GPT function information and tutorials, consider visiting the GPT Space website.
Now, let’s get stuck in!
GPT function 
​​The GPT function is the primary and most straightforward function that can be used to output an answer. It’s ideal for creating eye-catching taglines and subject lines to market your brand and for more effective prospecting emails.
Let’s say you wanted a subject line to send emails about your organic foods business; in any cell, enter the following prompt:
=GPT(Write an email subject line for an organic foods store). Then hit Enter for a response. We got:
“Fresh and Organic: Stock up on Healthy Goodness at Our Store!”
Specific email subject line:
For a more specific prompt, you can specify the tone and country of the shop, etc.,
In any cell type: =GPT(, highlight the data range to provide the value. Close the brackets, then hit Enter. 

We got: “Get your daily dose of greens and giggles at our organic store!”
GPT_FILL function
You can use the GPT_FILL function to clean up and standardize your email address data to avoid bounce backs when sending mass emails.
You may need to clean up an email address list. By offering an example of how you want the email addresses formatted, GPT will do the rest. GPT for Sheets does offer other ways to clean data which you’ll discover as you become more familiar with the tool.
Below we have a list of dirty email addresses and some examples of how we want them cleaned:

In any cell type: =GPT_FILL(, highlight the data range with the inconsistent addresses and cleaned-up examples, and add a comma (,). Now highlight the range of data that needs cleaning, close the brackets and hit Enter:

We got:
GPT_FORMAT function
The GPT_FORMAT function can standardize your phone numbers to save time contacting leads dialing incorrect numbers. This function can also be used to standardize many different types of unreadable text in your Sheets, including:
case e.g. sentence, upper, camel, lower;
currency amounts;
company names
You could set a list of phone numbers to its international format.
In any cell, type =GPT_FORMAT(, highlight or type the cell range, add a comma (,). Type “international phone number,” close the bracket, and hit Enter.

We got: