Connect to custom GPTs from Sheets and 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.

To use a custom GPT as an OpenAI Assistant:

1. Replicate the custom GPT as an Assistant.

2. Set an OpenAI API key for your space.

3. Select the Assistant in GPT for Sheets or GPT for Excel.

Create an Assistant based on a custom GPT

1. Log in to ChatGPT.

2. Edit the custom GPT.

   

3. Copy the instructions from the custom GPT.

   

4. Log in to the OpenAI Platform.

5. Open the Assistants settings and click Create.

6. Configure the Assistant:

   • Name: Enter the custom GPT name.

   • System instructions: Enter the custom GPT instructions.

   • Model: Choose an appropriate model, for example gpt-4o. Learn more.

   

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

   1. Enable File search and click Files.

      

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

      

You have created an Assistant that replicates the custom GPT. You can now use the Assistant in GPT for Sheets and GPT for Excel.

Set an OpenAI API key for your space

G Sheets

1. Create an API key or request an API key from your AI provider platform admin. Learn more.

2. Sign in to the GPT for Work dashboard with your Google account.

3. In the sidebar, select API keys.

4. In the AI providers list, click the provider whose API key you want to set.

   

5. Set the API key:

   1. In the text field, enter the key.

   2. Click Check to verify that the key is valid.

   3. Click Save.

   

MS Excel

1. Create an API key or request an API key from your AI provider platform admin. Learn more.

2. Sign in to the GPT for Work dashboard with your Microsoft account.

3. In the sidebar, select API keys.

4. In the AI providers list, click the provider whose API key you want to set.

   

5. Set the API key:

   1. In the text field, enter the key.

   2. Click Check to verify that the key is valid.

   3. Click Save.

   

Select the OpenAI Assistant

G Sheets

1. Open a Google spreadsheet.

2. In the menu bar, select Extensions > GPT for Sheets and Docs > Open.

   

3. In the sidebar menu, select Bulk AI tools or GPT functions.

4. Expand the model switcher. You can find the Assistant under Use your API key or endpoint.

   

5. Select the Assistant.

GPT for Sheets now uses the Assistant to generate responses for bulk AI tools and GPT functions.

MS Excel

1. Open a Microsoft Excel workbook.

2. In the Home tab, click GPT for Excel Word.

   

   info

   You can also select Home > Add-ins > My Add-ins > GPT for Excel Word.

3. In the sidebar menu, select Bulk AI tools or GPT functions.

4. Expand the model switcher. You can find the Assistant under Use your API key or endpoint.

   

5. Select the Assistant.

GPT for Excel now uses the Assistant to generate responses for bulk AI tools and GPT functions.

What's next

• Train GPT for Work on your files.