skip to content

The new OpenAI GPT-4o model is now available in SheetMagic!

Getting Started with SheetMagic: A Guide to using Google Sheets with ChatGPT

Published by Curran Van Waarde

Ready to take your Google Sheets game to the next level? Look no further than SheetMagic, a powerful Google Sheets add-on that allows you to integrate OpenAI directly into your spreadsheets. With SheetMagic, you can generate text and automate complex tasks in Google Sheets with ease. Here’s how to get started:

Step 1: Install SheetMagic

Go to the official SheetMagic Google Sheets Addon and click install. Easy.

Step 2: Create a copy of SheetMagic Starter Sheet

Our starter sheet is helpful because it gives easy access to all functions and our prompt library. Here’s how to access it:

  1. Click here to go to the starter sheet
  2. Go to File -> Make a copy to create a copy of the Sheet.

Step 3: Create an OpenAI account and API key

In order to use SheetMagic, you’ll need to have an OpenAI account and create a new secret key for SheetMagic. Here’s how to do it:

  1. Go to OpenAI’s website and create an account (if you don’t have one already).
  2. Once you’re logged in, go to the API Keys page.
  3. Click on “New Secret Key” and give it a name like “SheetMagic”.
  4. Copy the API key that is generated.

IMPORTANT NOTE: You may need to add a card on file to the account first before creating an API key is an option!

Step 4: Set your OpenAI API key & license key in SheetMagic

Now that you have an OpenAI API key, you’ll need to set it in SheetMagic. Here’s how:

  1. In your Google Sheet, click on Extensions -> SheetMagic -> Save OpenAI API Key to Google Account.
  2. Paste your API key in the dialog box and click “Save”.

NOTE: If you want to share your sheet with other teammates or contractors without giving them your API key, you can use the “Save OpenAI Key to Sheet” instead.

Next, we’ll also need to get our SheetMagic license key into the tool. Here’s how:

  1. Go to your SheetMagic account
  2. Click on the License Management tab
  3. Click copy on your license key
  4. Go back to your Google Sheet and go to Extensions -> SheetMagic -> Verify SheetMagic License Key and save your license key there.

Step 5: Use SheetMagic in your Google Sheet

Congratulations! You’re now ready to start using SheetMagic. Here’s how to use it:

  1. In any cell in your Sheet, type =ai("your prompt here") to call ChatGPT.
  2. To use multiple cells in your prompt, separate them with commas. For example, =ai("the beginning of your prompt,", A3, A5).
  3. Press Enter and watch SheetMagic generate text based on your prompt!


With SheetMagic, you can take your Google Sheets to the next level by generating human-like text and automating complex tasks. Follow these simple steps to get started and unlock the full potential of your spreadsheets. Stay magical!

Connect your email to get started with SheetMagic

Already have an account? Click here to login

Earn up to 40% lifetime recurring commissions with our affiliate program