New name, same great experience.

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

Are you ready to take your Google Sheets game to the next level? Look no further than SheetMagic, a powerful script that allows you to integrate the OpenAI GPT-3.5+ language models directly into your spreadsheets. With SheetMagic, you can generate human-like text and automate complex tasks with ease. Here’s how to get started:

Step 1: Install SheetMagic

Login to your SheetMagic account.

  • Click on the big green button that says “Access SheetMagic”
  • This will open up the most recent version of SheetMagic in a Google Sheet

Step 2: Create a copy of your Google Sheet

Once you have opened SheetMagic, you’ll need to create a copy of your Google Sheet to use it within your own team. Follow these steps:

  1. Open the Sheet you want to use with SheetMagic.
  2. Go to File -> Make a copy to create a copy of your Sheet.
  3. This copy is where you will use SheetMagic.

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 API 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 the dropdown next to “Help” and select “SheetMagic -> Set API Key”.
  2. NOTE: You may need to go through some authorization steps in order to be able to use the process. There is sometimes a warning that you need to bypass in order to get to the product!
  3. Paste your API key in the dialog box and click “Save”.

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!

Conclusion

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. Happy scripting!