Train GPT for Work with your files

info

Currently, only GPT for Excel and GPT for Sheets support this method.

OpenAI Assistants can be used as models in GPT for Work to tailor your results based on specific instructions and data.

This guide shows how to generate product descriptions using customer reviews and marketing briefs uploaded to an Assistant.

Create and set up an Assistant

To create and set up an Assistant to use your files as context for generating responses:

1. On the OpenAI platform, click Create to create an Assistant.

   

2. Upload the files that you want the Assistant to use as context when generating responses:

   1. Enable File search and click Files.

      

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

      

You have created an Assistant and set it up to use your files as context for generating responses.

info

We recommend trying executions in the OpenAI Playground to understand the cost before using it massively.

Prompt an Assistant from GPT for Work

Prerequisite

You have set your OpenAI API key in GPT for Excel or GPT for Sheets.

To prompt an Assistant from GPT for Work:

1. In GPT for Excel or GPT for Sheets, select the Assistant in the model switcher.

   

2. On the Bulk tools tab, click Custom prompt.

3. Enter the following prompt:

   Write a description for this product: {{A}}

4. In Put results in column, select B.

5. Click Run rows.

The Assistant searches for information in the files uploaded and uses it to generate content in the selected column. The Instructions as well as Temperature and Top P settings defined during the Assistant creation are taken into account in GPT for Work.