How to use GPT-4o-mini for Sheets

To use the GPT-4-Mini AI assistant in Google Sheets, follow these steps:

Install the GPT for Sheets Add-On from the GPT-4o-mini for Sheets.
Upgrade your subscription to the Pro User plan for the GPT for Sheets Add-On by visiting GPT-4o-mini for Sheets.
Create an OpenAI API key by:
- Logging into the OpenAI platform
- Clicking “Create new secret key”.
- Copying the generated key.
Open a Google Sheet with the GPT for Sheets Add-On installed. Launch the sidebar by going to Extensions > GPT for Docs, Sheets, Forms, Slides > Launch.
Remove any other add-ons that provide GPT functions to avoid conflicts.
Click the “Refresh account” button, then the “Set Up OpenAI Key” button that appears.
Paste your OpenAI API key where indicated, click “Check”, then “Save”.
Select GPT-4o-mini in select box
Type a simple formula in a cell to get a response from GPT, for example:
```
=GPT("Write a title for coffee shop")
```
After getting the result, click “Replace All GPTs” or “Replace Selected” to replace the formula with the AI-generated text. This is important to avoid the sheet re-executing the formulas frequently, which could impact your OpenAI credits.

By following these steps, you can leverage the power of GPT-4-Mini within Google Sheets to generate text, summarize data, and more. Remember to manage your OpenAI API credits and replace GPT formulas with the results to optimize performance.