Skip to main content

Connect custom GPTs to Google Sheets / Excel

While custom GPTs are only available inside ChatGPT, you can easily replicate a custom GPT as an OpenAI Assistant, which you can then use outside ChatGPT. The only difference between custom GPTs and Assistants is that Assistants cannot search the web.

This guide shows you how to create an Assistant that replicates your custom GPT, and use it in GPT for Excel or GPT for Sheets.

Create an Assistant based on a custom GPT​

To use a custom GPT configuration in GPT for Work, you need to recreate it as an Assistant.

  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 the Assistant:

    • Name: Enter your custom GPT name.

    • Instructions: Enter your custom GPT instructions.

    • Model: Select gpt-4o, which is the model used by all custom GPTs.

      Paste your GPT settings in the Assistant

  5. If your custom GPT uses knowledge files, upload the same files for the Assistant:

    1. Enable File search and click Files.

      Upload files

    2. In the file attachment screen, select the files and click Attach.

      Attach files to the Assistant

You have created an Assistant that replicates your custom GPT configuration. You can now use the Assistant in GPT for Work.

Use an Assistant in GPT for Work​

After you've created your Assistant, you can use it in GPT for Work.

  1. Set your OpenAI API key in GPT for Excel or GPT for Sheets.

  2. Select the Assistant in the model switcher.

    OpenAI Assistant selected in the model switcher

The GPT for Work extension now uses your Assistant for executing bulk tools and GPT functions, with the same instructions and knowledge as your original custom GPT.

What's next

Train GPT for Work with your files.

On this page