Here is a step-by-step guide on how to create Shopify product descriptions in bulk using Chat GPT without the need for any paid tools:
What you will need:
- Open AI API Key
- A Google Account with access to Google Sheets
- Google Sheet Chat GPT Plugin (Linked Here)
- Exported Shopify product catalog
- COPY GOOGLE SHEET TEMPLATE HERE
- Export your Shopify product catalog. If you need help with this, watch this Shopify how-to video (link provided).
- Once exported, you'll have a .csv file in your computer's download folder.
- Import that .csv file to Google Sheets by selecting "File > Import > Upload File" and import it as "Insert as new sheet".
- Format your page and rename it to "Exported Product List Shopify" or something similar.
- At the bottom of the spreadsheet, paste your prompt in a cell (e.g., C:26).
- Add the formula "=chatgpt(B1)" to the first product description column (e.g., column C) and drag it all the way down to the last product. This formula will scan the product title and generate a corresponding product description for that product cell. The formula will be highlighted in yellow.
- After dragging the formula down to the last product, Chat GPT will do its work. Sit back and relax.
- Review the product descriptions and export them as a CSV file.
- Re-import the updated CSV file into Shopify by following the instructions on how to import products to Shopify.
With these easy steps, you can quickly generate high-quality product descriptions for your Shopify store using Chat GPT and Google Sheets, without the need for any paid tools.
Chat GPT Prompt Example copy and paste this into your own spreadsheet and adjust GPT prompt as need:
Copy/Paste & Edit This ChatGPT Prompt into Google Sheets
Copy and paste the following text:
As a Shopify store owner, writing product descriptions can be a time-consuming task. However, with the power of Chat GPT, you can generate product descriptions in bulk and streamline your content strategy. In this video, I'll show you how I used Chat GPT and Google Sheets to write 1000+ product descriptions for my Shopify store.
First, I needed to establish a format for my product descriptions. For example, I needed to include the scientific name, maximum size, temperature, pH, temperament, and current diet for each fish in my fish store. Then, I created a Chat GPT template that would output descriptions in the desired format.
To generate product descriptions for other fish, I used the GPT for Sheets extension. This allowed me to run the Chat GPT script on other cells and generate product descriptions quickly and easily. The script would scan the cell and output the product description in HTML format, which I could then copy directly into Shopify.
Once I had generated all of my product descriptions, I imported them into Shopify and checked that they were properly formatted. I also made sure to preserve the data by copying and pasting values only into a new sheet.
In the end, using Chat GPT and Google Sheets saved me a lot of time and effort in writing product descriptions for my Shopify store. With consistent and high-quality product descriptions, I was able to improve my store's performance and increase sales. If you're a content marketer or Shopify store owner looking to take your content strategy to the next level, be sure to check out this video and try Chat GPT for yourself!