Connect OpenAI Assistants to Google Sheets / Excel
OpenAI Assistants provide a powerful way to customize OpenAI models for specific tasks.
This guide shows how to create an Assistant if you don't have one yet, and how to use it in GPT for Excel or GPT for Sheets.
Create an OpenAI Assistant
The following steps show how to create an Assistant from scratch. If you already have an Assistant, you can skip to Use an Assistant in GPT for Work.
Go to the OpenAI platform and click Create.
Configure your Assistant:
- Name: Give your Assistant a name that describes its purpose.
- Instructions: Provide detailed instructions for the Assistant's behavior and capabilities.
- Model: Choose an appropriate model, typically
gpt-4o. Learn more.
If you want your Assistant to use specific files for reference, use the File search feature to attach them:
Enable File search and click Files.
In the file attachment screen, select the files and click Attach.
You have created an Assistant. You can now use the Assistant in GPT for Work.
Use an OpenAI Assistant in GPT for Work
After you've created your Assistant, you can use it in GPT for Work.
- Set your OpenAI API key in GPT for Excel or GPT for Sheets.
Select the Assistant in the model switcher.
The GPT for Work extension now uses your Assistant for executing bulk tools and GPT functions. The Instructions as well as Temperature and Top P settings defined during the Assistant creation are taken into account in GPT for Work.