Using Custom GPTs in GPT for Sheets
While Custom GPTs are limited to use within ChatGPT, they can easily be replicated as OpenAI Assistants and used in other applications like GPT for Sheets. The only difference is that OpenAI Assistants cannot search the web, unlike some Custom GPTs. This guide demonstrates how to turn Custom GPTs into OpenAI Assistants and use them in GPT for Sheets to create content within Google Sheets.
Turn a Custom GPT into an OpenAI Assistant
To use a Custom GPT's configuration in GPT for Sheets, you'll need to recreate it as an OpenAI Assistant. Here's how to do it:
Edit your Custom GPT in ChatGPT.
Copy the instructions from your Custom GPT.
Go to the OpenAI platform and create a new assistant.
Configure your assistant:
- Give your assistant the same Name as your Custom GPT.
- Paste the instructions into the Instructions field.
- Choose the same Model as your Custom GPT, typically gpt-4o.
If your Custom GPT uses specific files, upload them to the assistant with the Files button in the File search section. Learn more.
Enable Code interpreter if you used it in your Custom GPT.
Now you have an OpenAI Assistant that replicates your Custom GPT, ready to be used in GPT for Sheets.
Use an OpenAI Assistant in GPT for Sheets
Once you've created your assistant, you can use it in GPT for Sheets:
- Open the GPT for Sheets add-on, and set up your OpenAI API key.
- Select the assistant in the model switcher in GPT for Sheets.
![OpenAI Assistant selected in the model switcher](/help/article-images/gpt-for-sheets/assistants-menu-show.png)
Your OpenAI Assistant will now be used to execute bulk tools and GPT functions in GPT for Sheets, using the same instructions and knowledge as your original Custom GPT.