Skip to main content

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:

  1. Edit your Custom GPT in ChatGPT.

    Configure button for Custom GPT

  2. Copy the instructions from your Custom GPT.

    Custom GPT instructions

  3. Go to the OpenAI platform and create a new assistant.

    Click Create

  4. 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.
    Paste your GPT settings in the assistant

  5. If your Custom GPT uses specific files, upload them to the assistant with the Files button in the File search section. Learn more.

    Upload files

  6. 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:

  1. Open the GPT for Sheets add-on, and set up your OpenAI API key.

  2. Select the assistant in the model switcher in GPT for Sheets.

    3. OpenAI Assistant selected in the model switcher

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.

On this page