menu_1

Automate eCommerce product description writing with OpenAI GTP3

Updated on 3 Jan 2023 by Elliott Davidson


I was thinking, wouldn’t it be great if you could automate writing eCommerce product descriptions with OpenAI GTP3. I know there are other AI writing tools out there, but none of them integrate with either your eCommerce store or into Google Sheets. Being able to integrate these allows you to bulk upload this data, saving you having to copy and paste descriptions 100s of times.

It is worth noting that the output isn’t 100% ideal but a good starting point and a massive time saver for a retailer site to then get your copywriter to tweak. It helps give them a starting point rather than having to come up with this from scratch.

To leverage this power, you can use the Google Apps script below to pull off this wizardry.

Step 1) Navigate to Google Apps Script within Google Sheets (Go to Google Sheet → Extensions → App Script)


Step 2) Copy and paste the following code into your Google Apps Script Project

/**
 * Generates text using OpenAI's GPT-3 model
 * @param {string} prompt The prompt to feed to the GPT-3 model
 * @param {string} cell The cell to append to the prompt
 * @param {number} [maxWords=10] The maximum number of words to generate
 * @return {string} The generated text
 * @customfunction
 */

function runOpenAI(prompt, cell, maxWords) {

const API_KEY = "YOUR API KEY";

maxTokens = 150
if (maxWords){maxTokens = maxWords * 0.75}

model = "text-davinci-003"
prompt = prompt+cell+":",
temperature= 0

 // Set up the request body with the given parameters
 const requestBody = {
 "model": model,
 "prompt": prompt,
 "temperature": temperature,
 "max_tokens": maxTokens
 };
 console.log(requestBody)

 // Set up the request options with the required headers
 const requestOptions = {
 "method": "POST",
 "headers": {
 "Content-Type": "application/json",
 "Authorization": "Bearer "+API_KEY
 },
 "payload": JSON.stringify(requestBody)
 };

 // Send the request to the GPT-3 API endpoint for completions
 const response = UrlFetchApp.fetch("https://api.openai.com/v1/completions", requestOptions);

 console.log(response.getContentText())
 
 // Get the response body as a JSON object
 const responseBody = JSON.parse(response.getContentText());


 let answer= responseBody.choices[0].text


 // Return the generated text from the response
 return answer
}


Step 3) Sign-Up to Open AI

Step 4) Once you have an account, get your API key

4.1) Click on your name in the top-right corner

4.2) Click on view API Keys

4.3) Create new secret key

4.4) Copy the key


Step 5) Paste your key inside your Apps Script project, replacing the text “YOUR API KEY”

Step 6) Save your project and go back to your sheet


You are now ready to use the “=runOpenAI()” function and insert your prompt” like in the example I used of “=runOpenAI("write a 100 word product description that is light hearted and funny",F2)”.

For the reference cell in my example F2, I would suggest using your product title or a current product summary.

That is it. You can now bulk automate your eCommerce product description writing. I hope this helps. If you need any help with your eCommerce marketing please do get in contact with us.