Running ChatGPT prompts in bulk

Use Cases

Anything you’ve been using ChatGPT for online, you can now do in bulk with the Excel ChatGPT Bulk Prompt Tool.

• Bulk Email Marketing Prompts: Create personalized content for each person on your mailing list.
• Update Product Descriptions: Modify product descriptions in bulk, making them shorter or longer.
• A/B Testing Titles: Generate alternative titles for A/B testing with ease.
• Translate Product Descriptions: Convert product descriptions to different languages efficiently.
• Extract Key Points from Text: Summarize long articles or reports into concise key points.
• Generate Content Ideas: Create engaging content ideas based on specific keywords.
• Customer Feedback Analysis: Analyze and categorize customer feedback to identify common themes.
• Personalize Sales Pitches: Create tailored sales pitches based on customer data.
• Social Media Post Ideas: Generate engaging social media content ideas in bulk.
• Grammar and Spelling Check: Correct grammar and spelling in large text documents.
• Analyze Social Media Sentiment: Monitor brand sentiment across social media platforms.
• Generate Quiz Questions: Create quiz questions based on specific topics.
• Generate Marketing Taglines: Create catchy and relevant marketing slogans.
• Identify Trends in Feedback: Analyze customer feedback to identify trends and insights.
• Shorten Blog Titles in Bulk: Condense lengthy blog titles quickly for impactful, attention-grabbing headlines.
• Analyze Blog Content: Categorize blog posts efficiently, ensuring they are published correctly.
• SEO Keyword Detection: Identify optimal focus keywords to boost search engine rankings.

What is the difference between ChatGPT and GPT-4?

ChatGPT is the online interface that allows users to interact with OpenAI’s language models in a conversational manner. GPT-4, on the other hand, is the underlying AI model that powers these interactions. While ChatGPT refers specifically to the web-based chat application, GPT-4 represents the advanced AI capabilities used for generating human-like text.

Although we refer to ChatGPT in our descriptions, the Excel ChatGPT Bulk Prompt Tool actually connects directly to the OpenAI API service, utilizing GPT-4 and GPT-4o models. This distinction is important to understand, but we use “ChatGPT” to make it easier for our users to grasp the tool’s functionality. Our tool leverages the power of GPT-4 through the API to process bulk prompts efficiently and effectively.

Which is better, GPT-4, or GPT-4o?

Our updated Excel tool, has two macro options, one for GPT-4, and the other for GPT-4o. GPT-4o is the most recent model launched by OpenAI and it is much cheaper to use than GPT-4. Our suggestion is you start with GPT-4o, and if you don’t achieve the answers you want, switch to GPT-4, which may be more suitable for more complex tasks. Remember the answers you get are only as good as the prompts, so you should always try different instructions if you are not achieving the output you require.

We have an article on real examples of ChatGPT api costs, which is based on GPT-4o. The cost of GPT-4 is around 5 times more, depending on the input/output of the instructions.

How to Set Up and Use Our Excel ChatGPT Bulk Prompt Tool

Setting up and using our Bulk Text Assistant is straightforward. Follow these simple steps to get started and maximize the powerful features of our Excel-based tool.

Download the Excel Template

First of all, you will need to purchase and download the Excel ChatGPT Bulk Prompt Tool here. Once this is done, return here to continue with the setup.

Step-by-Step Setup Guide

1. Sign Up for an OpenAI API Key
   • Visit OpenAI’s platform to create an account and obtain your API key. This key allows you to access the GPT-4 language model and its capabilities. OpenAI provides free credits for new accounts, which you can use to get started. Remember to monitor your usage to keep costs within your budget. Your API key will start with “sk-“.
2. Configure the Workbook Settings
   • Open the Excel workbook you received from Corner Milestone and navigate to the “Settings” sheet.
   • Locate the designated cell for the API key and paste your OpenAI API key into it. This step enables the workbook to connect to the OpenAI API and access its features.
3. Input Your Text and Instructions
   • Switch to the “Main” sheet. You will see three columns with some demo data and formulas:
     • Column A: This is the original text you want to use in your prompt.
     • Column B: Write specific instructions in the format of a formula for each row (e.g., “shorten this text,” “suggest a keyword,” “write a title”). Use Excel formulas to customize the instructions based on the text in Column A. For example, ="Create a single word category for this text: " & A1.
     • Column C: This column will display the AI-generated responses based on your instructions. Ensure it is empty before running the macro.
     • Tip: The Macro will run on any column in a sheet, and insert its answer in the next column to the right, allowing you to run different prompts on the same text.
4. Test the Responses
   • Before processing the entire dataset, test a few cells to ensure the instructions generate the desired responses. Select the first few cells in Column A and run the ChatGPT macro. Review the output in Column C and adjust the instructions in Column B if necessary. The Macro will run on all selected cells.
5. Run the Macro on the Entire Dataset
   • Once you are satisfied with the test responses, run the ChatGPT macro on the entire dataset. The macro will process each selected cell with its prompt, inserting the AI-generated response into the column next to it.

Running the Macro

• ALT + F8: Press these keys together to open the Macro window.
• Select the appropriate ChatGPT macro for the model you want to use (GPT-4 or GPT-4o).
• Click “Run” to execute the macro and process your dataset

All Set!

That’s all there is to it, should have just unlocked some extreme efficiency thanks to AI. Below are some further information you may find useful as well as some videos we’ve recorded of the tool in use.

Case Study Demo Videos

ChatGPT is not giving me the answers I expect

Sometimes, ChatGPT may not provide the exact answers you’re expecting. Here are some tips to help you fine-tune your prompts and get the desired results:

1. Test Prompts Online First:
   • Before running bulk prompts with the Excel ChatGPT Bulk Prompt Tool, try your prompts on the online version of ChatGPT. This allows you to experiment with different phrasing and instructions until you achieve the desired results.
2. Refine Your Instructions:
   • If ChatGPT responses include unnecessary text like “Based on the text you provided…” or “Here is your answer…”, you can refine your instructions to be more specific. Add clear instructions to your prompt, such as “Just give the requested information with no additional text.” This helps ChatGPT understand that you only want the direct answer.
3. Example Prompts:
   • Instead of: “Can you summarize this text?”
   • Try: “Summarize the text in one sentence. Provide only the summary.”
   • Instead of: “What is the keyword for this content?”
   • Try: “Provide the keyword for this content. Give only the keyword.”

By following these tips, you can ensure that ChatGPT delivers the precise information you need, making your data processing and content creation tasks more efficient and effective.

How to Save, Open, and Run a Macro in the Macro-Enabled Worksheet

1. Save the Macro-Enabled Worksheet
   • After downloading the worksheet, save it as a macro-enabled workbook with the file extension “.xlsm”.
2. Enable Macros
   • When you open the worksheet in Excel, enable macros to ensure functionality. If you don’t see the prompt, follow these steps:
     • Click the “File” tab.
     • Select “Options” > “Trust Center” > “Trust Center Settings…” > “Macro Settings”.
     • Choose “Disable all macros with notification” or “Enable all macros” (not recommended).
     • Click “OK” and reopen the workbook.
3. Run the Macro
   • With macros enabled, click the “Developer” tab, then “Macros”, select the desired macro, and click “Run”.

Support, Refund, and Guarantees

We are committed to providing the necessary support for our tool. For assistance, email us at blog@cornermilestone.com. Please note that all transactions are final, and we do not offer refunds. We recommend testing your data on chat.openai.com before using our tool to ensure you achieve the desired results. We also offer to run a trial set of data for you before purchase.

While we strive to offer a reliable tool, we make no guarantees for every situation. We recommend backing up your data prior to using the tool. Your use of the tool signifies your understanding and acceptance of these terms.