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 & OpenRouter 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 API key

In order to use SheetMagic, you’ll need to have your own API key. Here’s how to do it:

Option 1: OpenAI API key(recommended)

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!

Option 2: OpenRouter API key

1. Go to OpenRouter and create an account (if you don’t have one already).
2. Once you’re logged in, go to the Keys page.
3. Choose an existent key or create a new one by clicking on “Create key”.
4. Copy the desired API key.

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

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

Option 1: Set OpenAI API key

1. In your Google Sheet, click on Extensions -> SheetMagic -> Set OpenAI API key.
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.

Option 2: Set OpenRouter API key

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

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!

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. Stay magical!