Use models with your own API keys
You do not need your own API key to use GPT for Work add-ons, but using your own key offers several benefits:
Models: Access a wider range of models.
Control: Monitor and manage your AI usage and costs directly from the AI provider's console.
Privacy: We do not log inputs and outputs when you use a model with your own API key. See our privacy policy.
Costs: If you're on pay-per-use pricing, using your own API key reduces costs. You pay the model usage fees directly to the AI provider, while paying a reduced service fee for GPT for Work.
Create API keys
To create your own API key, go to the AI provider's platform and follow their instructions:
OpenAI platform for GPT models, fine-tuned models, and OpenAI Assistants.
noteOnly use an API key from an OpenAI organization that is at least Tier 3. Access your organization settings to verify your current tier.
Perplexity platform for Perplexity models.
xAI platform for xAI models.
Google AI Studio for Gemini models.
noteIt may take a few hours for a Gemini API key to become fully activated after creation.
Anthropic console for Claude models.
OpenRouter platform to access multiple AI models through a single API key.
DeepSeek platform for DeepSeek models.
Mistral AI console for Mistral models.
Check your API key (OpenAI)
You can check that your OpenAI API key is working with our API key tester.
Open the API key tester.
Click Use template to create a copy of the template in your own Google Sheets.
Enter your OpenAI API key in cell B12.
The results show the status of your OpenAI API key and the models and Assistants available through your API key.
If your API key is not working, check in the OpenAI platform that its permissions aren't restricted. The following permissions are required:
| Permission | Description |
|---|---|
| Models and Model capabilities | For all API keys |
| Assistants | To connect OpenAI Assistants to Google Sheets / Microsoft Excel |
| Fine-tuning | To connect OpenAI fine-tuned models to Google Sheets / Microsoft Excel |
| Files | To use OpenAI Assistants with File search |
Set API keys in GPT for Work
- Excel
- Sheets
- Word
- Docs
Open a Microsoft Excel workbook.
Click GPT for Excel Word in the Home tab.
infoYou can also go to Home > Add-ins > My add-ins > GPT for Excel Word.
In the sidebar menu, select API keys.
Enter your API key in the appropriate field and click Save.
You have set your own API key in GPT for Excel. You can now expand the model switcher and select one of the models or OpenAI Assistants associated with your API key. These are listed under Use your API key or endpoints.
Use GPT for Excel bulk tools or GPT functions.
Open a Google spreadsheet.
Check your permissions on the current spreadsheet, depending on its location:
My Drive: You must be the Owner of the spreadsheet. You can find out who the Owner of a file is by checking the file details.
Shared Drive: You must be the Creator of the spreadsheet. You can find out who the Creator of a file is by checking the file activity.
If your permissions differ from these, create a Google spreadsheet or ask someone with the appropriate permissions to set up the API key for you.
Select Extensions > GPT for Sheets and Docs > Open.
Select API keys from the sidebar menu.
Enter your API key in the appropriate field and click Save.
You have set your own API key in GPT for Sheets. You can now expand the model switcher and select one of the models or OpenAI Assistants associated with your API key. These are listed under Use your API key or endpoints.
Use GPT for Sheets bulk tools or GPT functions.
Open a Microsoft Word document.
Click GPT for Excel Word in the Home tab.
infoYou can also go to Home > Add-ins > My add-ins > GPT for Excel Word.
In the sidebar menu, select Manage API keys.
Enter your API key in the appropriate field and click Save.
You have set your own API key in GPT for Word. You can now expand the model switcher and select one of the models or OpenAI Assistants associated with your API key. These are listed under Use your API key or endpoints.
Author text with GPT for Word.
Open a Google document.
Select Extensions > GPT for Sheets and Docs > Set API keys.
Enter your API key in the appropriate field and click Save key.
You have set your own API key in GPT for Docs. You can now select Extensions > GPT for Sheets and Docs > Launch to open the sidebar and select one of the models associated with your API key. These models are listed under Use your API key.
Edit and create text with GPT for Docs.
Learn more
For more information about selecting a model, see: