Set up your OpenAI API key | GPT for Work Documentation (2024)

Set up your own OpenAI API key to benefit from cost savings and from your own rate limits, or to use your fine-tuned models and Assistants.

Prerequisites
  1. Check your permissions on the current spreadsheet, depending on its location:
    1. 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.
    2. 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 OpenAI API key for you.

  2. Select Extensions > GPT for Sheets and Docs > Open.
  3. The sidebar appears on the right of your workbook.

  4. Select API keys from the add-on menu.

    Set up your OpenAI API key | GPT for Work Documentation (1)

  5. Paste your secret key where indicated, then click Save.

    Set up your OpenAI API key | GPT for Work Documentation (2)

  6. (Optional) Enter your OpenAI organization ID from the OpenAI Organization settings page, then click Save. If you are part of multiple organizations, it ensures that you get billed on the correct account.

    Set up your OpenAI API key | GPT for Work Documentation (3)

  7. (Highly recommended) Test your OpenAI API key:
    1. Open the model switcher dropdown, and select one of the OpenAI models that use your API key.

      Set up your OpenAI API key | GPT for Work Documentation (4)

    2. Type a simple formula in a cell and get a response from GPT:
      =GPT("Write a tagline for a car")

You have set up your OpenAI API key in GPT for Sheets and Docs.

note

When using an OpenAI API key, you need to purchase credits from OpenAI and also buy a pack in GPT for Sheets. Learn more

What's next

Set up your OpenAI API key | GPT for Work Documentation (2024)

FAQs

Set up your OpenAI API key | GPT for Work Documentation? ›

Once you've created your OpenAI account or logged into an existing one, you'll see your name's initials and profile icon at the top-right corner of the OpenAI dashboard. To generate an OpenAI API key, tap on your name to view the dropdown menu. Click the 'View API keys' option.

How do I set up my OpenAI API key? ›

Once you've created your OpenAI account or logged into an existing one, you'll see your name's initials and profile icon at the top-right corner of the OpenAI dashboard. To generate an OpenAI API key, tap on your name to view the dropdown menu. Click the 'View API keys' option.

Can you use OpenAI API for business? ›

Yes, as long as you have an OpenAI Key from OpenAI itself.

How to use OpenAI for work? ›

Let's assume you're an absolute beginner at OpenAI API and get you to make your first API call in a step-by-step fashion.
  1. Step 1: Create an OpenAI platform account. ...
  2. Step 2: Get your API key. ...
  3. Step 3: Install the OpenAI Python library. ...
  4. Step 4: Making your first API call. ...
  5. Step 5: Exploring further.

Can I share my OpenAI API key? ›

As you begin experimenting, you may want to expand API access to your team. OpenAI does not support the sharing of API keys. Please invite new members to your account from the Members page and they will quickly receive their own unique key upon sign-in. You can assign permissions to individual API keys as well.

How do I activate my API key? ›

  1. In the Google Cloud console, go to the Credentials page: Go to Credentials.
  2. Click Create credentials, then select API key from the menu. The API key created dialog displays the string for your newly created key.

Is OpenAI API key free or paid? ›

There is no “free account” for API. The use of the service costs money by the amount of data used. There is only possibility of a free trial credit, which expires three months after you first created your OpenAI account. Now you'll need to purchase a credit balance in order to make calls.

Can I use OpenAI for commercial use? ›

Subject to your compliance with these Terms, OpenAI hereby assigns to you all its right, title and interest in and to Output. This means you can use Content for any purpose, including commercial purposes such as sale or publication, if you comply with these Terms.

Is OpenAI HIPAA compliant? ›

OpenAI signs a BAA and is therefore HIPAA compliant.

Why is my OpenAI API key not working? ›

Resolving OpenAI API Key Problems: Step-by-Step Fixes

Double-check your API Key for accuracy. Generate a new API Key if your current one has expired. Review your API usage and ensure you haven't exceeded rate limits. Verify that your OpenAI account is in good standing.

How do companies use OpenAI? ›

By monitoring competitors' websites, social media, and online activities, OpenAI provides real-time market updates with artificial intelligence in business. They can track competitors' strategies, pricing changes, and customer sentiment, allowing for informed decision-making and adjustments to stay competitive.

What can I do with an OpenAI API? ›

The OpenAI API provides a simple interface to state-of-the-art AI models for natural language processing, image generation, semantic search, and speech recognition.

How do I activate my OpenAI API key? ›

Set up your OpenAI API key
  1. Check your permissions on the current spreadsheet, depending on its location: ...
  2. Select Extensions > GPT for Sheets and Docs > Open.
  3. Select API keys from the add-on menu.
  4. Paste your secret key where indicated, then click Save.

How to securely use OpenAI API key? ›

Store your API key in environment variables within your development environment. This ensures the key is not hard-coded into your application, making it less likely to be exposed. If you're using GitHub Actions, use GitHub secrets to keep your API key secure.

Can other people use my API key? ›

API keys are generally not considered secure; they are typically accessible to clients, making it easy for someone to steal an API key. Once the key is stolen, it has no expiration, so it may be used indefinitely, unless the project owner revokes or regenerates the key.

How to generate API key for ChatGPT? ›

We'll help you do just that by breaking down each step of getting your API key.
  1. Step 1: Create an account. ChatGPT is entirely free to sign up. ...
  2. Step 2: Generate an API key. Once logged in, head to the left navigation bar and click “API Keys” ...
  3. Step 3: Set up billing. ...
  4. Step 4: Set usage limits.

Where do you store the OpenAI API key as a best practice? ›

Avoid exposing the API keys in your code or in public repositories; instead, store them in a secure location. You should expose your keys to your application using environment variables or secret management service, so that you don't need to hard-code them in your codebase.

How do I authenticate OpenAI API? ›

The OpenAI API uses API keys for authentication. You can create API keys at a user or service account level. Service accounts are tied to a "bot" individual and should be used to provision access for production systems.

Top Articles
Car Salesman Salary: The Complete Guide Know Your Pay in 2023
Google Interview Questions & Process – VirtualSpeech
Navicent Human Resources Phone Number
Truist Bank Near Here
Ups Stores Near
855-392-7812
Chambersburg star athlete JJ Kelly makes his college decision, and he’s going DI
Voordelige mode in topkwaliteit shoppen
Unitedhealthcare Hwp
Wfin Local News
Lenscrafters Westchester Mall
Craigslist - Pets for Sale or Adoption in Zeeland, MI
Western Razor David Angelo Net Worth
House Share: What we learned living with strangers
Call Follower Osrs
Craigslist Pets Athens Ohio
Cvb Location Code Lookup
The Superhuman Guide to Twitter Advanced Search: 23 Hidden Ways to Use Advanced Search for Marketing and Sales
Suffix With Pent Crossword Clue
Nevermore: What Doesn't Kill
Kayky Fifa 22 Potential
Transactions (zipForm Edition) | Lone Wolf | Real Estate Forms Software
Unionjobsclearinghouse
Lakewood Campground Golf Cart Rental
Rimworld Prison Break
Phantom Fireworks Of Delaware Watergap Photos
NV Energy issues outage watch for South Carson City, Genoa and Glenbrook
25Cc To Tbsp
What are the 7 Types of Communication with Examples
Microsoftlicentiespecialist.nl - Microcenter - ICT voor het MKB
What Time Does Walmart Auto Center Open
Unity Webgl Player Drift Hunters
Laurin Funeral Home | Buried In Work
Case Funeral Home Obituaries
20+ Best Things To Do In Oceanside California
Die Filmstarts-Kritik zu The Boogeyman
Why I’m Joining Flipboard
Ramsey County Recordease
Gfs Ordering Online
How to Print Tables in R with Examples Using table()
10 Rarest and Most Valuable Milk Glass Pieces: Value Guide
Ig Weekend Dow
Seven Rotten Tomatoes
Lorton Transfer Station
Playboi Carti Heardle
2000 Ford F-150 for sale - Scottsdale, AZ - craigslist
Food and Water Safety During Power Outages and Floods
Home | General Store and Gas Station | Cressman's General Store | California
Mike De Beer Twitter
28 Mm Zwart Spaanplaat Gemelamineerd (U999 ST9 Matte | RAL9005) Op Maat | Zagen Op Mm + ABS Kantenband
Latest Posts
Article information

Author: Manual Maggio

Last Updated:

Views: 6163

Rating: 4.9 / 5 (69 voted)

Reviews: 84% of readers found this page helpful

Author information

Name: Manual Maggio

Birthday: 1998-01-20

Address: 359 Kelvin Stream, Lake Eldonview, MT 33517-1242

Phone: +577037762465

Job: Product Hospitality Supervisor

Hobby: Gardening, Web surfing, Video gaming, Amateur radio, Flag Football, Reading, Table tennis

Introduction: My name is Manual Maggio, I am a thankful, tender, adventurous, delightful, fantastic, proud, graceful person who loves writing and wants to share my knowledge and understanding with you.